[Home] [Help]
6107: FROM
6108: MSC_CTO_BOM mcbom1,
6109: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6110: MSC_ROUTINGS RTG,
6111: MSC_ROUTING_OPERATIONS OP,
6112: MSC_OPERATION_RESOURCE_SEQS SEQ,
6113: MSC_OPERATION_RESOURCES RES,
6114: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6115: MSC_CALENDAR_DATES C1,
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,
6289: MSC_BOM_COMPONENTS mbc,
6290: MSC_OPERATION_COMPONENTS moc,
6291: MSC_OPERATION_RESOURCE_SEQS SEQ,
6292: MSC_OPERATION_RESOURCES RES,
6577: -- MSC_UOM_CONVERSIONS MUC2,
6578: -- MSC_UOM_CONVERSIONS MUC1,
6579: MSC_SYSTEM_ITEMS I,
6580: MSC_ROUTINGS RTG,
6581: MSC_ROUTING_OPERATIONS OP,
6582: MSC_OPERATION_RESOURCE_SEQS SEQ,
6583: MSC_OPERATION_RESOURCES RES,
6584: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6585: MSC_CALENDAR_DATES C1,
6778: FROM
6779: MSC_CTO_BOM mcbom1,
6780: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6781: MSC_ROUTINGS RTG,
6782: MSC_ROUTING_OPERATIONS OP,
6783: MSC_OPERATION_RESOURCE_SEQS SEQ,
6784: MSC_OPERATION_RESOURCES RES,
6785: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6786: MSC_CALENDAR_DATES C1,
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,
6933: MSC_BOM_COMPONENTS mbc,
6934: MSC_OPERATION_COMPONENTS moc,
6935: MSC_OPERATION_RESOURCE_SEQS SEQ,
6936: MSC_OPERATION_RESOURCES RES,
7245: DR.Resource_code Resource_code
7246: FROM
7247: MSC_SYSTEM_ITEMS I,
7248: MSC_ROUTINGS RTG,
7249: MSC_ROUTING_OPERATIONS OP,
7250: MSC_OPERATION_RESOURCE_SEQS SEQ,
7251: MSC_OPERATION_RESOURCES RES,
7252: MSC_DEPARTMENT_RESOURCES DR,
7253: MSC_CALENDAR_DATES C1,
9378: MSC_BOM_COMPONENTS MBC,
9379: MSC_BOMS BOMS,
9380: MSC_SYSTEM_ITEMS I,
9381: MSC_OPERATION_COMPONENTS OPC,
9382: MSC_ROUTING_OPERATIONS OP
9383: WHERE I.PLAN_ID = BOMS.PLAN_ID
9384: AND I.SR_INSTANCE_ID = BOMS.SR_INSTANCE_ID
9385: AND I.INVENTORY_ITEM_ID = BOMS.ASSEMBLY_ITEM_ID
9386: AND I.ORGANIZATION_ID = BOMS.ORGANIZATION_ID
9850: BEGIN
9851:
9852: ---bug 2320808, set l_first_op_RCY to 1 if null
9853: -- Bug 4143668, Commented as separate SQLs will be used for routing_type, first_op_seq_num in msc_routings
9854: -- and l_first_op_RCY from msc_routing_operations
9855: /*
9856: SELECT r.cfm_routing_flag, NVL(op.reverse_cumulative_yield,1)
9857: INTO l_routing_type, l_first_op_RCY
9858: FROM msc_routings r, msc_routing_operations op
9854: -- and l_first_op_RCY from msc_routing_operations
9855: /*
9856: SELECT r.cfm_routing_flag, NVL(op.reverse_cumulative_yield,1)
9857: INTO l_routing_type, l_first_op_RCY
9858: FROM msc_routings r, msc_routing_operations op
9859: WHERE r.plan_id = p_plan_id and
9860: r.organization_id = p_organization_id and
9861: r.sr_instance_id = p_instance_id and
9862: -- r.assembly_item_id = l_inv_item_id and
9892: /* Not needed as of now as RCY is not populated for non-network routing.
9893: IF l_first_op_seq_num IS NULL THEN
9894: SELECT MIN(op.operation_seq_num)
9895: INTO l_first_op_seq_num
9896: FROM msc_routing_operations op
9897: WHERE op.routing_sequence_id = p_routing_seq_id
9898: AND op.sr_instance_id = p_instance_id
9899: AND op.plan_id = p_plan_id;
9900:
9907: -- Bug 4143668, get first operation's RCY based on op seq num found earlier
9908: IF l_first_op_seq_num IS NOT NULL THEN
9909: SELECT DECODE(op.reverse_cumulative_yield,0,1,NVL(op.reverse_cumulative_yield,1)) --4694958
9910: INTO l_first_op_RCY
9911: FROM msc_routing_operations op
9912: WHERE op.plan_id = p_plan_id
9913: AND op.sr_instance_id = p_instance_id
9914: AND op.routing_sequence_id = l_routing_seq_id --4570421 replaced p_routing_seq_id by l_routing_seq_id
9915: AND op.operation_seq_num = l_first_op_seq_num