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.

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 6287: MSC_ROUTINGS RTG,

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,
6289: MSC_BOM_COMPONENTS mbc,
6290: MSC_OPERATION_COMPONENTS moc,
6291: MSC_OPERATION_RESOURCE_SEQS SEQ,

Line 6580: MSC_ROUTINGS RTG,

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

Line 6781: MSC_ROUTINGS RTG,

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

Line 6931: MSC_ROUTINGS RTG,

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,
6933: MSC_BOM_COMPONENTS mbc,
6934: MSC_OPERATION_COMPONENTS moc,
6935: MSC_OPERATION_RESOURCE_SEQS SEQ,

Line 7127: MSC_ROUTINGS RTG,

7123: l_null_char department_code,
7124: l_null_char resource_Code
7125: FROM MSC_CALENDAR_DATES C2,
7126: MSC_CALENDAR_DATES C1,
7127: MSC_ROUTINGS RTG,
7128: MSC_SYSTEM_ITEMS I
7129: WHERE I.PLAN_ID = RTG.PLAN_ID
7130: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7131: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7248: MSC_ROUTINGS RTG,

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

Line 7341: MSC_ROUTINGS RTG,

7337: l_null_char department_code,
7338: l_null_char resource_Code
7339: FROM MSC_CALENDAR_DATES C2,
7340: MSC_CALENDAR_DATES C1,
7341: MSC_ROUTINGS RTG,
7342: MSC_SYSTEM_ITEMS I
7343: WHERE I.PLAN_ID = RTG.PLAN_ID
7344: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7345: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7470: FROM MSC_ROUTINGS RTG

7466: AND (DR.LINE_FLAG <> 1
7467: OR
7468: (DR.LINE_FLAG = 1 AND
7469: EXISTS ( SELECT 'CTP'
7470: FROM MSC_ROUTINGS RTG
7471: WHERE RTG.PLAN_ID = p_plan_id
7472: AND RTG.SR_INSTANCE_ID = B.SR_INSTANCE_ID
7473: AND RTG.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
7474: AND RTG.ORGANIZATION_ID = B.ORGANIZATION_ID

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

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

Line 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

Line 9881: FROM msc_routings r

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