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 582: ' CONVERSION_RATE, sysdate, '|| FND_GLOBAL.USER_ID ||

578: ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )'||
579: ' SELECT ' || NVL(v_instance_id, 'INSTANCE') || ', ' ||
580: ' decode(SR_ITEM_PK, ''0'', null, SR_ITEM_PK), ITEM, FROM_UOM_CLASS, TO_UOM_CLASS, ' ||
581: ' FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG, ' ||
582: ' CONVERSION_RATE, sysdate, '|| FND_GLOBAL.USER_ID ||
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;

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

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

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

620: last_refresh_num, created_by_refresh_num, action_code)
621: VALUES ( p_instance_id, a_sr_item_pk(i), a_item(i),
622: a_from_uom_class(i), a_to_uom_class(i),
623: a_from_uom_code(i), a_to_uom_code(i), a_base_uom_flag(i),
624: a_conversion_rate(i), sysdate, FND_GLOBAL.USER_ID,
625: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
626: p_new_refresh_num, p_new_refresh_num, 'I');
627: END IF;
628:

Line 625: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

621: VALUES ( p_instance_id, a_sr_item_pk(i), a_item(i),
622: a_from_uom_class(i), a_to_uom_class(i),
623: a_from_uom_code(i), a_to_uom_code(i), a_base_uom_flag(i),
624: a_conversion_rate(i), sysdate, FND_GLOBAL.USER_ID,
625: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
626: p_new_refresh_num, p_new_refresh_num, 'I');
627: END IF;
628:
629: */

Line 682: ' FND_GLOBAL.USER_ID, '||

678: ' msuc.TO_UOM_CODE, '||
679: ' msuc.BASE_UOM_FLAG, '||
680: ' msuc.CONVERSION_RATE, '||
681: ' sysdate, '||
682: ' FND_GLOBAL.USER_ID, '||
683: ' sysdate, '||
684: ' FND_GLOBAL.USER_ID, '||
685: ' FND_GLOBAL.USER_ID, '||
686: p_new_refresh_num ||','||

Line 684: ' FND_GLOBAL.USER_ID, '||

680: ' msuc.CONVERSION_RATE, '||
681: ' sysdate, '||
682: ' FND_GLOBAL.USER_ID, '||
683: ' sysdate, '||
684: ' FND_GLOBAL.USER_ID, '||
685: ' FND_GLOBAL.USER_ID, '||
686: p_new_refresh_num ||','||
687: p_new_refresh_num ||','||
688: '''I'''|| ' )' ;

Line 685: ' FND_GLOBAL.USER_ID, '||

681: ' sysdate, '||
682: ' FND_GLOBAL.USER_ID, '||
683: ' sysdate, '||
684: ' FND_GLOBAL.USER_ID, '||
685: ' FND_GLOBAL.USER_ID, '||
686: p_new_refresh_num ||','||
687: p_new_refresh_num ||','||
688: '''I'''|| ' )' ;
689:

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

770: ' LAST_UPDATED_BY, LAST_UPDATE_LOGIN )'||
771: ' SELECT ' ||
772: ' FROM_CURRENCY, TO_CURRENCY, ' ||
773: ' CONVERSION_DATE, CONVERSION_RATE, ' ||
774: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
775: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
776: 'from ' || p_source_table || ' where 1 = 1';
777:
778: v_sql_stmt := v_sql_stmt || v_date_range;

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

771: ' SELECT ' ||
772: ' FROM_CURRENCY, TO_CURRENCY, ' ||
773: ' CONVERSION_DATE, CONVERSION_RATE, ' ||
774: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
775: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
776: 'from ' || p_source_table || ' where 1 = 1';
777:
778: v_sql_stmt := v_sql_stmt || v_date_range;
779:

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

885: 'nvl(sr_sales_rep_pk, msd_sr_util.get_null_pk), ' ||
886: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
887: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
888: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
889: ' status, sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
890: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
891: 'from ' || p_source_table || ' where 1 = 1';
892:
893: v_sql_stmt := v_sql_stmt || v_date_range;

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

