eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPLVCP dependencies on WIP_DISCRETE_JOBS

Line 815: wip_discrete_jobs wdj,

811: 3, 0,
812: 4, decode(i_exp_flag, 1, 1, 0))
813: into l_exp_flag
814: from mtl_material_transactions mmt,
815: wip_discrete_jobs wdj,
816: wip_accounting_classes wac
817: where mmt.transaction_id = i_txn_id
818: and mmt.organization_id = i_org_id
819: and wdj.organization_id = i_org_id

Line 3041: -- non cfm then use wip_discrete_jobs

3037: and wfs.wip_entity_id = mmt.transaction_source_id
3038: and wac.organization_id = i_org_id
3039: and wac.class_code = wfs.class_code;
3040: else
3041: -- non cfm then use wip_discrete_jobs
3042: -- class_type 1 and 3 : asset job, 4 : exp job
3043: select decode(wac.class_type, 1, 0,
3044: 3, 0,
3045: 4, decode(l_exp1, 1, 1, 0))

Line 3048: wip_discrete_jobs wdj,

3044: 3, 0,
3045: 4, decode(l_exp1, 1, 1, 0))
3046: into l_exp2
3047: from mtl_material_transactions mmt,
3048: wip_discrete_jobs wdj,
3049: wip_accounting_classes wac
3050: where mmt.transaction_id = i_txn_id
3051: and mmt.organization_id = i_org_id
3052: and wdj.organization_id = i_org_id