View: POS_ACK_SELECT_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.POS_ACK_SELECT_V

View Text

SELECT PA.ACCEPTED_FLAG
, NULL
, NULL
, PA.ACCEPTANCE_LOOKUP_CODE
, NULL
, NULL
, PHA.PO_HEADER_ID
, -1
, PHA.SEGMENT1
, -1
, PHA.REVISION_NUM
, PHA.TYPE_LOOKUP_CODE
, NULL
, PHA.CURRENCY_CODE
, NULL
, DECODE(PHA.ACCEPTANCE_REQUIRED_FLAG
, 'N'
, 'NO'
, 'Y'
, 'YES'
, NULL)
, NVL(PA.ACCEPTED_FLAG
, 'NONE')
, PHA.ACCEPTANCE_DUE_DATE
, NVL(APPROVED_FLAG
, 'N')
, PHA.SHIP_TO_LOCATION_ID
, NULL
, PHA.SHIP_VIA_LOOKUP_CODE
, OF1.DESCRIPTION
, PHA.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(PHA.AGENT_ID)
, NULL
, PHA.VENDOR_ID
, PV.VENDOR_NAME
, PHA.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
FROM PO_HEADERS PHA
, PO_ACCEPTANCES PA
, HR_LOCATIONS HL
, ORG_FREIGHT OF1
, HR_EMPLOYEES HE
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE PHA.PO_HEADER_ID = PA.PO_HEADER_ID (+)
AND PHA.REVISION_NUM = PA.REVISION_NUM (+)
AND PHA.ORG_ID = OF1.ORGANIZATION_ID (+)
AND PHA.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+)
AND PHA.SHIP_VIA_LOOKUP_CODE = OF1.FREIGHT_CODE (+)
AND PHA.AGENT_ID = HE.EMPLOYEE_ID (+)
AND PHA.VENDOR_ID = PV.VENDOR_ID (+)
AND PHA.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND PHA.APPROVED_FLAG = 'Y'
AND NVL(PHA.CLOSED_CODE
, 'OPEN') = 'OPEN'
AND NVL(PHA.CANCEL_FLAG
, 'N') = 'N' UNION ALL SELECT PA.ACCEPTED_FLAG
, NULL
, NULL
, PA.ACCEPTANCE_LOOKUP_CODE
, NULL
, NULL
, PR.PO_HEADER_ID
, PR.PO_RELEASE_ID
, PH.SEGMENT1 || '-' || TO_CHAR(PR.RELEASE_NUM)
, PR.RELEASE_NUM
, PR.REVISION_NUM
, PR.RELEASE_TYPE
, NULL
, PH.CURRENCY_CODE
, NULL
, DECODE(PR.ACCEPTANCE_REQUIRED_FLAG
, 'N'
, 'NO'
, 'Y'
, 'YES'
, NULL)
, NVL(PA.ACCEPTED_FLAG
, 'NONE')
, PR.ACCEPTANCE_DUE_DATE
, NVL(PR.APPROVED_FLAG
, 'N')
, PH.SHIP_TO_LOCATION_ID
, NULL
, PH.SHIP_VIA_LOOKUP_CODE
, OF1.DESCRIPTION
, PR.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(PR.AGENT_ID)
, NULL
, PH.VENDOR_ID
, PV.VENDOR_NAME
, PH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
FROM PO_RELEASES PR
, PO_HEADERS PH
, PO_ACCEPTANCES PA
, HR_LOCATIONS HL
, ORG_FREIGHT OF1
, HR_EMPLOYEES HE
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE PH.PO_HEADER_ID = PR.PO_HEADER_ID
AND PR.PO_HEADER_ID = PA.PO_HEADER_ID (+)
AND PR.PO_RELEASE_ID = PA.PO_RELEASE_ID (+)AND PH.ORG_ID = OF1.ORGANIZATION_ID (+)
AND PH.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+)
AND PH.SHIP_VIA_LOOKUP_CODE = OF1.FREIGHT_CODE (+)
AND PR.AGENT_ID = HE.EMPLOYEE_ID (+)
AND PH.VENDOR_ID = PV.VENDOR_ID (+)
AND PH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND PR.APPROVED_FLAG = 'Y'
AND NVL(PR.CLOSED_CODE
, 'OPEN') = 'OPEN'
AND NVL(PR.CANCEL_FLAG
, 'N' ) = 'N'

Columns