eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_ROUTINGS

Line 5944: FROM msc_routings

5940: l_routing_seq_id := p_routing_seq_id;
5941: ELSE
5942: SELECT routing_sequence_id
5943: INTO l_routing_seq_id
5944: FROM msc_routings
5945: WHERE sr_instance_id = p_instance_id
5946: AND plan_id = p_plan_id
5947: AND organization_id = p_organization_id
5948: AND assembly_item_id = l_inventory_item_id;

Line 5978: FROM msc_routings

5974: -- get the routing flag to determine the type of routing
5975: BEGIN
5976: SELECT cfm_routing_flag, routing_sequence_id
5977: INTO l_routing_type,l_routing_number
5978: FROM msc_routings
5979: WHERE plan_id = p_plan_id and
5980: organization_id = p_organization_id and
5981: sr_instance_id = p_instance_id and
5982: assembly_item_id = l_inventory_item_id and

Line 6110: MSC_ROUTINGS RTG,

6106:
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

Line 6284: MSC_ROUTINGS RTG,

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,
6286: MSC_BOM_COMPONENTS mbc,
6287: MSC_OPERATION_COMPONENTS moc,
6288: MSC_OPERATION_RESOURCE_SEQS SEQ,

Line 6576: MSC_ROUTINGS RTG,

6572: --agilent chnages: since plan already store the data in right uom, we dont need to convert it
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

Line 6777: MSC_ROUTINGS RTG,

6773: DR.Resource_code Resource_code
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

Line 6927: MSC_ROUTINGS RTG,

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,
6929: MSC_BOM_COMPONENTS mbc,
6930: MSC_OPERATION_COMPONENTS moc,
6931: MSC_OPERATION_RESOURCE_SEQS SEQ,

Line 7123: MSC_ROUTINGS RTG,

7119: l_null_char department_code,
7120: l_null_char resource_Code
7121: FROM MSC_CALENDAR_DATES C2,
7122: MSC_CALENDAR_DATES C1,
7123: MSC_ROUTINGS RTG,
7124: MSC_SYSTEM_ITEMS I
7125: WHERE I.PLAN_ID = RTG.PLAN_ID
7126: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7127: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7244: MSC_ROUTINGS RTG,

7240: DR.Department_code Department_code,
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,

Line 7337: MSC_ROUTINGS RTG,

7333: l_null_char department_code,
7334: l_null_char resource_Code
7335: FROM MSC_CALENDAR_DATES C2,
7336: MSC_CALENDAR_DATES C1,
7337: MSC_ROUTINGS RTG,
7338: MSC_SYSTEM_ITEMS I
7339: WHERE I.PLAN_ID = RTG.PLAN_ID
7340: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7341: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7466: FROM MSC_ROUTINGS RTG

7462: AND (DR.LINE_FLAG <> 1
7463: OR
7464: (DR.LINE_FLAG = 1 AND
7465: EXISTS ( SELECT 'CTP'
7466: FROM MSC_ROUTINGS RTG
7467: WHERE RTG.PLAN_ID = p_plan_id
7468: AND RTG.SR_INSTANCE_ID = B.SR_INSTANCE_ID
7469: AND RTG.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
7470: AND RTG.ORGANIZATION_ID = B.ORGANIZATION_ID

Line 9847: -- Bug 4143668, Commented as separate SQLs will be used for routing_type, first_op_seq_num in msc_routings

9843: IF l_routing_seq_id is not null THEN --4570421 replaced p_routing_seq_id by l_routing_seq_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

Line 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

Line 9875: FROM msc_routings r

9871: -- Bug 4143668, check routing type and first_op_seq_num at routing level
9872: -- Also removed check for assembly item and org as routing sequence, plan and instance is unique.
9873: SELECT r.cfm_routing_flag, r.first_op_seq_num
9874: INTO l_routing_type, l_first_op_seq_num
9875: FROM msc_routings r
9876: WHERE r.plan_id = p_plan_id
9877: AND r.sr_instance_id = p_instance_id
9878: AND r.routing_sequence_id = l_routing_seq_id; --4570421 replaced p_routing_seq_id by l_routing_seq_id
9879: