APPS.INL_CHARGE_PVT dependencies on INL_SHIP_LINE_GROUPS

Line 566: l_to_parent_tbl_name_order CONSTANT VARCHAR2(30) := 'INL_SHIP_LINE_GROUPS';

562:
563: l_proc_name CONSTANT VARCHAR2(30) := 'Get_ChargesFromQP';
564: l_request_type CONSTANT VARCHAR2(2) := 'PO';
565: l_pricing_event CONSTANT VARCHAR2(20) := 'PO_RECEIPT';
566: l_to_parent_tbl_name_order CONSTANT VARCHAR2(30) := 'INL_SHIP_LINE_GROUPS';
567: l_to_parent_tbl_name_line CONSTANT VARCHAR2(30) := 'INL_SHIP_LINES';
568: l_no_freight_charge EXCEPTION;
569:
570: l_debug_info VARCHAR2(200);

Line 1131: FROM inl_ship_line_groups

1127: p_debug_info => l_debug_info);
1128:
1129: SELECT ship_line_group_id
1130: BULK COLLECT INTO l_ship_ln_group_id_tbl
1131: FROM inl_ship_line_groups
1132: WHERE ship_header_id = p_ship_header_id
1133: ORDER BY ship_line_group_num;
1134:
1135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 1238: FROM inl_ship_line_groups ilg,

1234: NULL, -- conversion_rate_type
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

Line 1315: inl_ship_line_groups isg,

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,
1318: po_line_locations_all pll,
1319: rcv_transactions rtr,