APPS.CST_SLA_UPDATE_PKG dependencies on CST_XLA_SEQ_GT

Line 1858: /*execute immediate 'CREATE GLOBAL TEMPORARY TABLE cst_xla_seq_gt(

1854: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
1855:
1856: l_je_category_name := 'MTL';
1857:
1858: /*execute immediate 'CREATE GLOBAL TEMPORARY TABLE cst_xla_seq_gt(
1859: source_id_int_1 NUMBER,
1860: source_id_int_2 number,
1861: source_id_int_3 number,
1862: source_id_int_4 number,

Line 1875: insert into cst_xla_seq_gt (

1871:
1872: /* one (txn_id,org_id,txn_src_type_id) -> one entity_id -> one event_id -> one header_id */
1873: /* one mta line -> one xla_ae_line -> one xla_distribution_link */
1874:
1875: insert into cst_xla_seq_gt (
1876: source_id_int_1,
1877: source_id_int_2,
1878: source_id_int_3,
1879: entity_id,

Line 1948: from cst_xla_seq_gt cxs)

1944: (select /*+ unnest */
1945: source_id_int_1,
1946: source_id_int_2,
1947: source_id_int_3
1948: from cst_xla_seq_gt cxs)
1949: and mta.encumbrance_type_id is null;
1950:
1951: insert all
1952: when (line_id=1) then

Line 2389: cst_xla_seq_gt cxs

2385: hr_organization_information hoi2,
2386: gl_ledgers sob,
2387: org_acct_periods oap,
2388: org_gl_batches ogb,
2389: cst_xla_seq_gt cxs
2390: where mta.transaction_id = cxs.source_id_int_1
2391: and mta.organization_id = cxs.source_id_int_2
2392: and nvl(mta.transaction_source_type_id, -1) = nvl(cxs.source_id_int_3, -1)
2393: and mta.encumbrance_type_id is null

Line 2681: insert into cst_xla_seq_gt(

2677:
2678: /* one (txn_id,org_id,txn_src_type_id) -> one entity_id -> one event_id -> one header_id */
2679: /* one wta line -> one xla_ae_line -> one xla_distribution_link */
2680:
2681: insert into cst_xla_seq_gt(
2682: source_id_int_1,
2683: source_id_int_2,
2684: source_id_int_3,
2685: entity_id,

Line 2737: from cst_xla_seq_gt cxs);

2733: where (wta.transaction_id, nvl(wta.resource_id,-6661), nvl(wta.basis_type,-6661)) in
2734: (select source_id_int_1,
2735: nvl(source_id_int_2,-6661),
2736: nvl(source_id_int_3,-6661)
2737: from cst_xla_seq_gt cxs);
2738:
2739:
2740: insert all
2741: when (line_id=1) then

Line 3083: cst_xla_seq_gt cxs

3079: HR_ORGANIZATION_INFORMATION HOI2,
3080: gl_ledgers sob,
3081: ORG_ACCT_PERIODS oap,
3082: org_gl_batches ogb,
3083: cst_xla_seq_gt cxs
3084: where wta.transaction_id=cxs.source_id_int_1
3085: and wt.transaction_id=cxs.source_id_int_1
3086: and nvl(wta.resource_id,-6661)=nvl(cxs.source_id_int_2,-6661)
3087: and nvl(wta.basis_type,-6661)=nvl(cxs.source_id_int_3,-6661)

Line 3245: insert into cst_xla_seq_gt(

3241: for the accounting lines corresponding to one RT.txn_id;
3242: But since 11.5.10 introducing global procurement, we have multiple org_id, multiple organization_id,
3243: and multiple ledger_id in RAE corresponding to one RT.txn_id. I.e, Customer(RT.txn_id)--OU3---OU2---OU1--S
3244: */
3245: insert into cst_xla_seq_gt(
3246: source_id_int_1,
3247: source_id_int_2,
3248: source_id_int_3,
3249: source_id_int_4,

Line 3308: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)

3304: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3305: last_update_date = gUpdateDate,
3306: last_updated_by = gUserId,
3307: last_update_login = gLoginId
3308: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)
3309: and rrs.ENCUMBRANCE_TYPE_ID is null;
3310:
3311:
3312: l_stmt_num :=20;

Line 3635: cst_xla_seq_gt cxs

3631: cem.event_class_code event_class_code
3632: from rcv_receiving_sub_ledger rrs,
3633: cst_xla_rcv_event_map cem,
3634: GL_CODE_COMBINATIONS gcc,
3635: cst_xla_seq_gt cxs
3636: where rrs.rcv_transaction_id = cxs.source_id_int_1
3637: and (rrs.accounting_event_id is null or rrs.accounting_event_id = cxs.source_id_int_2)
3638: and rrs.ENCUMBRANCE_TYPE_ID is null
3639: and cxs.source_id_int_4 = cem.transaction_type_id