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 WIP_FLOW_SCHEDULES

Line 78: wip_flow_schedules wfs

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
81: and mmt.transaction_source_id = we.wip_entity_id
82: and mmt.transaction_id = mta.transaction_id

Line 136: wip_flow_schedules wfs

132: trunc(wt.transaction_date) txn_date,
133: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
134: from wip_transactions wt,
135: wip_transaction_accounts wta,
136: wip_flow_schedules wfs
137: where wt.organization_id = i_org_id
138: and wt.transaction_id = wta.transaction_id
139: and wta.accounting_line_type = 7
140: and wt.transaction_date between i_push_start_wip_txn_date

Line 521: wip_flow_schedules wfs

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
524: and mmt.transaction_source_id = we.wip_entity_id
525: and mmt.transaction_id = mta.transaction_id

Line 570: wip_flow_schedules wfs

566: wfs.bom_revision b_revision,
567: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
568: from wip_transactions wt,
569: wip_transaction_accounts wta,
570: wip_flow_schedules wfs
571: where wt.organization_id = i_org_id
572: and wt.transaction_id = wta.transaction_id
573: and wta.accounting_line_type = 7
574: and wt.transaction_date between i_push_start_wip_txn_date