DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on INL_SHIP_HEADERS_ALL

Line 2139: inl_ship_headers_all sh,

2135: BEGIN
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

Line 2754: inl_ship_headers_all sh,

2750:
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'