886: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
887: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
888: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
889: ' status, sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
890: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
891: 'from ' || p_source_table || ' where 1 = 1';
892:
893: v_sql_stmt := v_sql_stmt || v_date_range;
894:

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

1009: 'nvl(sr_sales_rep_pk, msd_sr_util.get_null_pk), ' ||
1010: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1011: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1012: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1013: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1014: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
1015: ' from ' || p_source_table || ' where 1 = 1';
1016:
1017:

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

1010: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1011: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1012: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1013: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1014: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||' ' ||
1015: ' from ' || p_source_table || ' where 1 = 1';
1016:
1017:
1018: if p_from_date is not null and p_to_date is not null then

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

1149: 'nvl(sr_sales_channel_pk, msd_sr_util.get_null_pk), '||
1150: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1151: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1152: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1153: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1154: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1155: 'to_char(sr_demand_class_pk) ' ||
1156: ' FROM ' || p_source_table ||
1157: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';

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

1150: 'nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1151: 'nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1152: 'nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1153: ' sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1154: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1155: 'to_char(sr_demand_class_pk) ' ||
1156: ' FROM ' || p_source_table ||
1157: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1158:

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

1195: ' nvl(sr_ship_to_loc_pk, msd_sr_util.get_null_pk), ' ||
1196: ' nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1197: ' nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1198: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
1199: ', sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1200: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1201: ' to_char(sr_demand_class_pk) ' ||
1202: ' FROM ' || p_source_table ||
1203: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';

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

1196: ' nvl(sr_user_defined1_pk, msd_sr_util.get_null_pk), ' ||
1197: ' nvl(sr_user_defined2_pk, msd_sr_util.get_null_pk), '||
1198: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' ||
1199: ', sysdate, '|| FND_GLOBAL.USER_ID || ', sysdate, ' ||
1200: FND_GLOBAL.USER_ID ||', '|| FND_GLOBAL.USER_ID ||', ' ||
1201: ' to_char(sr_demand_class_pk) ' ||
1202: ' FROM ' || p_source_table ||
1203: ' WHERE forecast_designator = nvl(:p_fcst_desg, forecast_designator) ';
1204:

Line 1233: fnd_global.user_id,

1229: p_instance_id,
1230: x_cs_id,
1231: p_fcst_desg,
1232: sysdate,
1233: fnd_global.user_id,
1234: sysdate,
1235: fnd_global.user_id,
1236: fnd_global.login_id,
1237: p_new_refresh_num

Line 1235: fnd_global.user_id,

1231: p_fcst_desg,
1232: sysdate,
1233: fnd_global.user_id,
1234: sysdate,
1235: fnd_global.user_id,
1236: fnd_global.login_id,
1237: p_new_refresh_num
1238: );
1239: end if;

Line 1236: fnd_global.login_id,

1232: sysdate,
1233: fnd_global.user_id,
1234: sysdate,
1235: fnd_global.user_id,
1236: fnd_global.login_id,
1237: p_new_refresh_num
1238: );
1239: end if;
1240:

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

1316: ' nvl(DEMAND_CLASS_LVL_ID, 40), nvl(SR_DEMAND_CLASS_LVL_PK,msd_sr_util.get_null_pk),' ||
1317: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1318: ' PRICE, PRIORITY, ' ||
1319: ' PRIMARY_UOM_FLAG, PRICE_LIST_UOM, ' ||
1320: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
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:

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

1317: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1318: ' PRICE, PRIORITY, ' ||
1319: ' PRIMARY_UOM_FLAG, PRICE_LIST_UOM, ' ||
1320: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
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

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

1362: ' nvl(DEMAND_CLASS_LVL_ID, 40) , nvl(SR_DEMAND_CLASS_LVL_PK,msd_sr_util.get_all_geo_pk), ' ||
1363: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1364: ' PRICE, PRIORITY, ' ||
1365: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' || ', ' ||
1366: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
1367: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
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'

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

