APPS.CSP_SCH_INT_PVT dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 4188: from MRP_ITEM_SOURCING_LEVELS_V misl

4184: and inventory_item_id = c_item_id
4185: and organization_id = c_organization_id
4186: and source_type = 3;*/
4187: Select 'Y'
4188: from MRP_ITEM_SOURCING_LEVELS_V misl
4189: where misl.organization_id = c_organization_id
4190: and misl.assignment_set_id =c_assignment_id
4191: and inventory_item_id = c_item_id
4192: and SOURCE_TYPE = 3

Line 4193: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V

4189: where misl.organization_id = c_organization_id
4190: and misl.assignment_set_id =c_assignment_id
4191: and inventory_item_id = c_item_id
4192: and SOURCE_TYPE = 3
4193: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
4194: where organization_id = c_organization_id
4195: and assignment_set_id = c_assignment_id
4196: and inventory_item_id = c_item_id
4197: and sourcing_level not in (2,9));

Line 6179: FROM MRP_ITEM_SOURCING_LEVELS_V misl

6175: and organization_id = c_organization_id
6176: and source_type = 3;*/
6177: SELECT vendor_id,
6178: vendor_site_id
6179: FROM MRP_ITEM_SOURCING_LEVELS_V misl
6180: WHERE misl.organization_id = c_organization_id
6181: AND misl.assignment_set_id =c_assignment_id
6182: AND inventory_item_id = c_item_id
6183: AND SOURCE_TYPE = 3

Line 6186: FROM MRP_ITEM_SOURCING_LEVELS_V

6182: AND inventory_item_id = c_item_id
6183: AND SOURCE_TYPE = 3
6184: AND sourcing_level =
6185: (SELECT MIN(sourcing_level)
6186: FROM MRP_ITEM_SOURCING_LEVELS_V
6187: WHERE organization_id = c_organization_id
6188: AND assignment_set_id = c_assignment_id
6189: AND inventory_item_id = c_item_id
6190: AND sourcing_level NOT IN (2,9)