APPS.INL_CHARGE_PVT dependencies on INL_SHIP_LINES_ALL

Line 2140: inl_ship_lines_all sl

2136: SELECT sl.ship_line_id
2137: INTO l_simul_ship_line_id
2138: FROM inl_simulations s,
2139: inl_ship_headers_all sh,
2140: inl_ship_lines_all sl
2141: WHERE -- s.parent_table_name = DECODE(sh.interface_source_code,'PO','PO_HEADERS','-1')
2142: sh.interface_source_code = DECODE(s.parent_table_name,'PO_HEADERS','PO',
2143: DECODE(s.parent_table_name, 'PO_RELEASES', 'PO', '-1')) -- Bug 14280113
2144: -- AND s.parent_table_id = sh.interface_source_line_id

Line 2241: FROM inl_ship_lines_all sl

2237: CURSOR c_ship_ln(p_ship_header_id NUMBER) IS
2238: SELECT sl.ship_line_id,
2239: sl.primary_qty,
2240: sl.org_id
2241: FROM inl_ship_lines_all sl
2242: WHERE sl.ship_header_id = p_ship_header_id;
2243:
2244: TYPE ship_ln_list_type IS TABLE OF c_ship_ln%ROWTYPE;
2245: ship_ln_list ship_ln_list_type;

Line 2275: inl_ship_lines_all sl,

2271: cl.poa_party_site_id,
2272: cl.poo_organization_id,
2273: cl.poo_location_id
2274: FROM inl_charge_lines cl,
2275: inl_ship_lines_all sl,
2276: inl_allocations a
2277: WHERE cl.charge_line_id = a.from_parent_table_id
2278: AND sl.ship_line_id = a.ship_line_id
2279: AND from_parent_table_name = 'INL_CHARGE_LINES'

Line 2755: inl_ship_lines_all sl2, -- Simulated Shipment Line

2751: SELECT COUNT(*)
2752: INTO l_firm_simulation
2753: FROM inl_simulations s,
2754: inl_ship_headers_all sh,
2755: inl_ship_lines_all sl2, -- Simulated Shipment Line
2756: inl_ship_lines_all sl1 -- ELC Shipment Line
2757: WHERE s.simulation_id = sh.simulation_id
2758: AND s.firmed_flag = 'Y'
2759: AND sh.ship_header_id = sl2.ship_header_id

Line 2756: inl_ship_lines_all sl1 -- ELC Shipment Line

2752: INTO l_firm_simulation
2753: FROM inl_simulations s,
2754: inl_ship_headers_all sh,
2755: inl_ship_lines_all sl2, -- Simulated Shipment Line
2756: inl_ship_lines_all sl1 -- ELC Shipment Line
2757: WHERE s.simulation_id = sh.simulation_id
2758: AND s.firmed_flag = 'Y'
2759: AND sh.ship_header_id = sl2.ship_header_id
2760: -- AND sl2.ship_line_src_type_code = DECODE(s.parent_table_name,'PO_HEADERS','PO','-1') -- Bug 14280113