[Home] [Help]
6277: DR.resource_code resource_code
6278:
6279: FROM
6280: MSC_CTO_BOM mcbom1,
6281: MSC_PROCESS_EFFECTIVITY proc,
6282: MSC_CTO_BOM mcbom2,
6283: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6284: MSC_ROUTINGS RTG,
6285: MSC_ROUTING_OPERATIONS OP,
6304: --AND (mcbom1.parent_line_id = p_line_identifier or
6305: -- Handle situation when parent_line_id is null.
6306: -- Basic thing is that this section should handle all cases.
6307: -- mcbom1.inventory_item_id = l_inventory_item_id )
6308: -- Join to msc_process_effectivity
6309: AND proc.plan_id = p_plan_id
6310: AND proc.sr_instance_id = mcbom1.sr_instance_id
6311: AND proc.organization_id = p_organization_id
6312: AND proc.item_id = mcbom1.inventory_item_id
6920: DR.Department_code Department_code,
6921: DR.Resource_code Resource_code
6922: FROM
6923: MSC_CTO_BOM mcbom1,
6924: MSC_PROCESS_EFFECTIVITY proc,
6925: MSC_CTO_BOM mcbom2,
6926: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6927: MSC_ROUTINGS RTG,
6928: MSC_ROUTING_OPERATIONS OP,
6947: --AND (mcbom1.parent_line_id = p_line_identifier or
6948: -- Handle situation when parent_line_id is null.
6949: -- Basic thing is that this section should handle all cases.
6950: -- mcbom1.inventory_item_id = l_inventory_item_id )
6951: -- Join to msc_process_effectivity
6952: AND proc.plan_id = p_plan_id
6953: AND proc.sr_instance_id = mcbom1.sr_instance_id
6954: AND proc.organization_id = p_organization_id
6955: AND proc.item_id = mcbom1.inventory_item_id