DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_DOCUMENT_TYPES_VL

Object Details
Object Name: PO_DOCUMENT_TYPES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_DOCUMENT_TYPES_VL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DOCUMENT_TYPE_CODE VARCHAR2 (25) Yes
DOCUMENT_SUBTYPE VARCHAR2 (25) Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
ARCHIVE_EXTERNAL_REVISION_CODE VARCHAR2 (25)
CAN_PREPARER_APPROVE_FLAG VARCHAR2 (1)
FORWARDING_MODE_CODE VARCHAR2 (25)
CAN_CHANGE_FORWARD_FROM_FLAG VARCHAR2 (1)
CAN_APPROVER_MODIFY_DOC_FLAG VARCHAR2 (1)
CAN_CHANGE_APPROVAL_PATH_FLAG VARCHAR2 (1)
CAN_CHANGE_FORWARD_TO_FLAG VARCHAR2 (1)
QUOTATION_CLASS_CODE VARCHAR2 (25)
DEFAULT_APPROVAL_PATH_ID NUMBER

LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
SECURITY_LEVEL_CODE VARCHAR2 (25)
ACCESS_LEVEL_CODE VARCHAR2 (25)
DISABLED_FLAG VARCHAR2 (1) Yes
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
WF_APPROVAL_ITEMTYPE VARCHAR2 (8)
WF_APPROVAL_PROCESS VARCHAR2 (30)
WF_CREATEDOC_ITEMTYPE VARCHAR2 (8)
WF_CREATEDOC_PROCESS VARCHAR2 (30)
TYPE_NAME VARCHAR2 (80) Yes
ORG_ID NUMBER

Organization identifier
AME_TRANSACTION_TYPE VARCHAR2 (50)
Identifies the set of approval rules that should be used by the Oracle Approvals Management Engine (AME) for this document type
USE_CONTRACT_FOR_SOURCING_FLAG VARCHAR2 (1)
Indicator of whether to use contract agreements in document sourcing
INCLUDE_NONCATALOG_FLAG VARCHAR2 (1)
Indicator of whether to include noncatalog requests in sourcing
DOCUMENT_TEMPLATE_CODE VARCHAR2 (80)
CONTRACT_TEMPLATE_CODE VARCHAR2 (80)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_SUBTYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      ARCHIVE_EXTERNAL_REVISION_CODE
,      CAN_PREPARER_APPROVE_FLAG
,      FORWARDING_MODE_CODE
,      CAN_CHANGE_FORWARD_FROM_FLAG
,      CAN_APPROVER_MODIFY_DOC_FLAG
,      CAN_CHANGE_APPROVAL_PATH_FLAG
,      CAN_CHANGE_FORWARD_TO_FLAG
,      QUOTATION_CLASS_CODE
,      DEFAULT_APPROVAL_PATH_ID
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_LEVEL_CODE
,      ACCESS_LEVEL_CODE
,      DISABLED_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WF_APPROVAL_ITEMTYPE
,      WF_APPROVAL_PROCESS
,      WF_CREATEDOC_ITEMTYPE
,      WF_CREATEDOC_PROCESS
,      TYPE_NAME
,      ORG_ID
,      AME_TRANSACTION_TYPE
,      USE_CONTRACT_FOR_SOURCING_FLAG
,      INCLUDE_NONCATALOG_FLAG
,      DOCUMENT_TEMPLATE_CODE
,      CONTRACT_TEMPLATE_CODE
FROM APPS.PO_DOCUMENT_TYPES_VL;

Dependencies

[top of page]

APPS.PO_DOCUMENT_TYPES_VL references the following:

SchemaAPPS
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_DOCUMENT_TYPES_B
APPS.PO_DOCUMENT_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyPO_DELREC_PVT - show dependent code
SynonymPO_DOCUMENT_TYPES
PL/SQL PackagePO_INQ_SV - show dependent code
Package BodyPO_INQ_SV - show dependent code
Package BodyPO_MASS_UPDATE - show dependent code
ViewPO_NOTIFICATION_DETAILS_V