[Home] [Help]
1846: X_Argument10 in varchar2 default null)
1847: IS
1848:
1849: l_product varchar2(30);
1850: l_table_name varchar2(30) := 'RCV_TRANSACTIONS';
1851: l_id_column varchar2(30) := 'TRANSACTION_ID';
1852:
1853:
1854: l_update_name varchar2(30);
2181: and mmt1.transaction_source_type_id = 1
2182: and mmt1.logical_trx_type_code = 2
2183: and exists (
2184: select 1
2185: from rcv_transactions rt
2186: where rt.transaction_id = mmt1.rcv_transaction_id
2187: and rt.organization_id = mta.organization_id)))))
2188: --BUG#12660014: Do not upgrade AX entities -
2189: -- AX team has been provided with a script to do the upgrade of XLA entities for AX avents
3540: xla_ae_headers_s.NEXTVAL,
3541: null,
3542: nvl(rae.org_id,
3543: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))
3544: from rcv_transactions rt,
3545: rcv_accounting_events rae,
3546: hr_organization_information hoi2,
3547: gl_ledgers sob,
3548: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3929: or
3930: (cem.transaction_type_id = 3
3931: and cxs.source_id_int_5 is not null
3932: and cem.attribute = (SELECT TRANSACTION_TYPE
3933: FROM RCV_TRANSACTIONS rt1
3934: WHERE rt1.transaction_id = cxs.source_id_int_5))
3935: )
3936: and gcc.CODE_COMBINATION_ID=rrs.CODE_COMBINATION_ID;
3937: