DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on PO_RELEASES_ALL

Line 2147: FROM po_releases_all

2143: DECODE(s.parent_table_name, 'PO_RELEASES', 'PO', '-1')) -- Bug 14280113
2144: -- AND s.parent_table_id = sh.interface_source_line_id
2145: AND sh.interface_source_line_id = DECODE(s.parent_table_name,'PO_HEADERS', s.parent_table_id,
2146: DECODE(s.parent_table_name,'PO_RELEASES',(SELECT po_header_id
2147: FROM po_releases_all
2148: WHERE po_release_id = s.parent_table_id), -1)) -- Bug 14280113
2149: AND s.simulation_id = sh.simulation_id
2150: AND s.firmed_flag = 'Y'
2151: AND sh.ship_header_id = sl.ship_header_id

Line 2163: FROM po_releases_all pr,

2159: DECODE(s1.parent_table_name, 'PO_RELEASES', 'PO', '-1')) -- Bug 14280113
2160: -- AND s1.parent_table_id = sh.interface_source_line_id
2161: AND sh.interface_source_line_id = DECODE(s1.parent_table_name,'PO_HEADERS', s1.parent_table_id,
2162: DECODE(s1.parent_table_name,'PO_RELEASES',(SELECT pr.po_header_id
2163: FROM po_releases_all pr,
2164: po_line_locations_all pl
2165: WHERE pr.po_release_id = s1.parent_table_id
2166: AND pr.po_release_id = pl.po_release_id
2167: AND pl.line_location_id = l_ship_line_source_id), -1))-- Bug 14280113