APPS.GML_OPM_ROI_GRP dependencies on GML_RECV_TRANS_MAP

Line 1376: gml_recv_trans_map grm,

1372: Select sum(itp.trans_qty),
1373: itp.doc_id,
1374: itp.line_id
1375: from rcv_transactions rcv,
1376: gml_recv_trans_map grm,
1377: ic_tran_pnd itp
1378: where rcv.transaction_id = l_parent_transaction_id
1379: and rcv.comments = 'OPM RECEIPT'
1380: and rcv.interface_transaction_id = grm.interface_transaction_id

Line 1967: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp

1963: and itp.lot_id = p_lot_id ;
1964:
1965: ELSE
1966: SELECT 'X' INTO l_temp
1967: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp
1968: WHERE rcv.transaction_id = l_parent_transaction_id
1969: and rcv.interface_transaction_id = grm.interface_transaction_id
1970: and grm.recv_id = itp.doc_id
1971: and itp.doc_type = 'RECV'

Line 2438: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp

2434: and itp.lot_id = p_lot_id ;
2435:
2436: ELSE
2437: SELECT 'X' INTO l_temp
2438: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp
2439: WHERE rcv.transaction_id = l_parent_transaction_id
2440: and rcv.interface_transaction_id = grm.interface_transaction_id
2441: and grm.recv_id = itp.doc_id
2442: and itp.doc_type = 'RECV'