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

VIEW: APPS.IGCFV_CC_ROUTING_CONTROLS

Object Details
Object Name: IGCFV_CC_ROUTING_CONTROLS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGCFV_CC_ROUTING_CONTROLS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


IGCFV_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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_LA:APPROVAL_ALLOWED_FLAG CHAR (53)
_LA:PREPARER_ENCM_ALLOW_FLAG CHAR (54)
ORGANIZATION_NAME VARCHAR2 (240) Yes
ORGANIZATION_ID NUMBER (15) Yes
TYPE VARCHAR2 (1) Yes Type of contract commitment
STATE VARCHAR2 (2) 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).
Query Text

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


SELECT _LA:APPROVAL_ALLOWED_FLAG
,      _LA:PREPARER_ENCM_ALLOW_FLAG
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      TYPE
,      STATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCFV_CC_ROUTING_CONTROLS;

Dependencies

[top of page]

APPS.IGCFV_CC_ROUTING_CONTROLS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymIGC_CC_ROUTING_CTRLS_ALL

APPS.IGCFV_CC_ROUTING_CONTROLS is not referenced by any database object