View: PO_MASSCANCEL_INTERIM_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_MASSCANCEL_INTERIM_V

View Text

SELECT 'PO'
, PMI.ROWID
, PMI.NAME
, PMI.OBJECT_TYPE
, PMI.OBJECT_ID
, PMI.OBJECT_NUMBER
, PMI.DISTRIBUTIONS_INCLUDED
, PMI.FULLY_IN_RANGE_FLAG
, PMI.DEFAULT_CANCEL_FLAG
, PMI.LAST_UPDATED_BY
, PMI.LAST_UPDATE_DATE
, PMI.LAST_UPDATE_LOGIN
, PMI.CREATED_BY
, PMI.CREATION_DATE
, PMI.OBJECT_CREATION_DATE
, PMI.CANNOT_CANCEL_REASON
, PMI.AUTHORIZATION_STATUS
, PMI.CURRENCY_CODE
, PMI.REQUEST_ID
, PMI.PROGRAM_APPLICATION_ID
, PMI.PROGRAM_ID
, PMI.PROGRAM_UPDATE_DATE
, PMI.PO_VENDOR_ID
, PMI.ONLINE_REPORT_ID
, PMI.CANCEL_REQS_ON_PO_CANCEL_FLAG
, POLC.DISPLAYED_FIELD
, POV.VENDOR_NAME
FROM PO_LOOKUP_CODES POLC
, PO_VENDORS POV
, PO_HEADERS POH
, PO_MASSCANCEL_INTERIM PMI
WHERE PMI.OBJECT_TYPE IN ('STANDARD'
, 'PLANNED'
, 'BLANKET'
, 'CONTRACT')
AND POLC.LOOKUP_TYPE = 'PO TYPE'
AND POLC.LOOKUP_CODE = PMI.OBJECT_TYPE
AND POH.PO_HEADER_ID = PMI.OBJECT_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID UNION ALL SELECT 'REQUISITION'
, PMI.ROWID
, PMI.NAME
, PMI.OBJECT_TYPE
, PMI.OBJECT_ID
, PMI.OBJECT_NUMBER
, PMI.DISTRIBUTIONS_INCLUDED
, PMI.FULLY_IN_RANGE_FLAG
, PMI.DEFAULT_CANCEL_FLAG
, PMI.LAST_UPDATED_BY
, PMI.LAST_UPDATE_DATE
, PMI.LAST_UPDATE_LOGIN
, PMI.CREATED_BY
, PMI.CREATION_DATE
, PMI.OBJECT_CREATION_DATE
, PMI.CANNOT_CANCEL_REASON
, PMI.AUTHORIZATION_STATUS
, PMI.CURRENCY_CODE
, PMI.REQUEST_ID
, PMI.PROGRAM_APPLICATION_ID
, PMI.PROGRAM_ID
, PMI.PROGRAM_UPDATE_DATE
, PMI.PO_VENDOR_ID
, PMI.ONLINE_REPORT_ID
, PMI.CANCEL_REQS_ON_PO_CANCEL_FLAG
, POLC.DISPLAYED_FIELD
, NULL
FROM PO_LOOKUP_CODES POLC
, PO_MASSCANCEL_INTERIM PMI
WHERE PMI.OBJECT_TYPE = 'REQUISITION'
AND POLC.LOOKUP_TYPE = 'DOCUMENT TYPE'
AND POLC.LOOKUP_CODE = PMI.OBJECT_TYPE

Columns