[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => p_hdr_idx
,p_balance_type_code => ''A'');
SELECT DISTINCT
NVL(xldj.segment_rule_appl_id,xldj.application_id)
, xldj.segment_rule_type_code
, xldj.segment_rule_code
, xldj.flexfield_segment_code
, 'NA' -- 'Side' is not applicable
, xldj.inherit_adr_flag
, xld.accounting_coa_id
, xld.transaction_coa_id
FROM xla_mpa_jlt_adr_assgns xldj
, xla_line_definitions_b xld
WHERE xldj.application_id = p_application_id
AND xldj.amb_context_code = p_amb_context_code
AND xldj.event_class_code = p_event_class_code
AND xldj.event_type_code = p_event_type_code
AND xldj.line_definition_owner_code = p_line_definition_owner_code
AND xldj.line_definition_code = p_line_definition_code
AND xldj.accounting_line_type_code = p_accrual_jlt_type_code
AND xldj.accounting_line_code = p_accrual_jlt_code
AND xldj.mpa_accounting_line_type_code = p_mpa_jlt_type_code
AND xldj.mpa_accounting_line_code = p_mpa_jlt_code
--
AND xld.application_id = xldj.application_id
AND xld.amb_context_code = xldj.amb_context_code
AND xld.event_class_code = xldj.event_class_code
AND xld.event_type_code = xldj.event_type_code
AND xld.line_definition_owner_code = xldj.line_definition_owner_code
AND xld.line_definition_code = xldj.line_definition_code
--
ORDER BY decode(xldj.FLEXFIELD_SEGMENT_CODE,'ALL',1,2), -- 4655713 process ALL segments first
xldj.segment_rule_code
;
SELECT DISTINCT
xmja.mpa_accounting_line_type_code
, xmja.mpa_accounting_line_code
--
, REPLACE(xaltt.name , '''','''''')
--
, xmja.description_type_code
, xmja.description_code
--
, xaltb.accounting_entry_type_code
, CASE WHEN xmja.mpa_accounting_line_code = xldj.accounting_line_code AND
xmja.mpa_accounting_line_type_code = xldj.accounting_line_type_code
THEN DECODE(xaltb.natural_side_code,'D','C','D')
ELSE xaltb.natural_side_code
END
, xaltb.gl_transfer_mode_code
, xaltb.switch_side_flag
, xaltb.merge_duplicate_code
--
, xaltb.accounting_class_code
, xaltb.rounding_class_code
--
, xpah.entity_code
, xpah.event_class_code
, xpah.event_type_code
--
, xald.line_definition_owner_code
, xald.line_definition_code
--
, xldj.accounting_line_type_code
, xldj.accounting_line_code
--
, xaltb.business_method_code -- 4655713
, xmja.inherit_desc_flag -- 4655713b
FROM xla_aad_line_defn_assgns xald
, xla_line_defn_jlt_assgns xldj
, xla_mpa_jlt_assgns xmja
, xla_prod_acct_headers xpah
, xla_acct_line_types_b xaltb
, xla_acct_line_types_tl xaltt
, xla_line_definitions_b xld
--
WHERE xpah.application_id = p_application_id
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.amb_context_code = p_amb_context_code
AND xpah.accounting_required_flag = 'Y'
AND xpah.validation_status_code = 'R'
--
AND xald.application_id = xpah.application_id
AND xald.amb_context_code = xpah.amb_context_code
AND xald.product_rule_type_code = xpah.product_rule_type_code
AND xald.product_rule_code = xpah.product_rule_code
AND xald.event_class_code = xpah.event_class_code
AND xald.event_type_code = xpah.event_type_code
--
AND xldj.application_id = xald.application_id
AND xldj.amb_context_code = xald.amb_context_code
AND xldj.event_class_code = xald.event_class_code
AND xldj.event_type_code = xald.event_type_code
AND xldj.line_definition_owner_code = xald.line_definition_owner_code
AND xldj.line_definition_code = xald.line_definition_code
AND xldj.active_flag = 'Y'
--
AND xmja.application_id = xldj.application_id
AND xmja.amb_context_code = xldj.amb_context_code
AND xmja.event_class_code = xldj.event_class_code
AND xmja.event_type_code = xldj.event_type_code
AND xmja.line_definition_owner_code = xldj.line_definition_owner_code
AND xmja.line_definition_code = xldj.line_definition_code
AND xmja.accounting_line_code = xldj.accounting_line_code
AND xmja.accounting_line_type_code = xldj.accounting_line_type_code
--
AND xaltb.application_id = xmja.application_id
AND xaltb.amb_context_code = xmja.amb_context_code
AND xaltb.accounting_line_code = xmja.mpa_accounting_line_code
AND xaltb.accounting_line_type_code = xmja.mpa_accounting_line_type_code
AND xaltb.event_class_code = xmja.event_class_code
AND xaltb.enabled_flag = 'Y'
--
AND xaltb.application_id = xaltt.application_id (+)
AND xaltb.amb_context_code = xaltt.amb_context_code (+)
AND xaltb.entity_code = xaltt.entity_code (+)
AND xaltb.event_class_code = xaltt.event_class_code (+)
AND xaltb.accounting_line_code = xaltt.accounting_line_code (+)
AND xaltb.accounting_line_type_code = xaltt.accounting_line_type_code(+)
AND xaltt.language (+) = USERENV('LANG')
--
AND xald.application_id = xld.application_id
AND xald.amb_context_code = xld.amb_context_code
AND xald.event_class_code = xld.event_class_code
AND xald.event_type_code = xld.event_type_code
AND xald.line_definition_owner_code = xld.line_definition_owner_code
AND xald.line_definition_code = xld.line_definition_code
AND xld.budgetary_control_flag = XLA_CMP_PAD_PKG.g_bc_pkg_flag
--
--
ORDER BY xldj.accounting_line_type_code, xldj.accounting_line_code,
xmja.mpa_accounting_line_type_code, xmja.mpa_accounting_line_code
;