APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on PO_HEADERS_ALL

Line 569: FROM po_headers_all

565: SELECT vendor_id
566: , vendor_site_id
567: INTO l_vendor_id
568: , l_vendor_site_id
569: FROM po_headers_all
570: WHERE po_header_id = p_header_id;
571:
572: SELECT pov.party_id
573: , povs.party_site_id

Line 764: po_headers_all poh

760: , poh.type_lookup_code
761: , poh.segment1
762: , FND_GLOBAL.session_id
763: FROM
764: po_headers_all poh
765: , fnd_currencies fc
766: WHERE poh.currency_code = fc.currency_code
767: AND poh.po_header_id = p_header_id;
768:

Line 825: FROM po_headers_all

821: , p_ship_to_organization_id
822: -- , l_vendor_site_id
823: , bill_to_location_id
824: , l_ship_from_location_id
825: FROM po_headers_all
826: WHERE po_header_id = p_header_id;
827:
828: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT
829: ( application_id

Line 1307: po_headers_all

1303: NVL(blanket_total_amount,0)
1304: INTO
1305: l_total_amt
1306: FROM
1307: po_headers_all
1308: WHERE po_header_id = p_po_header_id;
1309:
1310: IF l_total_amt > 0
1311: THEN

Line 1630: po_headers_all

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

Line 1925: po_headers_all

1921: , l_conv_type
1922: , l_user_rate
1923: , l_rate_date
1924: FROM
1925: po_headers_all
1926: WHERE po_header_id = l_header_id;
1927:
1928: -- If the currency code of the blanket is different than the
1929: -- functional currency, convert to functional currency since