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.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on MTL_SUPPLY

Line 474: -- MTL_SUPPLY table that stores unfinished internal orders.

470: -- collect only from global
471: -- start date
472: UNION ALL /* current internal order activity*/
473: -- Current intransit internal order activity is taken from the
474: -- MTL_SUPPLY table that stores unfinished internal orders.
475: -- Since this is the OPM extraction, need to ensure that
476: -- the org corresponding the internal order is an OPM org i.e.
477: -- PROCESS_ENABLED_FLAG = 'Y' in MTL_PARAMETERS.
478: -- The owning org for internal orders is determined by the FOB

Line 480: -- intransit_owning_org_id field of MTL_SUPPLY since the FOB

476: -- the org corresponding the internal order is an OPM org i.e.
477: -- PROCESS_ENABLED_FLAG = 'Y' in MTL_PARAMETERS.
478: -- The owning org for internal orders is determined by the FOB
479: -- which can be either receipt or shipment. We cannot use the
480: -- intransit_owning_org_id field of MTL_SUPPLY since the FOB
481: -- can be changed while the internal order is being processed.
482: -- In addition, there is a bug with that field, as far as I can
483: -- tell. The intransit_owning_org_id field is populated incorrectly
484: -- as of 10/31/02.

Line 485: -- Since MTL supply stores the Quantity (quantity released by the

481: -- can be changed while the internal order is being processed.
482: -- In addition, there is a bug with that field, as far as I can
483: -- tell. The intransit_owning_org_id field is populated incorrectly
484: -- as of 10/31/02.
485: -- Since MTL supply stores the Quantity (quantity released by the
486: -- shipping org in their primary UOM)
487: -- and the to_org_primary_quantity
488: -- (the primary quantity in the receiving org's primary UOM) we do
489: -- not need any UOM conversions.

Line 495: FROM mtl_supply sup,

491: ic_item.item_id item,
492: (decode (mip.fob_point,
493: 2, nvl (sup.quantity,0),
494: 1, nvl (sup.to_org_primary_quantity,0))) qty
495: FROM mtl_supply sup,
496: mtl_parameters mp,
497: mtl_system_items_b msi,
498: ic_whse_mst whse_mst,
499: ic_item_mst_b ic_item,