DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on WIP_DISCRETE_JOBS

Line 881: wip_discrete_jobs wdj,

877: 3, 0,
878: 4, decode(i_exp_flag, 1, 1, 0))
879: into l_exp_flag
880: from mtl_material_transactions mmt,
881: wip_discrete_jobs wdj,
882: wip_accounting_classes wac
883: where mmt.transaction_id = i_txn_id
884: and mmt.organization_id = i_org_id
885: and wdj.organization_id = i_org_id

Line 3107: -- non cfm then use wip_discrete_jobs

3103: and wfs.wip_entity_id = mmt.transaction_source_id
3104: and wac.organization_id = i_org_id
3105: and wac.class_code = wfs.class_code;
3106: else
3107: -- non cfm then use wip_discrete_jobs
3108: -- class_type 1 and 3 : asset job, 4 : exp job
3109: select decode(wac.class_type, 1, 0,
3110: 3, 0,
3111: 4, decode(l_exp1, 1, 1, 0))

Line 3114: wip_discrete_jobs wdj,

3110: 3, 0,
3111: 4, decode(l_exp1, 1, 1, 0))
3112: into l_exp2
3113: from mtl_material_transactions mmt,
3114: wip_discrete_jobs wdj,
3115: wip_accounting_classes wac
3116: where mmt.transaction_id = i_txn_id
3117: and mmt.organization_id = i_org_id
3118: and wdj.organization_id = i_org_id