View: JAI_57F4_PO_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_57F4_PO_V

View Text

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' )

Columns