APPS.GML_OPM_ROI_GRP dependencies on IC_TRAN_PND

Line 1361: FROM rcv_transactions rt , ic_tran_pnd itp

1357: l_rti_secondary_quantity NUMBER;
1358:
1359: Cursor Cr_get_total_qty_available IS
1360: SELECT sum(itp.trans_qty)
1361: FROM rcv_transactions rt , ic_tran_pnd itp
1362: WHERE
1363: rt.shipment_header_id = l_shipment_header_id
1364: AND rt.shipment_line_id = l_shipment_line_id
1365: AND itp.doc_id = rt.shipment_header_id

Line 1377: ic_tran_pnd itp

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
1381: and itp.doc_type = 'RECV'

Line 1390: from ic_tran_pnd itp,

1386: having sum(itp.trans_qty) > 0 ;
1387:
1388: Cursor Cr_old_rtrn_qty Is
1389: Select sum(itp.trans_qty) qty
1390: from ic_tran_pnd itp,
1391: po_Rtrn_dtl d,
1392: po_rtrn_hdr h
1393: where h.return_id = d.return_id
1394: and d.recv_id = l_recv_id

Line 1958: FROM ic_tran_pnd itp

1954: BEGIN
1955: IF nvl(l_comment,'NOT OPM RECEIPT') <> 'OPM RECEIPT' THEN
1956: -- check the lot specified by the user is existing in the DELIVER transaction.
1957: SELECT 'X' INTO l_temp
1958: FROM ic_tran_pnd itp
1959: WHERE
1960: itp.doc_id = l_shipment_header_id
1961: and itp.line_id = l_parent_transaction_id
1962: and itp.doc_type = 'PORC'

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 2429: FROM ic_tran_pnd itp

2425: BEGIN
2426: IF nvl(l_comment,'NOT OPM RECEIPT') <> 'OPM RECEIPT' THEN
2427: -- check the lot specified by the user is existing in the DELIVER transaction.
2428: SELECT 'X' INTO l_temp
2429: FROM ic_tran_pnd itp
2430: WHERE
2431: itp.doc_id = l_shipment_header_id
2432: and itp.line_id = l_parent_transaction_id
2433: and itp.doc_type = 'PORC'

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'