[Home] [Help]
1831: FROM
1832: po_lines_all pl,
1833: po_headers_all ph,
1834: po_line_locations_all pll,
1835: inl_simulations s
1836: WHERE
1837: ph.po_header_id = pll.po_header_id
1838: AND pll.line_location_id = p_ship_ln_tbl(l).ship_line_source_id
1839: AND pl.po_line_id = pll.po_line_id
1888: rsh.packaging_code,
1889: DECODE(p_ship_header_rec.simulation_id, NULL,
1890: rsh.freight_carrier_code,
1891: (SELECT s.freight_code
1892: FROM inl_simulations s
1893: WHERE s.simulation_id = p_ship_header_rec.simulation_id)) AS freight_code, -- Bug# 9279355
1894: rsh.freight_terms,
1895: rsh.expected_receipt_date,
1896: rsl.vendor_item_num
2134:
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',
2152: AND sl.ship_line_src_type_code = l_ship_line_src_type_code
2153: AND sl.ship_line_source_id = l_ship_line_source_id
2154: AND s.parent_table_revision_num = (
2155: SELECT MAX(s1.parent_table_revision_num)
2156: FROM inl_simulations s1
2157: WHERE -- s1.parent_table_name = DECODE(sh.interface_source_code,'PO','PO_HEADERS','-1')
2158: sh.interface_source_code = DECODE(s1.parent_table_name,'PO_HEADERS','PO',
2159: DECODE(s1.parent_table_name, 'PO_RELEASES', 'PO', '-1')) -- Bug 14280113
2160: -- AND s1.parent_table_id = sh.interface_source_line_id
2749: p_debug_info => l_debug_info);
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