DBA Data[Home] [Help]

APPS.INVPVDR7 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 734: from MTL_ITEM_SUB_INVENTORIES i

730: l_message_name := 'INV_IOI_PROCESS_SUP_SUB';
731: elsif cr.RESTRICT_SUBINVENTORIES_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' then
732: begin
733: select 'x' INTO l_temp
734: from MTL_ITEM_SUB_INVENTORIES i
735: where i.inventory_item_id = cr.inventory_item_id
736: and i.ORGANIZATION_ID = cr.ORGANIZATION_ID
737: and i.SECONDARY_INVENTORY = cr.PROCESS_SUPPLY_SUBINVENTORY;
738:

Line 918: from MTL_ITEM_SUB_INVENTORIES i

914: l_message_name := 'INV_IOI_PROCESS_YIELD_SUB';
915: elsif cr.RESTRICT_SUBINVENTORIES_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' then
916: begin
917: select 'x' INTO l_temp
918: from MTL_ITEM_SUB_INVENTORIES i
919: where i.inventory_item_id = cr.inventory_item_id
920: and i.ORGANIZATION_ID = cr.ORGANIZATION_ID
921: and i.SECONDARY_INVENTORY = cr.PROCESS_YIELD_SUBINVENTORY;
922: