DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 9203: FROM mtl_onhand_quantities_detail moqd

9199: -- For Lots with zero onhand it will be recalculated based on shelf life in next sql.
9200: AND ( mti.wip_entity_type = WIP_CONSTANTS.DISCRETE or
9201: (mti.wip_entity_type = WIP_CONSTANTS.LOTBASED and
9202: 0 <> (select nvl(sum(primary_transaction_quantity),0)
9203: FROM mtl_onhand_quantities_detail moqd
9204: WHERE moqd.inventory_item_id = mti.inventory_item_id
9205: AND moqd.organization_id = mti.organization_id
9206: AND moqd.lot_number = mtli.lot_number
9207: )