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.

[Home] [Help]

View: IGC_CC_ROUTING_CTRLS_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CC_ROUTING_CTRLS_V

View Text

SELECT ICRC.ROWID
, ICRC.ORG_ID
, ICRC.CC_TYPE
, F1.MEANING
, ICRC.CC_STATE
, F2.MEANING
, ICRC.CC_CAN_PRPR_APPRV_FLAG
, ICRC.CC_CAN_PRPR_ENCMBR_FLAG
, ICRC.WF_APPROVAL_ITEMTYPE
, ICRC.WF_APPROVAL_PROCESS
, ICRC.DEFAULT_APPROVAL_PATH_ID
, ICRC.LAST_UPDATE_DATE
, ICRC.LAST_UPDATE_LOGIN
, ICRC.CREATION_DATE
, ICRC.LAST_UPDATED_BY
, ICRC.CREATED_BY
FROM IGC_CC_ROUTING_CTRLS ICRC
, FND_LOOKUPS F1
, FND_LOOKUPS F2
WHERE F1.LOOKUP_TYPE = 'IGC_CC_TYPE'
AND F1.LOOKUP_CODE = ICRC.CC_TYPE
AND F2.LOOKUP_TYPE = 'IGC_CC_STATE'
AND F2.LOOKUP_CODE = ICRC.CC_STATE

Columns

Name
ROW_ID
ORG_ID
CC_TYPE
CC_TYPE_NAME
CC_STATE
CC_STATE_NAME
CC_CAN_PRPR_APPRV_FLAG
CC_CAN_PRPR_ENCMBR_FLAG
WF_APPROVAL_ITEMTYPE
WF_APPROVAL_PROCESS
DEFAULT_APPROVAL_PATH_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATION_DATE
LAST_UPDATED_BY
CREATED_BY