APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on PO_HEADERS_ALL

Line 577: FROM po_headers_all

573: SELECT vendor_id
574: , vendor_site_id
575: INTO l_vendor_id
576: , l_vendor_site_id
577: FROM po_headers_all
578: WHERE po_header_id = p_header_id;
579:
580: SELECT pov.party_id
581: , povs.party_site_id

Line 772: po_headers_all poh

768: , poh.type_lookup_code
769: , poh.segment1
770: , FND_GLOBAL.session_id
771: FROM
772: po_headers_all poh
773: , fnd_currencies fc
774: WHERE poh.currency_code = fc.currency_code
775: AND poh.po_header_id = p_header_id;
776:

Line 835: FROM po_headers_all ph

831: -- , l_vendor_site_id
832: , bill_to_location_id
833: , l_ship_from_location_id
834: ,(SELECT pvs.location_id from po_vendor_sites_all pvs WHERE pvs.vendor_site_id=ph.vendor_site_id) -- bug 14570035
835: FROM po_headers_all ph
836: WHERE ph.po_header_id = p_header_id;
837:
838: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT
839: ( application_id

Line 1299: po_headers_all

1295: NVL(blanket_total_amount,0)
1296: INTO
1297: l_total_amt
1298: FROM
1299: po_headers_all
1300: WHERE po_header_id = p_po_header_id;
1301:
1302: IF l_total_amt > 0
1303: THEN

Line 1625: po_headers_all

1621: INTO
1622: l_currency_code
1623: , l_vendor_id
1624: FROM
1625: po_headers_all
1626: WHERE po_header_id = l_header_id;
1627: /* Bug 5076263 - currency_code, vendor_id to be passed to get_break_price API - End*/
1628:
1629: -- Get the primary UOM for the item and check if it same as

Line 1920: po_headers_all

1916: , l_conv_type
1917: , l_user_rate
1918: , l_rate_date
1919: FROM
1920: po_headers_all
1921: WHERE po_header_id = l_header_id;
1922:
1923: -- If the currency code of the blanket is different than the
1924: -- functional currency, convert to functional currency since