APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on MTL_PARAMETERS

Line 477: -- PROCESS_ENABLED_FLAG = 'Y' in MTL_PARAMETERS.

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
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.

Line 496: mtl_parameters mp,

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,
500: mtl_interorg_parameters mip,