APPS.OPIMPXWP dependencies on MTL_TRANSACTION_ACCOUNTS

Line 33: from mtl_transaction_accounts mta,

29: select we.primary_item_id item_id, -- matl charges for discrete jobs
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

Line 54: from mtl_transaction_accounts mta,

50: select we.primary_item_id item_id, -- matl charges for rep. schedules
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

Line 75: from mtl_transaction_accounts mta,

71: select we.primary_item_id item_id, -- matl charges for flow schedules
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

Line 482: from mtl_transaction_accounts mta,

478: cursor c_txn_sum(c_end_date DATE) is
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

Line 500: from mtl_transaction_accounts mta,

496: UNION ALL
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

Line 518: from mtl_transaction_accounts mta,

514: UNION ALL
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