[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,
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,
6286: MSC_BOM_COMPONENTS mbc,
6287: MSC_OPERATION_COMPONENTS moc,
6288: MSC_OPERATION_RESOURCE_SEQS SEQ,
6289: MSC_OPERATION_RESOURCES RES,
6573: -- MSC_UOM_CONVERSIONS MUC2,
6574: -- MSC_UOM_CONVERSIONS MUC1,
6575: MSC_SYSTEM_ITEMS I,
6576: MSC_ROUTINGS RTG,
6577: MSC_ROUTING_OPERATIONS OP,
6578: MSC_OPERATION_RESOURCE_SEQS SEQ,
6579: MSC_OPERATION_RESOURCES RES,
6580: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6581: MSC_CALENDAR_DATES C1,
6774: FROM
6775: MSC_CTO_BOM mcbom1,
6776: -- MSC_SYSTEM_ITEMS I, Bug 3432530 Comment out Join table
6777: MSC_ROUTINGS RTG,
6778: MSC_ROUTING_OPERATIONS OP,
6779: MSC_OPERATION_RESOURCE_SEQS SEQ,
6780: MSC_OPERATION_RESOURCES RES,
6781: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6782: MSC_CALENDAR_DATES C1,
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,
6929: MSC_BOM_COMPONENTS mbc,
6930: MSC_OPERATION_COMPONENTS moc,
6931: MSC_OPERATION_RESOURCE_SEQS SEQ,
6932: MSC_OPERATION_RESOURCES RES,
7241: DR.Resource_code Resource_code
7242: FROM
7243: MSC_SYSTEM_ITEMS I,
7244: MSC_ROUTINGS RTG,
7245: MSC_ROUTING_OPERATIONS OP,
7246: MSC_OPERATION_RESOURCE_SEQS SEQ,
7247: MSC_OPERATION_RESOURCES RES,
7248: MSC_DEPARTMENT_RESOURCES DR,
7249: MSC_CALENDAR_DATES C1,
9373: MSC_BOM_COMPONENTS MBC,
9374: MSC_BOMS BOMS,
9375: MSC_SYSTEM_ITEMS I,
9376: MSC_OPERATION_COMPONENTS OPC,
9377: MSC_ROUTING_OPERATIONS OP
9378: WHERE I.PLAN_ID = BOMS.PLAN_ID
9379: AND I.SR_INSTANCE_ID = BOMS.SR_INSTANCE_ID
9380: AND I.INVENTORY_ITEM_ID = BOMS.ASSEMBLY_ITEM_ID
9381: AND I.ORGANIZATION_ID = BOMS.ORGANIZATION_ID
9844: BEGIN
9845:
9846: ---bug 2320808, set l_first_op_RCY to 1 if null
9847: -- Bug 4143668, Commented as separate SQLs will be used for routing_type, first_op_seq_num in msc_routings
9848: -- and l_first_op_RCY from msc_routing_operations
9849: /*
9850: SELECT r.cfm_routing_flag, NVL(op.reverse_cumulative_yield,1)
9851: INTO l_routing_type, l_first_op_RCY
9852: FROM msc_routings r, msc_routing_operations op
9848: -- and l_first_op_RCY from msc_routing_operations
9849: /*
9850: SELECT r.cfm_routing_flag, NVL(op.reverse_cumulative_yield,1)
9851: INTO l_routing_type, l_first_op_RCY
9852: FROM msc_routings r, msc_routing_operations op
9853: WHERE r.plan_id = p_plan_id and
9854: r.organization_id = p_organization_id and
9855: r.sr_instance_id = p_instance_id and
9856: -- r.assembly_item_id = l_inv_item_id and
9886: /* Not needed as of now as RCY is not populated for non-network routing.
9887: IF l_first_op_seq_num IS NULL THEN
9888: SELECT MIN(op.operation_seq_num)
9889: INTO l_first_op_seq_num
9890: FROM msc_routing_operations op
9891: WHERE op.routing_sequence_id = p_routing_seq_id
9892: AND op.sr_instance_id = p_instance_id
9893: AND op.plan_id = p_plan_id;
9894:
9901: -- Bug 4143668, get first operation's RCY based on op seq num found earlier
9902: IF l_first_op_seq_num IS NOT NULL THEN
9903: SELECT DECODE(op.reverse_cumulative_yield,0,1,NVL(op.reverse_cumulative_yield,1)) --4694958
9904: INTO l_first_op_RCY
9905: FROM msc_routing_operations op
9906: WHERE op.plan_id = p_plan_id
9907: AND op.sr_instance_id = p_instance_id
9908: AND op.routing_sequence_id = l_routing_seq_id --4570421 replaced p_routing_seq_id by l_routing_seq_id
9909: AND op.operation_seq_num = l_first_op_seq_num