DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on WIP_DISCRETE_JOBS

Line 1497: -- non cfm then use wip_discrete_jobs

1493: and wfs.wip_entity_id = mmt.transaction_source_id
1494: and wac.organization_id = i_org_id
1495: and wac.class_code = wfs.class_code;
1496: else
1497: -- non cfm then use wip_discrete_jobs
1498: -- class_type 1 and 3 : asset job, 4 : exp job
1499: select decode(wac.class_type, 1, 0,
1500: 3, 0,
1501: 6, 0,

Line 1505: wip_discrete_jobs wdj,

1501: 6, 0,
1502: 4, decode(l_exp1, 1, 1, 0))
1503: into l_exp2
1504: from mtl_material_transactions mmt,
1505: wip_discrete_jobs wdj,
1506: wip_accounting_classes wac
1507: where mmt.transaction_id = i_txn_id
1508: and mmt.organization_id = i_org_id
1509: and wdj.organization_id = i_org_id

Line 2416: wip_discrete_jobs wdj,

2412: 6, 0,
2413: 4, decode(i_exp_flag, 1, 1, 0))
2414: into l_exp_flag
2415: from mtl_material_transactions mmt,
2416: wip_discrete_jobs wdj,
2417: wip_accounting_classes wac
2418: where mmt.transaction_id = i_txn_id
2419: and mmt.organization_id = i_org_id
2420: and wdj.organization_id = i_org_id