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_BOM_COMPONENTS

Line 3895: msc_bom_components comp, msc_boms bom, msc_system_items ch,

3891: ,comp.rounding_direction rounding_direction
3892: ,comp.component_yield_factor component_yield_factor
3893:
3894: FROM msc_system_items msi, msc_component_substitutes sub,
3895: msc_bom_components comp, msc_boms bom, msc_system_items ch,
3896: msc_system_items pt, mrp_atp_details_temp peg
3897: WHERE peg.session_id = MSC_ATP_PVT.G_SESSION_ID
3898: AND peg.pegging_id = p_parent_pegging_id
3899: AND pt.sr_instance_id = p_instance_id

Line 3971: msc_bom_components comp, msc_system_items ch

3967: ,comp.component_yield_factor component_yield_factor
3968: ,sub.usage_quantity/(comp.usage_quantity*comp.component_yield_factor) usage_qty --4775920
3969:
3970: FROM msc_system_items msi, msc_component_substitutes sub,
3971: msc_bom_components comp, msc_system_items ch
3972: WHERE ch.plan_id = p_plan_id
3973: AND ch.organization_id = p_organization_id
3974: AND ch.sr_instance_id = p_instance_id
3975: AND ch.sr_inventory_item_id = p_inventory_item_id

Line 6286: MSC_BOM_COMPONENTS mbc,

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,
6290: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept

Line 6929: MSC_BOM_COMPONENTS mbc,

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,
6933: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept

Line 9373: MSC_BOM_COMPONENTS MBC,

9369: MBC.USAGE_QUANTITY*mbc.component_yield_factor usage_qty --4775920
9370: FROM MSC_SYSTEM_ITEMS I2,
9371: MSC_CALENDAR_DATES C2,
9372: 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

Line 9520: MSC_BOM_COMPONENTS MBC,

9516: MBC.USAGE_QUANTITY*mbc.component_yield_factor --4775920
9517: FROM MSC_SYSTEM_ITEMS I2,
9518: MSC_CALENDAR_DATES C2,
9519: MSC_CALENDAR_DATES C1,
9520: MSC_BOM_COMPONENTS MBC,
9521: MSC_BOMS BOMS
9522: WHERE BOMS.PLAN_ID = p_plan_id
9523: AND BOMS.SR_INSTANCE_ID = p_instance_id
9524: AND BOMS.ORGANIZATION_ID = p_organization_id

Line 9962: ---- Get the bom from msc_bom_components and network routing

9958:
9959: -- 3027711
9960: IF l_bill_seq_id is not null THEN
9961:
9962: ---- Get the bom from msc_bom_components and network routing
9963: -- ATP4drp open DRP specific cursor for DRP plans.
9964: IF NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) <> 5 THEN
9965:
9966: OPEN net_rout_comp(l_bill_seq_id, -- (3004862) circular BOM issue: call with changed parameter