APPS.INV_OBJECT_GENEALOGY dependencies on PO_HEADERS_ALL

Line 707: FROM po_headers_all

703: BEGIN
704: IF p_trx_src_type = 1 THEN -- PO
705: SELECT segment1
706: INTO l_trx_src
707: FROM po_headers_all
708: WHERE po_header_id = p_trx_src_id;
709: ELSIF p_trx_src_type IN(2, 8, 12) THEN -- SO,Internal Order,RMA
710: SELECT SUBSTRB(concatenated_segments, 1, 30) --BUG11856545
711: INTO l_trx_src

Line 801: FROM po_vendors pov, po_headers_all poh

797: p_trx_src_type in (2,12) to handle RMA transactions */
798: IF p_trx_src_type = 1 THEN -- PO
799: SELECT vendor_name
800: INTO l_trading_partner
801: FROM po_vendors pov, po_headers_all poh
802: WHERE poh.po_header_id = p_trx_src_id
803: AND poh.vendor_id = pov.vendor_id;
804: ELSIF p_trx_src_type IN(2, 12) THEN -- SO,RMA
805: SELECT party_name