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.JG_ZZ_TA_RULE_SETS_V

Source

View Text - Preformatted


SELECT RS.ROWID ROW_ID ,RS.RULE_SET_ID RULE_SET_ID ,RS.NAME NAME , FL.ID_FLEX_STRUCTURE_NAME ID_FLEX_STRUCTURE_NAME , RS.PARTIAL_ALLOCATION PARTIAL_ALLOCATION , RS.ENABLED_FLAG ENABLED_FLAG , RS.ACCOUNT_TYPE ACCOUNT_TYPE , LK.DESCRIPTION ACCOUNT_TYPE_DISP ,RS.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID , RS.CREATION_DATE CREATION_DATE ,RS.CREATED_BY CREATED_BY , RS.LAST_UPDATED_BY LAST_UPDATED_BY ,RS.LAST_UPDATE_DATE LAST_UPDATE_DATE , RS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,RS.CONTEXT CONTEXT , RS.ATTRIBUTE1 ATTRIBUTE1 ,RS.ATTRIBUTE2 ATTRIBUTE2 , RS.ATTRIBUTE3 ATTRIBUTE3 ,RS.ATTRIBUTE4 ATTRIBUTE4 , RS.ATTRIBUTE5 ATTRIBUTE5 ,RS.ATTRIBUTE6 ATTRIBUTE6 , RS.ATTRIBUTE7 ATTRIBUTE7 ,RS.ATTRIBUTE8 ATTRIBUTE8 , RS.ATTRIBUTE9 ATTRIBUTE9 ,RS.ATTRIBUTE10 ATTRIBUTE10 , RS.ATTRIBUTE11 ATTRIBUTE11 ,RS.ATTRIBUTE12 ATTRIBUTE12 , RS.ATTRIBUTE13 ATTRIBUTE13 ,RS.ATTRIBUTE14 ATTRIBUTE14 , RS.ATTRIBUTE15 ATTRIBUTE15 FROM JG_ZZ_TA_RULE_SETS RS ,FND_ID_FLEX_STRUCTURES_VL FL ,GL_LOOKUPS LK WHERE RS.CHART_OF_ACCOUNTS_ID = FL.ID_FLEX_NUM AND FL.ID_FLEX_CODE = 'GL#' AND RS.ACCOUNT_TYPE = LK.LOOKUP_CODE (+) AND nvl(LK.LOOKUP_TYPE, 'ACCOUNT TYPE') ='ACCOUNT TYPE'

View Text - HTML Formatted

SELECT RS.ROWID ROW_ID
, RS.RULE_SET_ID RULE_SET_ID
, RS.NAME NAME
, FL.ID_FLEX_STRUCTURE_NAME ID_FLEX_STRUCTURE_NAME
, RS.PARTIAL_ALLOCATION PARTIAL_ALLOCATION
, RS.ENABLED_FLAG ENABLED_FLAG
, RS.ACCOUNT_TYPE ACCOUNT_TYPE
, LK.DESCRIPTION ACCOUNT_TYPE_DISP
, RS.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, RS.CREATION_DATE CREATION_DATE
, RS.CREATED_BY CREATED_BY
, RS.LAST_UPDATED_BY LAST_UPDATED_BY
, RS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RS.CONTEXT CONTEXT
, RS.ATTRIBUTE1 ATTRIBUTE1
, RS.ATTRIBUTE2 ATTRIBUTE2
, RS.ATTRIBUTE3 ATTRIBUTE3
, RS.ATTRIBUTE4 ATTRIBUTE4
, RS.ATTRIBUTE5 ATTRIBUTE5
, RS.ATTRIBUTE6 ATTRIBUTE6
, RS.ATTRIBUTE7 ATTRIBUTE7
, RS.ATTRIBUTE8 ATTRIBUTE8
, RS.ATTRIBUTE9 ATTRIBUTE9
, RS.ATTRIBUTE10 ATTRIBUTE10
, RS.ATTRIBUTE11 ATTRIBUTE11
, RS.ATTRIBUTE12 ATTRIBUTE12
, RS.ATTRIBUTE13 ATTRIBUTE13
, RS.ATTRIBUTE14 ATTRIBUTE14
, RS.ATTRIBUTE15 ATTRIBUTE15
FROM JG_ZZ_TA_RULE_SETS RS
, FND_ID_FLEX_STRUCTURES_VL FL
, GL_LOOKUPS LK
WHERE RS.CHART_OF_ACCOUNTS_ID = FL.ID_FLEX_NUM
AND FL.ID_FLEX_CODE = 'GL#'
AND RS.ACCOUNT_TYPE = LK.LOOKUP_CODE (+)
AND NVL(LK.LOOKUP_TYPE
, 'ACCOUNT TYPE') ='ACCOUNT TYPE'