VIEW: APPS.XLA_ACCTG_METHOD_RULES_FVL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'