VIEW: APPS.IGC_CC_SYSTEM_OPTIONS_V

Source

View Text - Preformatted

SELECT CSP.ROWID, CSP.ORG_ID, CSP.CC_NUM_METHOD, LKP1.MEANING CC_NUM_METHOD_DESC, CSP.CC_NUM_DATATYPE, LKP2.MEANING CC_NUM_DATATYPE_DESC, CSP.CC_NEXT_NUM, CSP.CC_PREFIX, CSP.DEFAULT_RATE_TYPE, GLD.USER_CONVERSION_TYPE, CSP.ENFORCE_VENDOR_HOLD_FLAG, CSP.LAST_UPDATE_DATE, CSP.LAST_UPDATED_BY, CSP.LAST_UPDATE_LOGIN, CSP.CREATION_DATE, CSP.CREATED_BY FROM IGC_CC_SYSTEM_OPTIONS_ALL CSP, FND_LOOKUPS LKP1, FND_LOOKUPS LKP2, GL_DAILY_CONVERSION_TYPES GLD WHERE CSP.CC_NUM_METHOD = LKP1.LOOKUP_CODE (+) AND LKP1.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_METHOD' AND CSP.CC_NUM_DATATYPE = LKP2.LOOKUP_CODE (+) AND LKP2.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_DATATYPE' AND CSP.DEFAULT_RATE_TYPE = GLD.CONVERSION_TYPE (+)

View Text - HTML Formatted

SELECT CSP.ROWID
, CSP.ORG_ID
, CSP.CC_NUM_METHOD
, LKP1.MEANING CC_NUM_METHOD_DESC
, CSP.CC_NUM_DATATYPE
, LKP2.MEANING CC_NUM_DATATYPE_DESC
, CSP.CC_NEXT_NUM
, CSP.CC_PREFIX
, CSP.DEFAULT_RATE_TYPE
, GLD.USER_CONVERSION_TYPE
, CSP.ENFORCE_VENDOR_HOLD_FLAG
, CSP.LAST_UPDATE_DATE
, CSP.LAST_UPDATED_BY
, CSP.LAST_UPDATE_LOGIN
, CSP.CREATION_DATE
, CSP.CREATED_BY
FROM IGC_CC_SYSTEM_OPTIONS_ALL CSP
, FND_LOOKUPS LKP1
, FND_LOOKUPS LKP2
, GL_DAILY_CONVERSION_TYPES GLD
WHERE CSP.CC_NUM_METHOD = LKP1.LOOKUP_CODE (+)
AND LKP1.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_METHOD'
AND CSP.CC_NUM_DATATYPE = LKP2.LOOKUP_CODE (+)
AND LKP2.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_DATATYPE'
AND CSP.DEFAULT_RATE_TYPE = GLD.CONVERSION_TYPE (+)