View: PO_DOCUMENT_TYPES_V

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

View Text

SELECT DT.ROW_ID
, DT.DOCUMENT_TYPE_CODE
, LC1.DISPLAYED_FIELD
, DT.DOCUMENT_SUBTYPE
, LC2.DISPLAYED_FIELD
, DT.SECURITY_LEVEL_CODE
, LC3.DISPLAYED_FIELD
, DT.QUOTATION_CLASS_CODE
, LC4.DISPLAYED_FIELD
, DT.ARCHIVE_EXTERNAL_REVISION_CODE
, LC5.DISPLAYED_FIELD
, DT.ACCESS_LEVEL_CODE
, LC6.DISPLAYED_FIELD
, DT.FORWARDING_MODE_CODE
, LC7.DISPLAYED_FIELD
, DT.DEFAULT_APPROVAL_PATH_ID
, PPS.NAME
, DT.DISABLED_FLAG
, DT.TYPE_NAME
, DT.CAN_PREPARER_APPROVE_FLAG
, DT.CAN_APPROVER_MODIFY_DOC_FLAG
, DT.CAN_CHANGE_FORWARD_FROM_FLAG
, DT.CAN_CHANGE_FORWARD_TO_FLAG
, DT.CAN_CHANGE_APPROVAL_PATH_FLAG
, DT.ATTRIBUTE_CATEGORY
, DT.ATTRIBUTE1
, DT.ATTRIBUTE2
, DT.ATTRIBUTE3
, DT.ATTRIBUTE4
, DT.ATTRIBUTE5
, DT.ATTRIBUTE6
, DT.ATTRIBUTE7
, DT.ATTRIBUTE8
, DT.ATTRIBUTE9
, DT.ATTRIBUTE10
, DT.ATTRIBUTE11
, DT.ATTRIBUTE12
, DT.ATTRIBUTE13
, DT.ATTRIBUTE14
, DT.ATTRIBUTE15
, DT.CREATION_DATE
, DT.CREATED_BY
, DT.LAST_UPDATE_DATE
, DT.LAST_UPDATED_BY
, DT.LAST_UPDATE_LOGIN
, DT.REQUEST_ID
, DT.PROGRAM_APPLICATION_ID
, DT.PROGRAM_ID
, DT.PROGRAM_UPDATE_DATE
, DT.WF_APPROVAL_ITEMTYPE
, DT.WF_APPROVAL_PROCESS
, DT.WF_CREATEDOC_ITEMTYPE
, DT.WF_CREATEDOC_PROCESS
, DT.ORG_ID
, DT.AME_TRANSACTION_TYPE
, DT.USE_CONTRACT_FOR_SOURCING_FLAG
, DT.INCLUDE_NONCATALOG_FLAG
, DT.DOCUMENT_TEMPLATE_CODE
, DT.CONTRACT_TEMPLATE_CODE
FROM PO_LOOKUP_CODES LC1
, PO_LOOKUP_CODES LC2
, PO_LOOKUP_CODES LC3
, PO_DOCUMENT_TYPES DT
, PO_LOOKUP_CODES LC4
, PO_LOOKUP_CODES LC5
, PO_LOOKUP_CODES LC6
, PO_LOOKUP_CODES LC7
, PER_POSITION_STRUCTURES PPS
WHERE DT.DOCUMENT_TYPE_CODE = LC1.LOOKUP_CODE
AND LC1.LOOKUP_TYPE = 'DOCUMENT TYPE'
AND DT.DOCUMENT_SUBTYPE = LC2.LOOKUP_CODE
AND LC2.LOOKUP_TYPE = DECODE(DT.DOCUMENT_TYPE_CODE
, 'REQUISITION'
, 'REQUISITION TYPE'
, 'RFQ'
, 'RFQ SUBTYPE'
, 'QUOTATION'
, 'QUOTATION SUBTYPE'
, 'DOCUMENT SUBTYPE')
AND DT.SECURITY_LEVEL_CODE = LC3.LOOKUP_CODE(+)
AND LC3.LOOKUP_TYPE(+) = 'SECURITY_LEVEL'
AND DT.QUOTATION_CLASS_CODE = LC4.LOOKUP_CODE(+)
AND LC4.LOOKUP_TYPE(+) = 'QUOTATION CLASS'
AND DT.ARCHIVE_EXTERNAL_REVISION_CODE = LC5.LOOKUP_CODE(+)
AND LC5.LOOKUP_TYPE(+) = 'ARCHIVE_MODE'
AND DT.ACCESS_LEVEL_CODE = LC6.LOOKUP_CODE(+)
AND LC6.LOOKUP_TYPE(+) = 'ACCESS_LEVEL'
AND DT.FORWARDING_MODE_CODE = LC7.LOOKUP_CODE(+)
AND LC7.LOOKUP_TYPE(+) = 'NEXT APPROVER METHOD'
AND DT.DEFAULT_APPROVAL_PATH_ID = PPS.POSITION_STRUCTURE_ID(+)

Columns