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_UOM_CONVERSIONS

Line 390: MSC_UOM_CONVERSIONS MUC

386: --- these tables are added to determine how much apacity has already been consumed by the
387: --- existing supplies
388: MSC_SYSTEM_ITEMS I,
389: MSC_SUPPLIES S,
390: MSC_UOM_CONVERSIONS MUC
391: -- Bug 2675504, 2665805,
392: --bug3394866
393: WHERE DR.PLAN_ID = p_plan_id
394: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 516: MSC_UOM_CONVERSIONS MUC

512: --- these tables are added to determine how much apacity has already been consumed by the
513: --- existing supplies
514: MSC_SYSTEM_ITEMS I,
515: MSC_SUPPLIES S,
516: MSC_UOM_CONVERSIONS MUC
517: -- Bug 2675504, 2665805,
518: --bug3394866
519: WHERE DR.PLAN_ID = p_plan_id
520: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 1121: MSC_UOM_CONVERSIONS MUC

1117: -- 2859130 MSC_CALENDAR_DATES C,
1118: ---tables added for resource batching
1119: MSC_SYSTEM_ITEMS I,
1120: MSC_SUPPLIES S,
1121: MSC_UOM_CONVERSIONS MUC
1122: -- Bug 2675504, 2665805,
1123: --bug3394866
1124: WHERE DR.PLAN_ID = p_plan_id
1125: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 1344: MSC_UOM_CONVERSIONS MUC

1340: MSC_CALENDAR_DATES C,
1341: ---tables added for resource batching
1342: MSC_SYSTEM_ITEMS I,
1343: MSC_SUPPLIES S,
1344: MSC_UOM_CONVERSIONS MUC
1345: -- Bug 2675504, 2665805,
1346: --bug3394866
1347: WHERE DR.PLAN_ID = p_plan_id
1348: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 6577: -- MSC_UOM_CONVERSIONS MUC2,

6573:
6574: FROM
6575: -- krajan : 2408696
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,

Line 6578: -- MSC_UOM_CONVERSIONS MUC1,

6574: FROM
6575: -- krajan : 2408696
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,

Line 7765: FROM msc_uom_conversions

7761: ---first do item unit conversion to base uom
7762: BEGIN
7763: SELECT conversion_rate
7764: INTO l_item_conversion_rate
7765: FROM msc_uom_conversions
7766: WHERE inventory_item_id = 0
7767: AND sr_instance_id = p_instance_id
7768: AND UOM_CODE = l_req_capacity_uom;
7769: EXCEPTION

Line 7777: FROM msc_uom_conversions

7773: --- now convert resource uom into base uom
7774: BEGIN
7775: SELECT conversion_rate
7776: INTO l_res_conversion_rate
7777: FROM msc_uom_conversions
7778: WHERE inventory_item_id = 0
7779: AND sr_instance_id = p_instance_id
7780: AND UOM_CODE = l_res_uom;
7781: EXCEPTION