DBA Data[Home] [Help]

APPS.INV_CONSIGNED_DIAGNOSTICS_PROC dependencies on PO_LINES_ALL

Line 544: , po_lines_all pol

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
548: AND pol.po_header_id = poll.po_header_id

Line 651: , po_lines_all pol

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))
655: AND (TRUNC(NVL(poh.end_date,sysdate +1)) >= TRUNC(sysdate))