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_X_VMI_UTIL_NEW dependencies on MSC_X_UTIL

Line 910: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

906: FETCH c2 INTO l_receipt_qty, l_primary_uom;
907: EXIT WHEN c2%NOTFOUND;
908: l_conv_rate := 1;
909: IF l_primary_uom <> p_uom_code THEN
910: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
911: l_primary_uom
912: , p_uom_code
913: , p_inventory_item_id
914: , l_conv_found

Line 930: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

926: l_last_receipt_date := NULL;
927: END IF;
928: l_conv_rate := 1;
929: IF l_primary_uom <> p_uom_code THEN
930: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
931: l_primary_uom
932: , p_uom_code
933: , p_inventory_item_id
934: , l_conv_found

Line 998: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

994: FETCH c1 INTO l_so_qty, l_primary_uom;
995: EXIT WHEN c1%NOTFOUND;
996: l_conv_rate := 1;
997: IF l_primary_uom <> p_uom_code THEN
998: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
999: l_primary_uom
1000: , p_uom_code
1001: , p_inventory_item_id
1002: , l_conv_found

Line 1016: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1012: FETCH c2 INTO l_req_qty, l_primary_uom;
1013: EXIT WHEN c2%NOTFOUND;
1014: l_conv_rate := 1;
1015: IF l_primary_uom <> p_uom_code THEN
1016: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1017: l_primary_uom
1018: , p_uom_code
1019: , p_inventory_item_id
1020: , l_conv_found

Line 1066: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1062: FETCH c1 INTO l_order_qty, l_primary_uom;
1063: EXIT WHEN c1%NOTFOUND;
1064: l_conv_rate := 1;
1065: IF l_primary_uom <> p_uom_code THEN
1066: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1067: l_primary_uom
1068: , p_uom_code
1069: , p_inventory_item_id
1070: , l_conv_found

Line 1136: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1132: FETCH c2 INTO l_intransit_quantity, l_primary_uom;
1133: EXIT WHEN c2%NOTFOUND;
1134: l_conv_rate := 1;
1135: IF l_primary_uom <> p_uom_code THEN
1136: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1137: l_primary_uom
1138: , p_uom_code
1139: , p_inventory_item_id
1140: , l_conv_found

Line 1158: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1154: r_intransit_nextasn_qty := 0.0;
1155: END IF;
1156: l_conv_rate := 1;
1157: IF l_primary_uom <> p_uom_code THEN
1158: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1159: l_primary_uom
1160: , p_uom_code
1161: , p_inventory_item_id
1162: , l_conv_found

Line 1232: msc_x_util.get_calendar_code(p_supplier_id,

1228:
1229:
1230: BEGIN
1231:
1232: msc_x_util.get_calendar_code(p_supplier_id,
1233: p_supplier_site_id,
1234: p_customer_id,
1235: p_customer_site_id,
1236: l_calendar_code,

Line 1377: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1373: ORDER BY new_schedule_date DESC;
1374:
1375: l_conv_rate := 1;
1376: IF l_primary_uom <> p_uom_code THEN
1377: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1378: l_primary_uom
1379: , p_uom_code
1380: , p_inventory_item_id
1381: , l_conv_found

Line 1410: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1406: r_onhand_date := l_allocated_date;
1407: END IF;
1408: l_conv_rate := 1;
1409: IF l_primary_uom <> p_uom_code THEN
1410: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1411: l_primary_uom
1412: , p_uom_code
1413: , p_inventory_item_id
1414: , l_conv_found

Line 1976: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

1972: EXIT WHEN order_forecast_cur%NOTFOUND;
1973:
1974: l_conv_rate := 1;
1975: IF order_forecast_rec.primary_uom <> p_uom_code THEN
1976: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
1977: order_forecast_rec.primary_uom
1978: , p_uom_code
1979: , p_inventory_item_id
1980: , l_conv_found

Line 2123: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

2119: FETCH safety_stock_cur INTO safety_stock_rec;
2120: EXIT WHEN safety_stock_cur%NOTFOUND;
2121: l_conv_rate := 1;
2122: IF safety_stock_rec.primary_uom <> p_uom_code THEN
2123: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
2124: safety_stock_rec.primary_uom
2125: , p_uom_code
2126: , p_inventory_item_id
2127: , l_conv_found

Line 2183: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(

2179: FETCH requisition_cur INTO requisition_rec;
2180: EXIT WHEN requisition_cur%NOTFOUND;
2181: l_conv_rate := 1;
2182: IF requisition_rec.primary_uom <> p_uom_code THEN
2183: MSC_X_UTIL.GET_UOM_CONVERSION_RATES(
2184: requisition_rec.primary_uom
2185: , p_uom_code
2186: , p_inventory_item_id
2187: , l_conv_found

Line 2301: l_intransit_lead_time := msc_x_util.get_customer_transit_time(p_supplier_id, l_source_site_id, p_customer_id, p_customer_site_id);

2297: AND maps.map_type = TP_MAP_TYPE_ORG;
2298: EXCEPTION WHEN OTHERS THEN NULL;
2299: END;
2300:
2301: l_intransit_lead_time := msc_x_util.get_customer_transit_time(p_supplier_id, l_source_site_id, p_customer_id, p_customer_site_id);
2302: ELSIF p_consigned = CONSIGNED AND p_source_org_id IS NOT NULL THEN
2303: BEGIN
2304:
2305: select mrp_atp_schedule_temp_s.nextval

Line 2383: msc_x_util.get_calendar_code(p_supplier_id,p_supplier_site_id,p_customer_id,p_customer_site_id,l_calendar_code,l_calendar_inst_id);

2379: , p_organization_id
2380: , p_sr_instance_id ) ;
2381:
2382:
2383: msc_x_util.get_calendar_code(p_supplier_id,p_supplier_site_id,p_customer_id,p_customer_site_id,l_calendar_code,l_calendar_inst_id);
2384: l_time_fence_end_date := msc_calendar.date_offset(l_calendar_code, l_calendar_inst_id, l_start_date, l_forecast_horizon, 99999);
2385:
2386: l_graph := vmiCustomerGraphInit(l_start_date, l_time_fence_end_date);
2387:

Line 2753: l_customer_transit_time :=MSC_X_UTIL.GET_CUSTOMER_TRANSIT_TIME

2749: /** total lead time calculated using appropriate
2750: * calendar code
2751: */
2752:
2753: l_customer_transit_time :=MSC_X_UTIL.GET_CUSTOMER_TRANSIT_TIME
2754: ( p_supplier_id, -- CP ids
2755: p_supplier_site_id,
2756: p_customer_id,
2757: p_customer_site_id );

Line 2772: msc_x_util.get_calendar_code(

2768: -- dbms_output.put_line(' avg daily demand is ' ||l_avg_daily_demand);
2769:
2770:
2771: /* Call the API to get the correct Calendar */
2772: msc_x_util.get_calendar_code(
2773: p_supplier_id,
2774: p_supplier_site_id,
2775: p_customer_id , --- OEM
2776: p_customer_site_id, -- oem Org

Line 3066: l_intransit_lead_time :=MSC_X_UTIL.GET_CUSTOMER_TRANSIT_TIME(

3062:
3063:
3064: END;
3065:
3066: l_intransit_lead_time :=MSC_X_UTIL.GET_CUSTOMER_TRANSIT_TIME(
3067: p_supplier_id,
3068: l_source_site_id,
3069: p_customer_id,
3070: p_customer_site_id);