1363: ' PRICE_LIST_NAME, START_DATE, END_DATE, ' ||
1364: ' PRICE, PRIORITY, ' ||
1365: p_new_refresh_num || ', ' || p_new_refresh_num || ', '|| '''I''' || ', ' ||
1366: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', ' ||
1367: ' SYSDATE,'|| FND_GLOBAL.USER_ID || ', '|| FND_GLOBAL.USER_ID ||' '||
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*/

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

1598: sr_demand_class_pk,
1599: created_by_refresh_num, last_refresh_num, action_code)
1600: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1601: t.day, NULL, a_original_quantity(i),
1602: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1603: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1604: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1605: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1606: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

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

1599: created_by_refresh_num, last_refresh_num, action_code)
1600: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1601: t.day, NULL, a_original_quantity(i),
1602: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1603: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1604: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1605: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1606: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1607: a_sr_demand_class_pk(i),

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

1657: sr_demand_class_pk,
1658: created_by_refresh_num, last_refresh_num, action_code)
1659: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1660: t.week_end_date, NULL, a_original_quantity(i),
1661: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1662: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1663: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1664: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1665: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

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

1658: created_by_refresh_num, last_refresh_num, action_code)
1659: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1660: t.week_end_date, NULL, a_original_quantity(i),
1661: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1662: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1663: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1664: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1665: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1666: a_sr_demand_class_pk(i),

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

1716: sr_demand_class_pk,
1717: created_by_refresh_num, last_refresh_num, action_code)
1718: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1719: t.month_end_date, NULL, a_original_quantity(i),
1720: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1721: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1722: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1723: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1724: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),

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

1717: created_by_refresh_num, last_refresh_num, action_code)
1718: SELECT p_instance, a_forecast_designator(i), a_bucket_type(i),
1719: t.month_end_date, NULL, a_original_quantity(i),
1720: a_current_quantity(i), SYSDATE, FND_GLOBAL.USER_ID,
1721: SYSDATE, FND_GLOBAL.USER_ID, fnd_global.login_id,
1722: a_sr_inv_org_pk(i), a_prd_level_id(i), a_sr_item_pk(i), a_sr_customer_pk(i),
1723: a_sr_sales_channel_pk(i), a_sr_ship_to_loc_pk(i),
1724: a_sr_user_defined1_pk(i), a_sr_user_defined2_pk(i),
1725: a_sr_demand_class_pk(i),

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

1777: last_updated_by, creation_date, created_by,
1778: last_update_login)
1779: SELECT ' || '''-999''' || ', calendar_code, 1,
1780: seq_num, month_start_date,month_end_date, week_start_date, week_end_date, day,
1781: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID
1782: FROM msd_sr_mfg_time_v' || p_dblink ||
1783: ' WHERE seq_num <> -1 and calendar_code = :p_cal_code '||
1784: ' AND day BETWEEN :p_min_date AND :p_max_date ';
1785:

Line 2032: fnd_global.user_id,

2028: p_instance,
2029: x_cs_id,
2030: 'SINGLE_STREAM',
2031: sysdate,
2032: fnd_global.user_id,
2033: sysdate,
2034: fnd_global.user_id,
2035: fnd_global.login_id,
2036: p_ref_num from dual;

Line 2034: fnd_global.user_id,

2030: 'SINGLE_STREAM',
2031: sysdate,
2032: fnd_global.user_id,
2033: sysdate,
2034: fnd_global.user_id,
2035: fnd_global.login_id,
2036: p_ref_num from dual;
2037:
2038: end if;

Line 2035: fnd_global.login_id,

2031: sysdate,
2032: fnd_global.user_id,
2033: sysdate,
2034: fnd_global.user_id,
2035: fnd_global.login_id,
2036: p_ref_num from dual;
2037:
2038: end if;
2039: