VIEW: APPS.JAI_57F4_PO_V

Source

View Text - Preformatted

SELECT poh.segment1 SEGMENT1, NULL PO_RELEASE_ID, poh.po_header_id PO_HEADER_ID, NULL RELEASE_NUM, poh.vendor_id VENDOR_ID, poh.vendor_site_id VENDOR_SITE_ID FROM po_headers_all poh WHERE poh.authorization_status = 'APPROVED' AND nvl(poh.cancel_flag,'N') = 'N' AND nvl(poh.user_hold_flag,'N') = 'N' AND nvl(poh.approved_flag,'N') = 'Y' AND nvl(poh.closed_code,'$$') not like ('%CLOSED%') AND EXISTS (SELECT 1 from po_lines_all pol WHERE pol.line_type_id IN (select line_type_id from po_line_types_b where outside_operation_flag = 'Y') AND pol.po_header_id= poh.po_header_id) AND NOT EXISTS ( SELECT 1 FROM po_releases_all WHERE po_header_id = poh.po_header_id ) UNION ALL SELECT poh.segment1, por.po_release_id, poh.po_header_id, por.release_num, poh.vendor_id, poh.vendor_site_id FROM po_headers_all poh, po_releases_all por WHERE poh.po_header_id = por.po_header_id AND por.authorization_status = 'APPROVED' AND nvl(por.cancel_flag,'N') = 'N' AND nvl(por.hold_flag,'N') = 'N' AND nvl(por.approved_flag,'N')= 'Y' AND nvl(por.closed_code,'$$') not like ('%CLOSED%') AND EXISTS (SELECT 1 from po_lines_all pol WHERE pol.line_type_id IN (select line_type_id from po_line_types_b where outside_operation_flag = 'Y') AND pol.po_header_id= poh.po_header_id)

View Text - HTML Formatted

SELECT POH.SEGMENT1 SEGMENT1
, NULL PO_RELEASE_ID
, POH.PO_HEADER_ID PO_HEADER_ID
, NULL RELEASE_NUM
, POH.VENDOR_ID VENDOR_ID
, POH.VENDOR_SITE_ID VENDOR_SITE_ID
FROM PO_HEADERS_ALL POH
WHERE POH.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.USER_HOLD_FLAG
, 'N') = 'N'
AND NVL(POH.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(POH.CLOSED_CODE
, '$$') NOT LIKE ('%CLOSED%')
AND EXISTS (SELECT 1
FROM PO_LINES_ALL POL
WHERE POL.LINE_TYPE_ID IN (SELECT LINE_TYPE_ID
FROM PO_LINE_TYPES_B
WHERE OUTSIDE_OPERATION_FLAG = 'Y')
AND POL.PO_HEADER_ID= POH.PO_HEADER_ID)
AND NOT EXISTS ( SELECT 1
FROM PO_RELEASES_ALL
WHERE PO_HEADER_ID = POH.PO_HEADER_ID ) UNION ALL SELECT POH.SEGMENT1
, POR.PO_RELEASE_ID
, POH.PO_HEADER_ID
, POR.RELEASE_NUM
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
FROM PO_HEADERS_ALL POH
, PO_RELEASES_ALL POR
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POR.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL(POR.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POR.HOLD_FLAG
, 'N') = 'N'
AND NVL(POR.APPROVED_FLAG
, 'N')= 'Y'
AND NVL(POR.CLOSED_CODE
, '$$') NOT LIKE ('%CLOSED%')
AND EXISTS (SELECT 1
FROM PO_LINES_ALL POL
WHERE POL.LINE_TYPE_ID IN (SELECT LINE_TYPE_ID
FROM PO_LINE_TYPES_B
WHERE OUTSIDE_OPERATION_FLAG = 'Y')
AND POL.PO_HEADER_ID= POH.PO_HEADER_ID)