APPS.CST_SLA_UPDATE_PKG dependencies on WIP_TRANSACTION_ACCOUNTS

Line 2695: from wip_transaction_accounts wta

2691: XLA_transaction_ENTITies_S.nextval,
2692: xla_events_s.nextval,
2693: xla_ae_headers_s.NEXTVAL
2694: from (select distinct wta.transaction_id, wta.resource_id, wta.basis_type
2695: from wip_transaction_accounts wta
2696: where wta.transaction_id >= X_min_id
2697: and wta.transaction_id <= X_max_id
2698: and exists (select null
2699: from xla_upgrade_dates xud,

Line 2728: wip_transaction_accounts wta

2724: return;
2725: END IF;
2726:
2727: update /*+ leading(cxs) use_nl(wta) index(wta) */
2728: wip_transaction_accounts wta
2729: set wip_sub_ledger_id = cst_wip_sub_ledger_id_s.nextval,
2730: last_update_date = gUpdateDate,
2731: last_updated_by = gUserId,
2732: last_update_login = gLoginId

Line 3060: 'WIP_TRANSACTION_ACCOUNTS' src_dist_type,

3056: 'UNKNOWN') accounting_class_code,
3057: wta.gl_sl_link_id link_id,
3058: 'WTA' link_table,
3059: 'C' line_type_code,
3060: 'WIP_TRANSACTION_ACCOUNTS' src_dist_type,
3061: wta.wip_sub_ledger_id src_dist_id_num_1,
3062: 'N' merge_dup_code,
3063: DECODE(sign(wta.base_transaction_value), 1, wta.base_transaction_value, 0, 0, NULL) ACCOUNTED_DR,
3064: DECODE(sign(wta.base_transaction_value), -1,(-1*wta.base_transaction_value), NULL) ACCOUNTED_CR,

Line 3074: from wip_transaction_accounts wta,

3070: NVL(wta.TRANSACTION_VALUE,wta.BASE_TRANSACTION_VALUE) entered_amount,
3071: decode(sign(wta.base_transaction_value),0,'Y', 'N') ZERO_AMOUNT_FLAG,
3072: decode(gcc.reference3,'Y', 'P', null) CONTROL_BALANCE_FLAG,
3073: cem.event_class_code event_class_code
3074: from wip_transaction_accounts wta,
3075: cst_xla_wip_event_map cem,
3076: wip_transactions wt,
3077: GL_CODE_COMBINATIONS gcc,
3078: mtl_parameters mp,