VIEW: APPS.PO_DOCUMENT_TYPES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)