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_NUMBER_METHODS_V

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

View Text

SELECT CCT.ROWID
, CCT.ORG_ID
, CCT.CC_NUM_METHOD
, LKP2.MEANING CC_NUM_METHOD_DESC
, CCT.CC_NUM_DATATYPE
, LKP3.MEANING CC_NUM_DATATYPE_DESC
, CCT.CC_NEXT_NUM
, CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.LAST_UPDATE_LOGIN
, CCT.CREATION_DATE
, CCT.CREATED_BY
FROM IGC_CC_NUMBER_METHODS CCT
, FND_LOOKUPS LKP2
, FND_LOOKUPS LKP3
WHERE CCT.CC_NUM_METHOD = LKP2.LOOKUP_CODE (+)
AND LKP2.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_METHOD'
AND CCT.CC_NUM_DATATYPE = LKP3.LOOKUP_CODE (+)
AND LKP3.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_DATATYPE'

Columns

Name
ROW_ID
ORG_ID
CC_NUM_METHOD
CC_NUM_METHOD_DESC
CC_NUM_DATATYPE
CC_NUM_DATATYPE_DESC
CC_NEXT_NUM
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY