DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on PO_LINES

Line 1624: , po_lines pol

1620: , rcv_supply rsup
1621: , rcv_shipment_headers rsh
1622: , rcv_shipment_lines rsl
1623: , mtl_system_items msi
1624: , po_lines pol
1625: , po_distributions pod
1626: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
1627: AND rsup.to_organization_id = p_organization_id
1628: AND pod.line_location_id = rsup.po_line_location_id

Line 2005: , po_lines pol

2001: , rcv_supply rsup
2002: , rcv_shipment_headers rsh
2003: , rcv_shipment_lines rsl
2004: , mtl_system_items msi
2005: , po_lines pol
2006: , po_distributions pod
2007: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2008: AND rsup.to_organization_id = p_organization_id
2009: AND pod.line_location_id = rsup.po_line_location_id

Line 2112: , po_lines pol

2108: FROM rcv_transactions rt
2109: , rcv_supply rsup
2110: , rcv_shipment_headers rsh
2111: , rcv_shipment_lines rsl
2112: , po_lines pol
2113: , po_distributions pod
2114: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2115: AND rsup.to_organization_id = p_organization_id
2116: AND pod.line_location_id = rsup.po_line_location_id

Line 2222: FROM po_lines_all pla

2218: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).item_desc IS NULL THEN
2219: BEGIN
2220: SELECT item_description
2221: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).item_desc
2222: FROM po_lines_all pla
2223: WHERE pla.po_header_id =g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).po_header_id
2224: AND pla.po_line_id =g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).po_line_id;
2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN