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 FND_GLOBAL

Line 136: 'qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||

132: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
133: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
134: 'booked_date,'||
135: 'requested_date, promised_date, shipped_date, scheduled_ship_date, scheduled_arrival_date, amount, '||
136: 'qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||
137: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||
138: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
139: ', ORDER_SOURCE_ID ' ||
140: 'FROM ' || p_source_table ||' where 1 = 1';

Line 137: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||

133: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
134: 'booked_date,'||
135: 'requested_date, promised_date, shipped_date, scheduled_ship_date, scheduled_arrival_date, amount, '||
136: 'qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||
137: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||
138: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
139: ', ORDER_SOURCE_ID ' ||
140: 'FROM ' || p_source_table ||' where 1 = 1';
141:

Line 194: 'amount, qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||

190: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
191: 'booked_date,'||
192: 'requested_date, promised_date, shipped_date, ' ||
193: 'scheduled_ship_date, scheduled_arrival_date, ' ||
194: 'amount, qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||
195: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||
196: ', '|| p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
197: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
198: ', ORDER_SOURCE_ID ' ||

Line 195: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||

191: 'booked_date,'||
192: 'requested_date, promised_date, shipped_date, ' ||
193: 'scheduled_ship_date, scheduled_arrival_date, ' ||
194: 'amount, qty_shipped, sysdate, '|| FND_GLOBAL.USER_ID ||
195: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||
196: ', '|| p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
197: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
198: ', ORDER_SOURCE_ID ' ||
199: 'FROM ' || p_source_table ||' where 1 = 1';

Line 366: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||

362: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
363: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
364: 'booked_date,'||
365: 'requested_date, promised_date, scheduled_ship_date, scheduled_arrival_date , '||
366: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||
367: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||
368: ', to_char(sr_original_item_pk), ' ||
369: ' to_char(sr_parent_item_pk), to_char(sr_demand_class_pk), ORDER_SOURCE_ID ' ||
370: 'from ' || p_source_table ||' where 1 = 1';

Line 367: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||

363: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
364: 'booked_date,'||
365: 'requested_date, promised_date, scheduled_ship_date, scheduled_arrival_date , '||
366: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||
367: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||
368: ', to_char(sr_original_item_pk), ' ||
369: ' to_char(sr_parent_item_pk), to_char(sr_demand_class_pk), ORDER_SOURCE_ID ' ||
370: 'from ' || p_source_table ||' where 1 = 1';
371:

Line 422: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||

418: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
419: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
420: 'booked_date,'||
421: 'requested_date, promised_date, scheduled_date, scheduled_arrival_date, '||
422: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||
423: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||
424: ', '|| p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
425: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
426: ', ORDER_SOURCE_ID ' ||

Line 423: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||

419: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
420: 'booked_date,'||
421: 'requested_date, promised_date, scheduled_date, scheduled_arrival_date, '||
422: 'amount, qty_ordered, sysdate, '|| FND_GLOBAL.USER_ID ||
423: ', sysdate, '|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||
424: ', '|| p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
425: ', to_char(sr_original_item_pk), to_char(sr_parent_item_pk), to_char(sr_demand_class_pk) ' ||
426: ', ORDER_SOURCE_ID ' ||
427: 'from ' || p_source_table ||' where 1 = 1';

Line 577: ' CONVERSION_RATE, sysdate, '|| FND_GLOBAL.USER_ID ||

573: ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )'||
574: ' SELECT ' || NVL(v_instance_id, 'INSTANCE') || ', ' ||
575: ' decode(SR_ITEM_PK, ''0'', null, SR_ITEM_PK), ITEM, FROM_UOM_CLASS, TO_UOM_CLASS, ' ||
576: ' FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG, ' ||
577: ' CONVERSION_RATE, sysdate, '|| FND_GLOBAL.USER_ID ||
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;

Line 578: ', sysdate, '|| FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||

574: ' SELECT ' || NVL(v_instance_id, 'INSTANCE') || ', ' ||
575: ' decode(SR_ITEM_PK, ''0'', null, SR_ITEM_PK), ITEM, FROM_UOM_CLASS, TO_UOM_CLASS, ' ||
576: ' FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG, ' ||
577: ' CONVERSION_RATE, sysdate, '|| FND_GLOBAL.USER_ID ||
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

Line 616: a_conversion_rate(i), sysdate, FND_GLOBAL.USER_ID,

612: last_refresh_num, created_by_refresh_num, action_code)
613: VALUES ( p_instance_id, a_sr_item_pk(i), a_item(i),
614: a_from_uom_class(i), a_to_uom_class(i),
615: a_from_uom_code(i), a_to_uom_code(i), a_base_uom_flag(i),
616: a_conversion_rate(i), sysdate, FND_GLOBAL.USER_ID,
617: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
618: p_new_refresh_num, p_new_refresh_num, 'I');
619: END IF;
620: END IF; /* End of ELSIF */

Line 617: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

613: VALUES ( p_instance_id, a_sr_item_pk(i), a_item(i),
614: a_from_uom_class(i), a_to_uom_class(i),
615: a_from_uom_code(i), a_to_uom_code(i), a_base_uom_flag(i),
616: a_conversion_rate(i), sysdate, FND_GLOBAL.USER_ID,
617: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
618: p_new_refresh_num, p_new_refresh_num, 'I');
619: END IF;
620: END IF; /* End of ELSIF */
621: retcode := 0;

Line 700: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||

696: ' LAST_UPDATED_BY, LAST_UPDATE_LOGIN )'||
697: ' SELECT ' ||
698: ' FROM_CURRENCY, TO_CURRENCY, ' ||
699: ' CONVERSION_DATE, CONVERSION_RATE, ' ||
700: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
701: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
702: 'from ' || p_source_table || ' where 1 = 1';
703:
704: v_sql_stmt := v_sql_stmt || v_date_range;

Line 701: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||

697: ' SELECT ' ||
698: ' FROM_CURRENCY, TO_CURRENCY, ' ||
699: ' CONVERSION_DATE, CONVERSION_RATE, ' ||
700: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
701: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
702: 'from ' || p_source_table || ' where 1 = 1';
703:
704: v_sql_stmt := v_sql_stmt || v_date_range;
705:

Line 815: ' status, sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||

811: 'nvl(sr_sales_rep_pk, msd_sr_util.get_null_pk), ' ||
812: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
813: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
814: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
815: ' status, sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
816: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
817: 'from ' || p_source_table || ' where 1 = 1';
818:
819: v_sql_stmt := v_sql_stmt || v_date_range;

Line 816: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||

812: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
813: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
814: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
815: ' status, sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
816: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
817: 'from ' || p_source_table || ' where 1 = 1';
818:
819: v_sql_stmt := v_sql_stmt || v_date_range;
820:

Line 939: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||

935: 'nvl(sr_sales_rep_pk, msd_sr_util.get_null_pk), ' ||
936: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
937: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
938: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
939: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
940: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
941: ' from ' || p_source_table || ' where 1 = 1';
942:
943:

Line 940: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||

936: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
937: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
938: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
939: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
940: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
941: ' from ' || p_source_table || ' where 1 = 1';
942:
943:
944: if p_from_date is not null and p_to_date is not null then

Line 1079: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||

1075: 'nvl(sr_sales_channel_pk, msd_sr_util.get_null_pk), '||
1076: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1077: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1078: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1079: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1080: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1081: 'to_char(sr_demand_class_pk) ' ||
1082: ' FROM ' || p_source_table ||
1083: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';

Line 1080: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||

1076: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1077: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1078: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1079: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1080: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1081: 'to_char(sr_demand_class_pk) ' ||
1082: ' FROM ' || p_source_table ||
1083: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1084:

Line 1125: ', sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||

1121: ' nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1122: ' nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1123: ' nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1124: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
1125: ', sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1126: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1127: ' to_char(sr_demand_class_pk) ' ||
1128: ' FROM ' || p_source_table ||
1129: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';

Line 1126: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||

1122: ' nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1123: ' nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1124: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
1125: ', sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1126: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1127: ' to_char(sr_demand_class_pk) ' ||
1128: ' FROM ' || p_source_table ||
1129: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1130:

Line 1159: fnd_global.user_id,

1155: p_instance_id,
1156: x_cs_id,
1157: p_fcst_desg,
1158: sysdate,
1159: fnd_global.user_id,
1160: sysdate,
1161: fnd_global.user_id,
1162: fnd_global.login_id,
1163: p_new_refresh_num

Line 1161: fnd_global.user_id,

1157: p_fcst_desg,
1158: sysdate,
1159: fnd_global.user_id,
1160: sysdate,
1161: fnd_global.user_id,
1162: fnd_global.login_id,
1163: p_new_refresh_num
1164: );
1165: end if;

Line 1162: fnd_global.login_id,

1158: sysdate,
1159: fnd_global.user_id,
1160: sysdate,
1161: fnd_global.user_id,
1162: fnd_global.login_id,
1163: p_new_refresh_num
1164: );
1165: end if;
1166:

Line 1246: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||

1242: ' nvl(DEMAND_CLASS_LVL_ID, 40), nvl(SR_DEMAND_CLASS_LVL_PK,msd_sr_util.get_null_pk),' ||
1243: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1244: ' PRICE, PRIORITY, ' ||
1245: ' PRIMARY_UOM_FLAG, PRICE_LIST_UOM, ' ||
1246: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
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:

Line 1247: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||

1243: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1244: ' PRICE, PRIORITY, ' ||
1245: ' PRIMARY_UOM_FLAG, PRICE_LIST_UOM, ' ||
1246: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
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

Line 1292: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||

1288: ' nvl(DEMAND_CLASS_LVL_ID, 40) , nvl(SR_DEMAND_CLASS_LVL_PK,msd_sr_util.get_all_geo_pk), ' ||
1289: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1290: ' PRICE, PRIORITY, ' ||
1291: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' || ', ' ||
1292: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
1293: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
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'

Line 1293: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||

1289: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1290: ' PRICE, PRIORITY, ' ||
1291: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' || ', ' ||
1292: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
1293: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
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*/

Line 1528: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,

1524: sr_demand_class_pk,
1525: created_by_refresh_num, last_refresh_num, action_code)
1526: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1527: t.day, NULL, a_original_quantity(i),
1528: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1529: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1530: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1531: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1532: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

Line 1529: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,

1525: created_by_refresh_num, last_refresh_num, action_code)
1526: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1527: t.day, NULL, a_original_quantity(i),
1528: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1529: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1530: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1531: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1532: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1533: a_sr_demand_class_pk(i),

Line 1587: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,

1583: sr_demand_class_pk,
1584: created_by_refresh_num, last_refresh_num, action_code)
1585: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1586: t.week_end_date, NULL, a_original_quantity(i),
1587: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1588: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1589: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1590: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1591: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

Line 1588: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,

1584: created_by_refresh_num, last_refresh_num, action_code)
1585: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1586: t.week_end_date, NULL, a_original_quantity(i),
1587: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1588: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1589: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1590: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1591: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1592: a_sr_demand_class_pk(i),

Line 1646: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,

1642: sr_demand_class_pk,
1643: created_by_refresh_num, last_refresh_num, action_code)
1644: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1645: t.month_end_date, NULL, a_original_quantity(i),
1646: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1647: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1648: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1649: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1650: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

Line 1647: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,

1643: created_by_refresh_num, last_refresh_num, action_code)
1644: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1645: t.month_end_date, NULL, a_original_quantity(i),
1646: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1647: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1648: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1649: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1650: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1651: a_sr_demand_class_pk(i),

Line 1707: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID

1703: last_updated_by, creation_date, created_by,
1704: last_update_login)
1705: SELECT ' || '''-999''' || ', calendar_code, 1,
1706: seq_num, month_start_date,month_end_date, week_start_date, week_end_date, day,
1707: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID
1708: FROM msd_sr_mfg_time_v' || p_dblink ||
1709: ' WHERE seq_num <> -1 and calendar_code = :p_cal_code '||
1710: ' AND day BETWEEN :p_min_date AND :p_max_date ';
1711:

Line 1922: fnd_global.user_id,

1918: p_instance,
1919: x_cs_id,
1920: 'SINGLE_STREAM',
1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id,
1926: p_ref_num from dual;

Line 1924: fnd_global.user_id,

1920: 'SINGLE_STREAM',
1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id,
1926: p_ref_num from dual;
1927:
1928: end if;

Line 1925: fnd_global.login_id,

1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id,
1926: p_ref_num from dual;
1927:
1928: end if;
1929: