DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 194: and EXISTS (select secondary_inventory from mtl_item_sub_inventories

190: and organization_id = p_org_id
191: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
192: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
193: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y'
194: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
195: where secondary_inventory = secondary_inventory_name
196: and inventory_item_id = p_item_id
197: and organization_id = p_org_id);
198: end if ; -- end of inner if