eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGC.IGC_CC_ROUTING_CTRLS_ALL

Object Details

Object Name:	IGC_CC_ROUTING_CTRLS_ALL
Object Type:	TABLE
Owner:	IGC
Subobject Name:
Status:	VALID

IGC_CC_ROUTING_CTRLS stores information specific to the routing and approval controls that can be created for contract types. The table is an association between contract commitment types and contract commitment states for the given operating unit in which routing controls may be established. Routing controls define the rules that determine how the contract commitment approvals can take place.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CC_RC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID CC_TYPE CC_STATE

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)	Yes	Organization identifier
CC_TYPE	VARCHAR2	(1)	Yes	Type of contract commitment
CC_STATE	VARCHAR2	(2)	Yes	State of contract commitment
CC_CAN_PRPR_APPRV_FLAG	VARCHAR2	(1)		Flag to indicate if preparer can approve their own contracts
CC_CAN_PRPR_ENCMBR_FLAG	VARCHAR2	(1)		Flag to indicate if preparer can encumber funds for their own contracts
DEFAULT_APPROVAL_PATH_ID	NUMBER			Human Resources hierarchy identifier
WF_APPROVAL_ITEMTYPE	VARCHAR2	(240)		Workflow approval item type
WF_APPROVAL_PROCESS	VARCHAR2	(240)		Workflow approval item process
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
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).

Query Text

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


SELECT ORG_ID
,      CC_TYPE
,      CC_STATE
,      CC_CAN_PRPR_APPRV_FLAG
,      CC_CAN_PRPR_ENCMBR_FLAG
,      DEFAULT_APPROVAL_PATH_ID
,      WF_APPROVAL_ITEMTYPE
,      WF_APPROVAL_PROCESS
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
FROM IGC.IGC_CC_ROUTING_CTRLS_ALL;

Dependencies

[top of page]

IGC.IGC_CC_ROUTING_CTRLS_ALL does not reference any database object

IGC.IGC_CC_ROUTING_CTRLS_ALL is referenced by following:

APPS: IGC_CC_ROUTING_CTRLS; IGC_CC_ROUTING_CTRLS_ALL