DBA Data[Home] [Help]

APPS.MRP_SOURCING_GRP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 33: FROM mtl_item_sub_inventories

29: then
30: BEGIN
31: SELECT 'Y'
32: into var_stk
33: FROM mtl_item_sub_inventories
34: WHERE organization_id = arg_org_id
35: AND inventory_item_id = arg_item_id
36: AND secondary_inventory = arg_sub_inv;
37:

Line 144: FROM mtl_item_sub_inventories misi,

140: SELECT misi.source_organization_id,
141: misi.source_subinventory
142: INTO var_source_org,
143: var_source_sub
144: FROM mtl_item_sub_inventories misi,
145: org_organization_definitions ood,
146: financials_system_parameters fsp
147: WHERE misi.organization_id = p_dest_organization_id
148: AND misi.inventory_item_id = p_item_id