DBA Data[Home] [Help]

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ROUTINGS

Line 263: msc_routings model_routing,

259: and SR_INSTANCE_ID=MSC_CL_COLLECTION.v_instance_id
260: and (INVENTORY_ITEM_ID,organization_id) in (
261: select current_item.inventory_item_id,current_item.organization_id
262: from
263: msc_routings model_routing,
264: msc_routings option_class_routing,
265: msc_system_items model_item,
266: msc_system_items current_item
267: where

Line 264: msc_routings option_class_routing,

260: and (INVENTORY_ITEM_ID,organization_id) in (
261: select current_item.inventory_item_id,current_item.organization_id
262: from
263: msc_routings model_routing,
264: msc_routings option_class_routing,
265: msc_system_items model_item,
266: msc_system_items current_item
267: where
268: current_item.bom_item_type = 2