VIEW: APPS.PO_MASSCANCEL_INTERIM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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