DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on PO_HEADERS_ALL

Line 653: FROM po_headers_all

649: BEGIN
650: IF p_trx_src_type = 1 THEN -- PO
651: SELECT segment1
652: INTO l_trx_src
653: FROM po_headers_all
654: WHERE po_header_id = p_trx_src_id;
655: ELSIF p_trx_src_type IN(2, 8, 12) THEN -- SO,Internal Order,RMA
656: SELECT SUBSTR(concatenated_segments, 1, 30)
657: INTO l_trx_src

Line 747: FROM po_vendors pov, po_headers_all poh

743: p_trx_src_type in (2,12) to handle RMA transactions */
744: IF p_trx_src_type = 1 THEN -- PO
745: SELECT vendor_name
746: INTO l_trading_partner
747: FROM po_vendors pov, po_headers_all poh
748: WHERE poh.po_header_id = p_trx_src_id
749: AND poh.vendor_id = pov.vendor_id;
750: ELSIF p_trx_src_type IN(2, 12) THEN -- SO,RMA
751: SELECT party_name