Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_ACCTG_METHOD_RULES_FVL |
SELECT P.ROWID ROW_ID
, P.ACCTG_METHOD_RULE_ID ACCTG_METHOD_RULE_ID
, P.ACCOUNTING_METHOD_TYPE_CODE ACCOUNTING_METHOD_TYPE_CODE
, P.ACCOUNTING_METHOD_CODE ACCOUNTING_METHOD_CODE
, P.APPLICATION_ID APPLICATION_ID
, X.APPLICATION_NAME APPLICATION_NAME
, P.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, K1.MEANING AMB_CONTEXT_NAME
, P.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, P.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, P.START_DATE_ACTIVE START_DATE_ACTIVE
, P.END_DATE_ACTIVE END_DATE_ACTIVE
, L.NAME PRODUCT_RULE_NAME
, K.MEANING PRODUCT_RULE_TYPE_DSP
, L.DESCRIPTION PRODUCT_RULE_DESC
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_ACCTG_METHOD_RULES P
, XLA_PRODUCT_RULES_TL L
, XLA_LOOKUPS K
, XLA_LOOKUPS K1
, XLA_APPLICATIONS_XVL X
WHERE P.APPLICATION_ID = L.APPLICATION_ID
AND P.AMB_CONTEXT_CODE = L.AMB_CONTEXT_CODE
AND P.PRODUCT_RULE_TYPE_CODE = L.PRODUCT_RULE_TYPE_CODE
AND P.PRODUCT_RULE_CODE = L.PRODUCT_RULE_CODE
AND L.LANGUAGE = USERENV('LANG')
AND P.PRODUCT_RULE_TYPE_CODE = K.LOOKUP_CODE
AND K.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND P.APPLICATION_ID = X.APPLICATION_ID
AND P.AMB_CONTEXT_CODE = K1.LOOKUP_CODE
AND K1.LOOKUP_TYPE = 'XLA_AMB_CONTEXT_TYPE'