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 6573: -- MSC_UOM_CONVERSIONS MUC2,

6569:
6570: FROM
6571: -- krajan : 2408696
6572: --agilent chnages: since plan already store the data in right uom, we dont need to convert it
6573: -- MSC_UOM_CONVERSIONS MUC2,
6574: -- MSC_UOM_CONVERSIONS MUC1,
6575: MSC_SYSTEM_ITEMS I,
6576: MSC_ROUTINGS RTG,
6577: MSC_ROUTING_OPERATIONS OP,

Line 6574: -- MSC_UOM_CONVERSIONS MUC1,

6570: FROM
6571: -- krajan : 2408696
6572: --agilent chnages: since plan already store the data in right uom, we dont need to convert it
6573: -- MSC_UOM_CONVERSIONS MUC2,
6574: -- MSC_UOM_CONVERSIONS MUC1,
6575: MSC_SYSTEM_ITEMS I,
6576: MSC_ROUTINGS RTG,
6577: MSC_ROUTING_OPERATIONS OP,
6578: MSC_OPERATION_RESOURCE_SEQS SEQ,

Line 7761: FROM msc_uom_conversions

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

Line 7773: FROM msc_uom_conversions

7769: --- now convert resource uom into base uom
7770: BEGIN
7771: SELECT conversion_rate
7772: INTO l_res_conversion_rate
7773: FROM msc_uom_conversions
7774: WHERE inventory_item_id = 0
7775: AND sr_instance_id = p_instance_id
7776: AND UOM_CODE = l_res_uom;
7777: EXCEPTION