DBA Data[Home] [Help]

APPS.GMF_INTERNAL_ORDERS dependencies on RCV_TRANSACTIONS

Line 128: FROM rcv_transactions t

124: and t.completed_ind = 1
125: and t.delete_mark = 0
126: and oel.inventory_item_id = cp_inv_item_id
127: and prl.requisition_line_id = (SELECT t.requisition_line_id
128: FROM rcv_transactions t
129: ,ic_tran_pnd pnd
130: WHERE t.shipment_header_id = pnd.doc_id
131: and t.transaction_id = pnd.line_id
132: and pnd.doc_type = 'PORC'