[Home] [Help] [Dependency Information]
Object Name: | IGCBV_CC_ROUTING_CONTROLS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGC.IGCBV_CC_ROUTING_CONTROLS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
IGCBV_CC_ROUTING_CONTROLS display an association between contract commitment types and contract commitment states, in which routing controls may be established. Routing controls define the rules that determine how the contract commitment approvals can take place.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:APPROVAL_ALLOWED_FLAG | CHAR | (53) | ||
_LA:PREPARER_ENCM_ALLOW_FLAG | CHAR | (54) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
TYPE | VARCHAR2 | (1) | Yes | Type of contract commitment |
STATE | VARCHAR2 | (2) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT _LA:APPROVAL_ALLOWED_FLAG
, _LA:PREPARER_ENCM_ALLOW_FLAG
, ORGANIZATION_NAME
, TYPE
, STATE
, ORGANIZATION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
FROM APPS.IGCBV_CC_ROUTING_CONTROLS;
APPS.IGCBV_CC_ROUTING_CONTROLS is not referenced by any database object
|
|
|