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 565: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN

561:
562: v_instance_id := p_instance_id;
563: retcode :=0;
564:
565: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN
566: DELETE FROM msd_st_uom_conversions
567: WHERE instance = p_instance_id;
568:
569: v_sql_stmt := 'INSERT INTO ' || p_dest_table ||

Line 582: ELSIF p_dest_table = MSD_COMMON_UTILITIES.UOM_FACT_TABLE THEN

578: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
579: ' from ' || p_source_table || ' where 1 = 1';
580: --dbms_output.put_line(v_sql_stmt);
581: EXECUTE IMMEDIATE v_sql_stmt;
582: ELSIF p_dest_table = MSD_COMMON_UTILITIES.UOM_FACT_TABLE THEN
583: OPEN c_delete;
584: FETCH c_delete BULK COLLECT INTO a_from_uom_class, a_to_uom_class, a_from_uom_code,
585: a_to_uom_code, a_base_uom_flag, a_sr_item_pk;
586: CLOSE c_delete;

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

670: ' where 1 = 1';
671:
672: /* DWK. If dest_table is staging table, then we shouldn't delete
673: instance = '0' row */
674: IF (p_dest_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE) THEN
675: v_sql_stmt := v_sql_stmt || ' and nvl(instance, ''888'') <> '||'''0''';
676: END IF;
677:
678: v_date_range := v_date_range ||

Line 714: if p_source_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE then

710:
711: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
712: rows into fact table*/
713:
714: if p_source_table = MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE then
715: v_sql_stmt := v_sql_stmt || ' and nvl(instance, ''888'') <> '||'''0''';
716: else
717: if p_from_date is not null or p_to_date is not null then
718: v_sql_stmt := v_sql_stmt ||

Line 824: if p_source_table = MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE then

820:
821: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
822: rows into fact table*/
823:
824: if p_source_table = MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE then
825: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
826: end if;
827:
828: -- insert into msd_test values(v_sql_stmt) ;

Line 971: IF p_source_table = MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE then

967:
968: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
969: rows into fact table*/
970:
971: IF p_source_table = MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE then
972: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
973: END IF;
974:
975:

Line 1043: IF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE THEN

1039: fetch get_cs_id into x_cs_id;
1040: close get_cs_id;
1041:
1042: /* Check dest_table */
1043: IF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE THEN
1044: v_sql_stmt := ' DELETE FROM ' || p_dest_table ||
1045: ' where instance = ''' || p_instance_id || '''' ||
1046: ' and forecast_designator = nvl(:p_fcst_desg, forecast_designator) ' ;
1047:

Line 1085: ELSIF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE THEN

1081: 'to_char(sr_demand_class_pk) ' ||
1082: ' FROM ' || p_source_table ||
1083: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1084:
1085: ELSIF p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE THEN
1086:
1087: v_sql_stmt := ' UPDATE msd_mfg_forecast ' ||
1088: ' SET last_refresh_num = ' || p_new_refresh_num ||
1089: ', Action_code = ' || '''D''' ||

Line 1133: IF p_source_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE then

1129: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1130:
1131: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
1132: rows into fact table*/
1133: IF p_source_table = MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE then
1134: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
1135: END IF;
1136:
1137: END IF;

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

1137: END IF;
1138:
1139: EXECUTE IMMEDIATE v_sql_stmt USING p_fcst_desg ;
1140:
1141: if (p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) then
1142: INSERT INTO msd_cs_data_headers (
1143: CS_DATA_HEADER_ID,
1144: INSTANCE,
1145: CS_DEFINITION_ID,

Line 1212: IF p_dest_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE THEN

1208:
1209: retcode :=0;
1210:
1211: /* Check dest_table */
1212: IF p_dest_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE THEN
1213: v_sql_stmt := 'DELETE FROM ' || p_dest_table ||
1214: ' where instance = ''' || p_instance_id || '''' ||
1215: ' and price_list_name like nvl(:p_price_list, price_list_name) ';
1216: EXECUTE IMMEDIATE v_sql_stmt USING p_price_list;

Line 1251: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN

1247: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
1248: 'FROM ' || p_source_table || ' ' ||
1249: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1250:
1251: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN
1252: IF (p_price_list is not NULL) THEN
1253: UPDATE msd_price_list
1254: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1255: WHERE Action_code = 'I' and instance = p_instance_id and

Line 1298: IF p_source_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE then

1294: 'FROM ' || p_source_table || ' ' ||
1295: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1296: /* DWK. if the source is from staging table, then we shouldn't insert instance = '0'
1297: rows into fact table*/
1298: IF p_source_table = MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE then
1299: v_sql_stmt := v_sql_stmt || ' and nvl(instance,''888'') <> '||'''0''';
1300: END IF;
1301: END IF;
1302:

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

1747: /* Select min and max date for the forecast_date and rate_end_date. */
1748: l_str := 'SELECT min(forecast_date), max( nvl(rate_end_date, forecast_date))'||
1749: ' FROM '||p_table_name|| ' WHERE instance = '||''''||p_instance||'''';
1750:
1751: IF ( p_table_name = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) THEN
1752: l_str := l_str || ' and created_by_refresh_num = ' || p_new_refresh_num;
1753: END IF;
1754: EXECUTE IMMEDIATE l_str INTO l_min_date, l_max_date;
1755:

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

1755:
1756: --fnd_file.put_line(fnd_file.log, l_min_date || ' ' || l_max_date );
1757:
1758: -- Get Database Link
1759: msd_common_utilities.get_db_link(p_instance, l_dblink, retcode);
1760:
1761: -- Get Master OrganizationID
1762: l_str := 'SELECT parameter_value FROM msd_setup_parameters'||
1763: l_dblink || ' WHERE parameter_name = '|| '''MSD_MASTER_ORG''';