APPS.INL_CHARGE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1834: po_line_locations_all pll,

1830: l_ship_ln_tbl(l - ln_index + 1).item_id
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

Line 1855: po_line_locations_all pll

1851: l_ship_ln_tbl(l - ln_index + 1).need_by_date,
1852: l_ship_ln_tbl(l - ln_index + 1).item_revision,
1853: l_ship_ln_tbl(l - ln_index + 1).item_id
1854: FROM po_lines_all pl,
1855: po_line_locations_all pll
1856: WHERE pl.po_line_id = pll.po_line_id
1857: AND pll.line_location_id = p_ship_ln_tbl(l).ship_line_source_id;
1858: END IF;
1859: END IF;

Line 2164: po_line_locations_all pl

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
2168: AND s1.firmed_flag = 'Y');