[Home] [Help]
APPS.MSC_ATP_FUNC dependencies on MSC_ITEM_HIERARCHY_MV
Line 1054: FROM msc_item_hierarchy_mv mv,
1050: END IF;
1051:
1052: SELECT Count(1)
1053: INTO l_count
1054: FROM msc_item_hierarchy_mv mv,
1055: msc_system_items item
1056: WHERE item.sr_instance_id = p_instance_id
1057: and item.sr_inventory_item_id = p_inventory_item_id
1058: and item.organization_id = p_organization_id