DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on INL_SHIP_HEADERS

Line 1239: inl_ship_headers_all ish,

1235: ish.org_id,
1236: rsh.expected_receipt_date
1237: INTO l_ship_ln_group_rec
1238: FROM inl_ship_line_groups ilg,
1239: inl_ship_headers_all ish,
1240: inl_ship_lines_all isl,
1241: rcv_transactions rtr,
1242: rcv_shipment_headers rsh
1243: WHERE ilg.ship_header_id = ish.ship_header_id

Line 1272: FROM inl_ship_headers sh

1268:
1269: -- Getting ship date to be used as currency conversion date
1270: SELECT sh.ship_date
1271: INTO l_qp_curr_conv_date
1272: FROM inl_ship_headers sh
1273: WHERE sh.ship_header_id = p_ship_header_id;
1274:
1275: -- Populate l_ship_ln_tbl
1276: SELECT NULL, -- order_line_id

Line 1313: FROM inl_ship_headers_all ish,

1309: l_qp_curr_conv_date
1310: )) txn_conv_unit_price,
1311: isl.txn_qty -- quantity_received
1312: BULK COLLECT INTO l_ship_ln_tbl
1313: FROM inl_ship_headers_all ish,
1314: inl_ship_lines_all isl,
1315: inl_ship_line_groups isg,
1316: po_headers_all ph,
1317: po_lines_all pl,