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, po_lines_all pol WHERE poh.po_header_id = pol.po_header_id AND 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_line_types_b WHERE line_type_id = pol.line_type_id AND outside_operation_flag = 'Y' ) AND NOT EXISTS ( SELECT 1 FROM po_releases_all WHERE po_header_id = poh.po_header_id ) UNION 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_lines_all pol, 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_line_types_b WHERE line_type_id = pol.line_type_id AND outside_operation_flag = 'Y' )

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
, PO_LINES_ALL POL
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND 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_LINE_TYPES_B
WHERE LINE_TYPE_ID = POL.LINE_TYPE_ID
AND OUTSIDE_OPERATION_FLAG = 'Y' )
AND NOT EXISTS ( SELECT 1
FROM PO_RELEASES_ALL
WHERE PO_HEADER_ID = POH.PO_HEADER_ID ) UNION 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_LINES_ALL POL
, 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_LINE_TYPES_B
WHERE LINE_TYPE_ID = POL.LINE_TYPE_ID
AND OUTSIDE_OPERATION_FLAG = 'Y' )