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_PERIOD_BALANCES

Line 396: -- cursor to collect current WIP balances from wip_period_balances (WPB)

392:
393: /*-----------------------
394: cursor c_curr_bal
395: -----------------------*/
396: -- cursor to collect current WIP balances from wip_period_balances (WPB)
397: -- by item and bom revision for a specified organization.
398: -- We assume that the current WIP balance for flow schedules will allways
399: -- be zero because flow schedules are maintained with work-order-less
400: -- completion where all transactions are backflushed.

Line 423: from wip_period_balances wpb,

419: - nvl(pl_material_overhead_var,0)
420: - nvl(pl_resource_var,0)
421: - nvl(pl_outside_processing_var,0)
422: - nvl(pl_overhead_var,0)) curr_wip_bal
423: from wip_period_balances wpb,
424: wip_discrete_jobs wdj
425: where wpb.wip_entity_id = wdj.wip_entity_id
426: and wdj.status_type in (3,4,5,6,14,15)
427: -- released, complete, complete no charge, on hold,

Line 454: from wip_period_balances wpb,

450: - nvl(pl_material_overhead_var,0)
451: - nvl(pl_resource_var,0)
452: - nvl(pl_outside_processing_var,0)
453: - nvl(pl_overhead_var,0)) curr_wip_bal
454: from wip_period_balances wpb,
455: wip_repetitive_schedules wrs,
456: wip_entities we
457: where wpb.wip_entity_id = wrs.wip_entity_id
458: and wpb.wip_entity_id = we.wip_entity_id