VIEW: APPS.CE_SYSTEM_PARAMETERS_V

Source

View Text - Preformatted

SELECT CSP.ROWID ROW_ID, CSP.SET_OF_BOOKS_ID, SOB.NAME, SOB.SHORT_NAME SHORT_NAME, SOB.CURRENCY_CODE, CSP.CASHBOOK_BEGIN_DATE, CSP.SHOW_CLEARED_FLAG, CSP.LINES_PER_COMMIT, CSP.LINE_AUTOCREATION_FLAG, CSP.INTERFACE_PURGE_FLAG, CSP.INTERFACE_ARCHIVE_FLAG, CSP.CREATED_BY, CSP.CREATION_DATE, CSP.LAST_UPDATED_BY, CSP.LAST_UPDATE_DATE, CSP.LAST_UPDATE_LOGIN, CSP.ATTRIBUTE_CATEGORY, CSP.ATTRIBUTE1, CSP.ATTRIBUTE2, CSP.ATTRIBUTE3, CSP.ATTRIBUTE4, CSP.ATTRIBUTE5, CSP.ATTRIBUTE6, CSP.ATTRIBUTE7, CSP.ATTRIBUTE8, CSP.ATTRIBUTE9, CSP.ATTRIBUTE10, CSP.ATTRIBUTE11, CSP.ATTRIBUTE12, CSP.ATTRIBUTE13, CSP.ATTRIBUTE14, CSP.ATTRIBUTE15, CSP.SHOW_VOID_PAYMENT_FLAG, CSP.LEGAL_ENTITY_ID , CSP.CASHFLOW_EXCHANGE_RATE_TYPE, gl.USER_CONVERSION_TYPE CASHFLOW_XRATE_TYPE_DSP, CSP.AUTHORIZATION_BAT, CSP.BSC_EXCHANGE_DATE_TYPE, CSP.BAT_EXCHANGE_DATE_TYPE, CSP.SIGNING_AUTHORITY_APPR_FLAG FROM CE_SYSTEM_PARAMETERS CSP, GL_SETS_OF_BOOKS SOB, gl_daily_conversion_types GL WHERE SOB.SET_OF_BOOKS_ID = CSP.SET_OF_BOOKS_ID AND csp.CASHFLOW_EXCHANGE_RATE_TYPE = GL.conversion_type (+) and CSP.LEGAL_ENTITY_ID is not null AND EXISTS ( SELECT 'x' FROM ( SELECT LE.LEGAL_ENTITY_ID , LE.NAME FROM FND_GRANTS GRT, FND_OBJECTS OBJ, WF_USER_ROLES ROL, XLE_ENTITY_PROFILES LE WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID AND OBJ.OBJ_NAME = 'CEBAA' AND GRANTEE_TYPE = 'GROUP' AND GRANTEE_KEY = ROL.ROLE_NAME AND ROL.USER_NAME IN ( ( SELECT FND_GLOBAL.USER_NAME FROM DUAL ) UNION ALL ( SELECT INCRNS.NAME FROM WF_LOCAL_ROLES INCRNS, FND_USER F WHERE 'HZ_PARTY' = INCRNS.ORIG_SYSTEM AND F.USER_NAME =FND_GLOBAL.USER_NAME AND F.PERSON_PARTY_ID = INCRNS.ORIG_SYSTEM_ID AND INCRNS.PARTITION_ID = 9 ) ) AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT LE.LEGAL_ENTITY_ID , LE.NAME FROM FND_GRANTS GRT, FND_OBJECTS OBJ, XLE_ENTITY_PROFILES LE WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID AND OBJ.OBJ_NAME = 'CEBAA' AND GRANTEE_TYPE = 'USER' AND GRANTEE_KEY =FND_GLOBAL.USER_NAME AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT XTR.LEGAL_ENTITY_ID , XLE.NAME FROM XTR_PARTIES_V XTR , GL_SETS_OF_BOOKS SOB , XLE_ENTITY_PROFILES XLE , XTR_COMPANY_AUTHORITIES XCA , XTR_DEALER_CODES XDC WHERE PARTY_TYPE = 'C' AND XTR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID (+) AND XTR.SET_OF_BOOKS_ID IS NOT NULL AND XTR.LEGAL_ENTITY_ID = XLE.LEGAL_ENTITY_ID AND XCA.PARTY_CODE (+) = XTR.PARTY_CODE AND XCA.DEALER_CODE = XDC.DEALER_CODE AND xdc.user_id = fnd_global.user_id ) f1 WHERE f1.legal_entity_id = csp.legal_entity_id )

View Text - HTML Formatted

