DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on PO_HEADERS_ALL

Line 2918: FROM po_headers_all ph,

2914: pll.amount,
2915: pll.value_basis,
2916: pll.matching_basis,
2917: 'Y' lcm_flag
2918: FROM po_headers_all ph,
2919: po_lines_all pl,
2920: po_line_locations_all pll,
2921: po_releases_all pr -- Bug 9734841
2922: WHERE ph.po_header_id = p_po_header_id

Line 3557: FROM po_headers_all ph,

3553: l_po_hdr_rec.org_id, -- 09
3554: l_po_hdr_rec.approved_date, -- 10
3555: l_simulation_rec.freight_code, -- 11
3556: l_simulation_rec.org_id -- 12
3557: FROM po_headers_all ph,
3558: po_releases_all pr
3559: WHERE ph.po_header_id = pr.po_header_id
3560: AND pr.po_release_id = p_po_release_id;
3561:

Line 3600: FROM po_headers_all ph

3596: l_po_hdr_rec.org_id, -- 10
3597: l_po_hdr_rec.approved_date, -- 11
3598: l_simulation_rec.freight_code, -- 12
3599: l_simulation_rec.org_id -- 13
3600: FROM po_headers_all ph
3601: WHERE po_header_id = p_po_header_id;
3602: END IF;
3603:
3604: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 4318: po_headers_all ph,

4314: po_vendors pv1,
4315: po_vendor_sites pvs,
4316: po_vendors pv,
4317: po_releases pr, -- Bug 14280113
4318: po_headers_all ph,
4319: inl_simulations s
4320: WHERE pr.po_header_id (+) = ph.po_header_id -- Bug 14280113
4321: AND pvs1.vendor_site_id = s.vendor_site_id
4322: AND pv1.vendor_id = s.vendor_id

Line 4720: FROM po_headers_all ph,

4716: SELECT ph.vendor_id,
4717: ph.vendor_site_id,
4718: pl.item_id,
4719: pll.ship_to_organization_id
4720: FROM po_headers_all ph,
4721: po_lines_all pl,
4722: po_line_locations_all pll
4723: WHERE ph.po_header_id = pl.po_header_id
4724: AND pl.po_line_id = pll.po_line_id