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.MSD_TRANSLATE_FACT_DATA dependencies on MSD_COMMON_UTILITIES

Line 90: IF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE then

86: v_exclude_ISO := v_exclude_ISO ||
87: ' AND nvl(ORDER_SOURCE_ID, 0) <> 10 ';
88:
89: /* Check dest_table */
90: IF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE then
91:
92: /* Physically delete existing data before inserting new rows*/
93: v_sql_stmt := 'DELETE FROM msd_st_shipment_data '||
94: ' WHERE instance = ''' || p_instance_id || '''' ;

Line 154: ELSIF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE then

150:
151: /* Bug# 4747555 */
152: v_sql_stmt := v_sql_stmt || v_order_type_condition;
153:
154: ELSIF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE then
155: /* Mark delete for overlapping rows and Update its last_refresh_num */
156:
157: v_sql_stmt := ' UPDATE msd_shipment_data ' ||
158: ' SET last_refresh_num = ' || p_new_refresh_num ||

Line 206: if (p_source_table = MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE) then

202:
203:
204: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
205: rows into fact table*/
206: if (p_source_table = MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE) then
207: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
208: end if;
209:
210: END IF;

Line 216: IF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE then

212: EXECUTE IMMEDIATE v_sql_stmt
213: USING nvl(p_from_date, C_FROM_DATE),
214: nvl(p_to_date, C_TO_DATE);
215:
216: IF p_dest_table = MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE then
217:
218: Begin
219:
220: select 1 into v_ref_num

Line 319: IF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE then

315: v_exclude_ISO := v_exclude_ISO ||
316: ' AND nvl(ORDER_SOURCE_ID, 0) <> 10 ';
317:
318: /* Check dest_table */
319: IF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE then
320:
321: /* Physically delete existing data before inserting new rows*/
322: v_sql_stmt := 'DELETE FROM msd_st_booking_data '||
323: ' WHERE instance = ''' || p_instance_id || '''' ;

Line 384: ELSIF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE then

380:
381: /* Bug# 4747555 */
382: v_sql_stmt := v_sql_stmt || v_order_type_condition;
383:
384: ELSIF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE then
385:
386: /* Mark delete for overlapping rows and Update its last_refresh_num */
387:
388: v_sql_stmt := ' UPDATE msd_booking_data ' ||

Line 434: if (p_source_table = MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE) then

430:
431:
432: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
433: rows into fact table*/
434: if (p_source_table = MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE) then
435: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
436: end if;
437:
438: END IF;

Line 444: IF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE then

440: EXECUTE IMMEDIATE v_sql_stmt
441: USING nvl(p_from_date, C_FROM_DATE ),
442: nvl(p_to_date, C_TO_DATE );
443:
444: IF p_dest_table = MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE then
445:
446: Begin
447:
448: select 1 into v_ref_num

Line 570: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN

566:
567: v_instance_id := p_instance_id;
568: retcode :=0;
569:
570: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN
571: DELETE FROM msd_st_uom_conversions
572: WHERE instance = p_instance_id;
573:
574: v_sql_stmt := 'INSERT INTO ' || p_dest_table ||

Line 587: ELSIF p_dest_table = MSD_COMMON_UTILITIES.UOM_FACT_TABLE THEN

583: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
584: ' from ' || p_source_table || ' where 1 = 1';
585: --dbms_output.put_line(v_sql_stmt);
586: EXECUTE IMMEDIATE v_sql_stmt;
587: ELSIF p_dest_table = MSD_COMMON_UTILITIES.UOM_FACT_TABLE THEN
588: /* The Bug# is 4235162 -Code redundant*/
589: /*
590: OPEN c_delete;
591: FETCH c_delete BULK COLLECT INTO a_from_uom_class, a_to_uom_class, a_from_uom_code,

Line 748: IF (p_dest_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE) THEN

744: ' where 1 = 1';
745:
746: /* DWK. If dest_table is staging table, then we shouldn't delete
747: instance = '0' row */
748: IF (p_dest_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE) THEN
749: v_sql_stmt := v_sql_stmt || ' and nvl(instance, ''888'') <> '||'''0''';
750: END IF;
751:
752: v_date_range := v_date_range ||

Line 788: if p_source_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE then

784:
785: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
786: rows into fact table*/
787:
788: if p_source_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE then
789: v_sql_stmt := v_sql_stmt || ' and nvl(instance, ''888'') <> '||'''0''';
790: else
791: if p_from_date is not null or p_to_date is not null then
792: v_sql_stmt := v_sql_stmt ||

Line 898: if p_source_table = MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE then

894:
895: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
896: rows into fact table*/
897:
898: if p_source_table = MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE then
899: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
900: end if;
901:
902: -- insert into msd_test values(v_sql_stmt) ;

Line 1045: IF p_source_table = MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE then

1041:
1042: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
1043: rows into fact table*/
1044:
1045: IF p_source_table = MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE then
1046: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
1047: END IF;
1048:
1049:

Line 1117: IF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE THEN

1113: fetch get_cs_id into x_cs_id;
1114: close get_cs_id;
1115:
1116: /* Check dest_table */
1117: IF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE THEN
1118: v_sql_stmt := ' DELETE FROM ' || p_dest_table ||
1119: ' where instance = ''' || p_instance_id || '''' ||
1120: ' and forecast_designator = nvl(:p_fcst_desg, forecast_designator) ' ;
1121:

Line 1159: ELSIF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE THEN

1155: 'to_char(sr_demand_class_pk) ' ||
1156: ' FROM ' || p_source_table ||
1157: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1158:
1159: ELSIF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE THEN
1160:
1161: v_sql_stmt := ' UPDATE msd_mfg_forecast ' ||
1162: ' SET last_refresh_num = ' || p_new_refresh_num ||
1163: ', Action_code = ' || '''D''' ||

Line 1207: IF p_source_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE then

1203: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1204:
1205: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
1206: rows into fact table*/
1207: IF p_source_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE then
1208: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
1209: END IF;
1210:
1211: END IF;

Line 1215: if (p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) then

1211: END IF;
1212:
1213: EXECUTE IMMEDIATE v_sql_stmt USING p_fcst_desg ;
1214:
1215: if (p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) then
1216: INSERT INTO msd_cs_data_headers (
1217: CS_DATA_HEADER_ID,
1218: INSTANCE,
1219: CS_DEFINITION_ID,

Line 1286: IF p_dest_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE THEN

1282:
1283: retcode :=0;
1284:
1285: /* Check dest_table */
1286: IF p_dest_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE THEN
1287: v_sql_stmt := 'DELETE FROM ' || p_dest_table ||
1288: ' where instance = ''' || p_instance_id || '''' ||
1289: ' and price_list_name like nvl(:p_price_list, price_list_name) ';
1290: EXECUTE IMMEDIATE v_sql_stmt USING p_price_list;

Line 1325: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN

1321: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
1322: 'FROM ' || p_source_table || ' ' ||
1323: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1324:
1325: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN
1326: IF (p_price_list is not NULL) THEN
1327: UPDATE msd_price_list
1328: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1329: WHERE Action_code = 'I' and instance = p_instance_id and

Line 1372: IF p_source_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE then

1368: 'FROM ' || p_source_table || ' ' ||
1369: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1370: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
1371: rows into fact table*/
1372: IF p_source_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE then
1373: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
1374: END IF;
1375: END IF;
1376:

Line 1825: IF ( p_table_name = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) THEN

1821: /* Select min and max date for the forecast_date and rate_end_date. */
1822: l_str := 'SELECT min(forecast_date), max( nvl(rate_end_date, forecast_date))'||
1823: ' FROM '||p_table_name|| ' WHERE instance = '||''''||p_instance||'''';
1824:
1825: IF ( p_table_name = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) THEN
1826: l_str := l_str || ' and created_by_refresh_num = ' || p_new_refresh_num;
1827: END IF;
1828: EXECUTE IMMEDIATE l_str INTO l_min_date, l_max_date;
1829:

Line 1833: msd_common_utilities.get_db_link(p_instance, l_dblink, retcode);

1829:
1830: --fnd_file.put_line(fnd_file.log, l_min_date || ' ' || l_max_date );
1831:
1832: -- Get Database Link
1833: msd_common_utilities.get_db_link(p_instance, l_dblink, retcode);
1834:
1835: -- Get Master OrganizationID
1836: l_str := 'SELECT parameter_value FROM msd_setup_parameters'||
1837: l_dblink || ' WHERE parameter_name = '|| '''MSD_MASTER_ORG''';