[Home] [Help]
6280: DR.resource_code resource_code
6281:
6282: FROM
6283: MSC_CTO_BOM mcbom1,
6284: MSC_PROCESS_EFFECTIVITY proc,
6285: MSC_CTO_BOM mcbom2,
6286: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6287: MSC_ROUTINGS RTG,
6288: MSC_ROUTING_OPERATIONS OP,
6307: --AND (mcbom1.parent_line_id = p_line_identifier or
6308: -- Handle situation when parent_line_id is null.
6309: -- Basic thing is that this section should handle all cases.
6310: -- mcbom1.inventory_item_id = l_inventory_item_id )
6311: -- Join to msc_process_effectivity
6312: AND proc.plan_id = p_plan_id
6313: AND proc.sr_instance_id = mcbom1.sr_instance_id
6314: AND proc.organization_id = p_organization_id
6315: AND proc.item_id = mcbom1.inventory_item_id
6924: DR.Department_code Department_code,
6925: DR.Resource_code Resource_code
6926: FROM
6927: MSC_CTO_BOM mcbom1,
6928: MSC_PROCESS_EFFECTIVITY proc,
6929: MSC_CTO_BOM mcbom2,
6930: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6931: MSC_ROUTINGS RTG,
6932: MSC_ROUTING_OPERATIONS OP,
6951: --AND (mcbom1.parent_line_id = p_line_identifier or
6952: -- Handle situation when parent_line_id is null.
6953: -- Basic thing is that this section should handle all cases.
6954: -- mcbom1.inventory_item_id = l_inventory_item_id )
6955: -- Join to msc_process_effectivity
6956: AND proc.plan_id = p_plan_id
6957: AND proc.sr_instance_id = mcbom1.sr_instance_id
6958: AND proc.organization_id = p_organization_id
6959: AND proc.item_id = mcbom1.inventory_item_id