DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on MTL_ITEM_SUB_INVENTORIES

Line 38: FROM mtl_item_sub_inventories

34: then
35: BEGIN
36: SELECT 'Y'
37: into var_stk
38: FROM mtl_item_sub_inventories
39: WHERE organization_id = arg_org_id
40: AND inventory_item_id = arg_item_id
41: AND secondary_inventory = arg_sub_inv;
42:

Line 130: from mtl_item_sub_inventories misi,

126: select misi.source_organization_id,
127: misi.source_subinventory
128: into var_source_org,
129: var_source_sub
130: from mtl_item_sub_inventories misi,
131: org_organization_definitions ood,
132: financials_system_parameters fsp
133: where misi.organization_id = arg_dest_organization_id
134: and misi.inventory_item_id = arg_item_id