APPS.INV_RCV_STD_DELIVER_APIS dependencies on PO_LINES

Line 1658: , po_lines pol

1654: , rcv_supply rsup
1655: , rcv_shipment_headers rsh
1656: , rcv_shipment_lines rsl
1657: , mtl_system_items msi
1658: , po_lines pol
1659: , po_distributions pod
1660: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
1661: AND rsup.to_organization_id = p_organization_id
1662: AND pod.line_location_id = rsup.po_line_location_id

Line 2039: , po_lines pol

2035: , rcv_supply rsup
2036: , rcv_shipment_headers rsh
2037: , rcv_shipment_lines rsl
2038: , mtl_system_items msi
2039: , po_lines pol
2040: , po_distributions pod
2041: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2042: AND rsup.to_organization_id = p_organization_id
2043: AND pod.line_location_id = rsup.po_line_location_id

Line 2146: , po_lines pol

2142: FROM rcv_transactions rt
2143: , rcv_supply rsup
2144: , rcv_shipment_headers rsh
2145: , rcv_shipment_lines rsl
2146: , po_lines pol
2147: , po_distributions pod
2148: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2149: AND rsup.to_organization_id = p_organization_id
2150: AND pod.line_location_id = rsup.po_line_location_id

Line 2256: FROM po_lines_all pla

2252: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).item_desc IS NULL THEN
2253: BEGIN
2254: SELECT item_description
2255: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).item_desc
2256: FROM po_lines_all pla
2257: WHERE pla.po_header_id =g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).po_header_id
2258: AND pla.po_line_id =g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).po_line_id;
2259: EXCEPTION
2260: WHEN NO_DATA_FOUND THEN