[Home] [Help]
2663: mtl_parameters mp,
2664: hr_organization_information hoi2,
2665: gl_ledgers sob,
2666: org_acct_periods oap,
2667: org_gl_batches ogb,
2668: cst_xla_seq_gt cxs
2669: where mta.transaction_id = cxs.source_id_int_1
2670: and mta.organization_id = cxs.source_id_int_2
2671: and nvl(mta.transaction_source_type_id, -1) = nvl(cxs.source_id_int_3, -1)
3376: mtl_parameters mp,
3377: HR_ORGANIZATION_INFORMATION HOI2,
3378: gl_ledgers sob,
3379: ORG_ACCT_PERIODS oap,
3380: org_gl_batches ogb,
3381: cst_xla_seq_gt cxs
3382: where wta.transaction_id=cxs.source_id_int_1
3383: and wt.transaction_id=cxs.source_id_int_1
3384: and nvl(wta.resource_id,-6661)=nvl(cxs.source_id_int_2,-6661)