APPS.CSTPAVCP dependencies on WIP_DISCRETE_JOBS

Line 1345: -- non cfm then use wip_discrete_jobs

1341: and wfs.wip_entity_id = mmt.transaction_source_id
1342: and wac.organization_id = i_org_id
1343: and wac.class_code = wfs.class_code;
1344: else
1345: -- non cfm then use wip_discrete_jobs
1346: -- class_type 1 and 3 : asset job, 4 : exp job
1347: select decode(wac.class_type, 1, 0,
1348: 3, 0,
1349: 6, 0,

Line 1353: wip_discrete_jobs wdj,

1349: 6, 0,
1350: 4, decode(l_exp1, 1, 1, 0))
1351: into l_exp2
1352: from mtl_material_transactions mmt,
1353: wip_discrete_jobs wdj,
1354: wip_accounting_classes wac
1355: where mmt.transaction_id = i_txn_id
1356: and mmt.organization_id = i_org_id
1357: and wdj.organization_id = i_org_id

Line 2253: wip_discrete_jobs wdj,

2249: 6, 0,
2250: 4, decode(i_exp_flag, 1, 1, 0))
2251: into l_exp_flag
2252: from mtl_material_transactions mmt,
2253: wip_discrete_jobs wdj,
2254: wip_accounting_classes wac
2255: where mmt.transaction_id = i_txn_id
2256: and mmt.organization_id = i_org_id
2257: and wdj.organization_id = i_org_id