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.

VIEW: APPS.IGC_CC_ROUTING_CTRLS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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