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.OPIMPXWP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 34: mtl_material_transactions mmt,

30: wdj.bom_revision b_revision,
31: trunc(mmt.transaction_date) txn_date,
32: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
33: from mtl_transaction_accounts mta,
34: mtl_material_transactions mmt,
35: wip_entities we,
36: wip_discrete_jobs wdj
37: where mmt.transaction_source_type_id = 5
38: and mmt.organization_id = i_org_id

Line 55: mtl_material_transactions mmt,

51: wrs.bom_revision b_revision,
52: trunc(mmt.transaction_date) txn_date,
53: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
54: from mtl_transaction_accounts mta,
55: mtl_material_transactions mmt,
56: wip_entities we,
57: wip_repetitive_schedules wrs
58: where mmt.transaction_source_type_id = 5
59: and mmt.organization_id = i_org_id

Line 76: mtl_material_transactions mmt,

72: wfs.bom_revision b_revision,
73: trunc(mmt.transaction_date) txn_date,
74: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
75: from mtl_transaction_accounts mta,
76: mtl_material_transactions mmt,
77: wip_entities we,
78: wip_flow_schedules wfs
79: where mmt.transaction_source_type_id = 5
80: and mmt.organization_id = i_org_id

Line 483: mtl_material_transactions mmt,

479: select we.primary_item_id item_id, -- matl charges for discrete jobs
480: wdj.bom_revision b_revision,
481: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
482: from mtl_transaction_accounts mta,
483: mtl_material_transactions mmt,
484: wip_entities we,
485: wip_discrete_jobs wdj
486: where mmt.transaction_source_type_id = 5
487: and mmt.organization_id = i_org_id

Line 501: mtl_material_transactions mmt,

497: select we.primary_item_id item_id, -- matl charges for rep. schedules
498: wrs.bom_revision b_revision,
499: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
500: from mtl_transaction_accounts mta,
501: mtl_material_transactions mmt,
502: wip_entities we,
503: wip_repetitive_schedules wrs
504: where mmt.transaction_source_type_id = 5
505: and mmt.organization_id = i_org_id

Line 519: mtl_material_transactions mmt,

515: select we.primary_item_id item_id, -- matl charges for flow schedules
516: wfs.bom_revision b_revision,
517: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
518: from mtl_transaction_accounts mta,
519: mtl_material_transactions mmt,
520: wip_entities we,
521: wip_flow_schedules wfs
522: where mmt.transaction_source_type_id = 5
523: and mmt.organization_id = i_org_id