SELECT CSP.ROWID ROW_ID
, CSP.SET_OF_BOOKS_ID
, SOB.NAME
, SOB.SHORT_NAME SHORT_NAME
, SOB.CURRENCY_CODE
, CSP.CASHBOOK_BEGIN_DATE
, CSP.SHOW_CLEARED_FLAG
, CSP.LINES_PER_COMMIT
, CSP.LINE_AUTOCREATION_FLAG
, CSP.INTERFACE_PURGE_FLAG
, CSP.INTERFACE_ARCHIVE_FLAG
, CSP.CREATED_BY
, CSP.CREATION_DATE
, CSP.LAST_UPDATED_BY
, CSP.LAST_UPDATE_DATE
, CSP.LAST_UPDATE_LOGIN
, CSP.ATTRIBUTE_CATEGORY
, CSP.ATTRIBUTE1
, CSP.ATTRIBUTE2
, CSP.ATTRIBUTE3
, CSP.ATTRIBUTE4
, CSP.ATTRIBUTE5
, CSP.ATTRIBUTE6
, CSP.ATTRIBUTE7
, CSP.ATTRIBUTE8
, CSP.ATTRIBUTE9
, CSP.ATTRIBUTE10
, CSP.ATTRIBUTE11
, CSP.ATTRIBUTE12
, CSP.ATTRIBUTE13
, CSP.ATTRIBUTE14
, CSP.ATTRIBUTE15
, CSP.SHOW_VOID_PAYMENT_FLAG
, CSP.LEGAL_ENTITY_ID
, CSP.CASHFLOW_EXCHANGE_RATE_TYPE
, GL.USER_CONVERSION_TYPE CASHFLOW_XRATE_TYPE_DSP
, CSP.AUTHORIZATION_BAT
, CSP.BSC_EXCHANGE_DATE_TYPE
, CSP.BAT_EXCHANGE_DATE_TYPE
, CSP.SIGNING_AUTHORITY_APPR_FLAG
FROM CE_SYSTEM_PARAMETERS CSP
, GL_SETS_OF_BOOKS SOB
, GL_DAILY_CONVERSION_TYPES GL
WHERE SOB.SET_OF_BOOKS_ID = CSP.SET_OF_BOOKS_ID
AND CSP.CASHFLOW_EXCHANGE_RATE_TYPE = GL.CONVERSION_TYPE (+)
AND CSP.LEGAL_ENTITY_ID IS NOT NULL
AND EXISTS ( SELECT 'X'
FROM ( SELECT LE.LEGAL_ENTITY_ID
, LE.NAME
FROM FND_GRANTS GRT
, FND_OBJECTS OBJ
, WF_USER_ROLES ROL
, XLE_ENTITY_PROFILES LE
WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ.OBJ_NAME = 'CEBAA'
AND GRANTEE_TYPE = 'GROUP'
AND GRANTEE_KEY = ROL.ROLE_NAME
AND ROL.USER_NAME IN ( ( SELECT FND_GLOBAL.USER_NAME
FROM DUAL ) UNION ALL ( SELECT INCRNS.NAME
FROM WF_LOCAL_ROLES INCRNS
, FND_USER F
WHERE 'HZ_PARTY' = INCRNS.ORIG_SYSTEM
AND F.USER_NAME =FND_GLOBAL.USER_NAME
AND F.PERSON_PARTY_ID = INCRNS.ORIG_SYSTEM_ID
AND INCRNS.PARTITION_ID = 9 ) )
AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT LE.LEGAL_ENTITY_ID
, LE.NAME
FROM FND_GRANTS GRT
, FND_OBJECTS OBJ
, XLE_ENTITY_PROFILES LE
WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ.OBJ_NAME = 'CEBAA'
AND GRANTEE_TYPE = 'USER'
AND GRANTEE_KEY =FND_GLOBAL.USER_NAME
AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT XTR.LEGAL_ENTITY_ID
, XLE.NAME
FROM XTR_PARTIES_V XTR
, GL_SETS_OF_BOOKS SOB
, XLE_ENTITY_PROFILES XLE
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
WHERE PARTY_TYPE = 'C'
AND XTR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID (+)
AND XTR.SET_OF_BOOKS_ID IS NOT NULL
AND XTR.LEGAL_ENTITY_ID = XLE.LEGAL_ENTITY_ID
AND XCA.PARTY_CODE (+) = XTR.PARTY_CODE
AND XCA.DEALER_CODE = XDC.DEALER_CODE
AND XDC.USER_ID = FND_GLOBAL.USER_ID ) F1
WHERE F1.LEGAL_ENTITY_ID = CSP.LEGAL_ENTITY_ID )