DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1871: FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ

1867: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
1868: AND MLN.ORGANIZATION_ID = p_org.organization_id
1869: AND MLN.LOT_NUMBER = p_lot.lot_number
1870: AND MLN.LOT_NUMBER IN (SELECT LOT_NUMBER
1871: FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ
1872: WHERE MOQ.INVENTORY_ITEM_ID = p_item.inventory_item_id
1873: AND MOQ.ORGANIZATION_ID = p_org.organization_id
1874: AND MOQ.LOT_NUMBER = p_lot.lot_number
1875: AND MOQ.SUBINVENTORY_CODE =