DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on MTL_ITEM_SUB_VAL_V

Line 570: from mtl_system_items msi, mtl_item_sub_val_v msvv

566: and msi.restrict_subinventories_code = 2
567: )
568: union (
569: select 1
570: from mtl_system_items msi, mtl_item_sub_val_v msvv
571: where mti.inventory_item_id = msi.inventory_item_id
572: and mti.organization_id = msi.organization_id
573: and msi.restrict_subinventories_code = 1
574: and msi.inventory_asset_flag = 'N'