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 6283: MSC_CTO_BOM mcbom1,

6279: DR.Department_code department_code,
6280: DR.resource_code resource_code
6281:
6282: FROM
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,

Line 6285: MSC_CTO_BOM mcbom2,

6281:
6282: FROM
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,

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

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

Line 6779: MSC_CTO_BOM mcbom1,

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

Line 6927: MSC_CTO_BOM mcbom1,

6923: DECODE(OP.REVERSE_CUMULATIVE_YIELD,0,1,NVL(OP.REVERSE_CUMULATIVE_YIELD, 1)) reverse_cumulative_yield,--4694958
6924: DR.Department_code Department_code,
6925: DR.Resource_code Resource_code
6926: FROM
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,

Line 6929: MSC_CTO_BOM mcbom2,

6925: DR.Resource_code Resource_code
6926: FROM
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,

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

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