APPS.CSP_SCH_INT_PVT dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 1948: from MRP_ITEM_SOURCING_LEVELS_V misl

1944: and inventory_item_id = c_item_id
1945: and organization_id = c_organization_id
1946: and source_type = 3;*/
1947: Select 'Y'
1948: from MRP_ITEM_SOURCING_LEVELS_V misl
1949: where misl.organization_id = c_organization_id
1950: and misl.assignment_set_id =c_assignment_id
1951: and inventory_item_id = c_item_id
1952: and SOURCE_TYPE = 3

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

1949: where misl.organization_id = c_organization_id
1950: and misl.assignment_set_id =c_assignment_id
1951: and inventory_item_id = c_item_id
1952: and SOURCE_TYPE = 3
1953: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
1954: where organization_id = c_organization_id
1955: and assignment_set_id = c_assignment_id
1956: and inventory_item_id = c_item_id
1957: and sourcing_level not in (2,9));

Line 3743: from MRP_ITEM_SOURCING_LEVELS_V misl

3739: and inventory_item_id = c_item_id
3740: and organization_id = c_organization_id
3741: and source_type = 3;*/
3742: Select vendor_id, vendor_site_id
3743: from MRP_ITEM_SOURCING_LEVELS_V misl
3744: where misl.organization_id = c_organization_id
3745: and misl.assignment_set_id =c_assignment_id
3746: and inventory_item_id = c_item_id
3747: and SOURCE_TYPE = 3

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

3744: where misl.organization_id = c_organization_id
3745: and misl.assignment_set_id =c_assignment_id
3746: and inventory_item_id = c_item_id
3747: and SOURCE_TYPE = 3
3748: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
3749: where organization_id = c_organization_id
3750: and assignment_set_id = c_assignment_id
3751: and inventory_item_id = c_item_id
3752: and sourcing_level not in (2,9));