DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 276: and EXISTS (select secondary_inventory from mtl_item_sub_inventories

272: and organization_id = p_org_id
273: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
274: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
275: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y'
276: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
277: where secondary_inventory = secondary_inventory_name
278: and inventory_item_id = p_item_id
279: and organization_id = p_org_id);
280: end if ; -- end of inner if