APPS.INV_CONSIGNED_DIAGNOSTICS_PROC dependencies on PO_HEADERS_ALL

Line 543: po_headers_all poh

539: poh.PO_HEADER_ID
540: , poh.AGENT_ID
541: , poh.SEGMENT1
542: FROM
543: po_headers_all poh
544: , po_lines_all pol
545: , po_line_locations_all poll
546: WHERE poh.po_header_id = pol.po_header_id
547: AND poh.po_header_id = poll.po_header_id

Line 568: FROM po_headers_all

564: IF p_po_header_id IS NOT NULL
565: THEN
566: SELECT agent_id
567: INTO l_buyer_id
568: FROM po_headers_all
569: WHERE po_header_id = p_po_header_id ;
570:
571: ELSE
572: SELECT vendor_id

Line 650: po_headers_all poh

646: CURSOR C_VALIDATE_PO
647: IS SELECT
648: Poh.blanket_total_amount
649: FROM
650: po_headers_all poh
651: , po_lines_all pol
652: WHERE poh.po_header_id = pol.po_header_id
653: AND NVL(poh.approved_flag,'Y') = 'Y'
654: AND (TRUNC(NVL(poh.start_date,sysdate -1)) <= TRUNC(sysdate))