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_CTO_BOM

Line 5933: FROM msc_cto_bom

5929: SELECT DECODE(MSC_ATP_PVT.G_ITEM_INFO_REC.bom_item_type, 1,
5930: p_line_identifier, ATO_PARENT_MODEL_LINE_ID)
5931: -- End Bug 3358981
5932: INTO l_parent_line_id
5933: FROM msc_cto_bom
5934: WHERE line_id = p_line_identifier
5935: AND session_id = MSC_ATP_PVT.G_SESSION_ID
5936: AND sr_inventory_item_id = p_inventory_item_id;
5937:

Line 6108: MSC_CTO_BOM mcbom1,

6104: DR.Department_code department_code,
6105: DR.resource_code resource_code
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,

Line 6280: MSC_CTO_BOM mcbom1,

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

Line 6282: MSC_CTO_BOM mcbom2,

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,
6286: MSC_BOM_COMPONENTS mbc,

Line 6335: -- Join again to msc_cto_bom to obtain the components as well.

6331: AND TRUNC(proc.effectivity_date) <=
6332: TRUNC(GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
6333: AND TRUNC(NVL(proc.disable_date,GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE)+1))
6334: > TRUNC(GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
6335: -- Join again to msc_cto_bom to obtain the components as well.
6336: AND mcbom2.sr_instance_id = mcbom1.sr_instance_id
6337: AND mcbom2.session_id = mcbom1.session_id
6338: AND mcbom2.ato_parent_model_line_id = mcbom1.ATO_PARENT_MODEL_LINE_ID
6339: AND NVL(mcbom2.parent_line_id, l_parent_line_id) = mcbom1.line_id

Line 6775: MSC_CTO_BOM mcbom1,

6771: DECODE(OP.REVERSE_CUMULATIVE_YIELD,0,1,NVL(OP.REVERSE_CUMULATIVE_YIELD, 1)) reverse_cumulative_yield,--4694958
6772: DR.Department_code Department_code,
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,

Line 6923: MSC_CTO_BOM mcbom1,

6919: DECODE(OP.REVERSE_CUMULATIVE_YIELD,0,1,NVL(OP.REVERSE_CUMULATIVE_YIELD, 1)) reverse_cumulative_yield,--4694958
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,

Line 6925: MSC_CTO_BOM mcbom2,

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,
6929: MSC_BOM_COMPONENTS mbc,

Line 6978: -- Join again to msc_cto_bom to obtain the components as well.

6974: AND TRUNC(proc.effectivity_date) <=
6975: TRUNC(GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
6976: AND TRUNC(NVL(proc.disable_date,GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE)+1))
6977: > TRUNC(GREATEST(p_requested_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
6978: -- Join again to msc_cto_bom to obtain the components as well.
6979: AND mcbom2.sr_instance_id = mcbom1.sr_instance_id
6980: AND mcbom2.session_id = mcbom1.session_id
6981: AND mcbom2.ato_parent_model_line_id = mcbom1.ATO_PARENT_MODEL_LINE_ID
6982: AND NVL(mcbom2.parent_line_id, l_parent_line_id) = mcbom1.line_id