I have two blocks, one is Master for StockRecv_Master and Second is Detail Block for Stockrecv_Detail. Master Block has it's Own ID StockRECV_ID. Master Block is populating by LOV which is assigned to PO_ID (Purchase Order ID). PO_Master & PO_Detail are separate tables for PO records.
I am trying to execute a cursor with When-Validate-Item Trigger on PO_ID item of Stockrecv_Master block. When a PO is selected then Master Block is populated by LOV from PO_Master table and after that a cursor is opened to fetch records in StockRecv_Detail block form PO_Detail table.
StockRecv_Master is populated by LOV.
StockRecv_Detail is not populated by Cursor. Code for Cursor is as Follow
Cursor PODETAIL is
Select PD.PROD_ID, PM.PROD_NAME, PD.UNIT_ORDERED, PD.UNIT_PRICE, PD.DISCOUNT
from PO_DETAIL PD, PRODUCTMASTER PM
WHERE PD.PROD_ID = PM.PROD_ID
AND PD.PO_ID = :stockrecv_master.PO_ID;
into :stockrecv_detail.prod_id, :stockrecv_detail.prod_name,
exit when podetail%notfound;
I am using Oracle Developer Forms 6i, Database 10g (10.2) and windows XP Pro.