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_LEVEL_VALUES dependencies on FND_GLOBAL

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

438: 'attribute4, ' ||
439: 'attribute5, ' ||
440: v_sql_stmt1 || --jarorad
441: 'sysdate, ' ||
442: FND_GLOBAL.USER_ID || ', ' ||
443: 'sysdate, ' ||
444: FND_GLOBAL.USER_ID || ' ' ||
445: 'from ' ||
446: p_source_table ;

Line 444: FND_GLOBAL.USER_ID || ' ' ||

440: v_sql_stmt1 || --jarorad
441: 'sysdate, ' ||
442: FND_GLOBAL.USER_ID || ', ' ||
443: 'sysdate, ' ||
444: FND_GLOBAL.USER_ID || ' ' ||
445: 'from ' ||
446: p_source_table ;
447:
448: /* Following filter causes a performance hit. We'll colect duplicates

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

480: p_level_value_pk_column||', ' ||
481: p_parent_level_id || ', ' ||
482: p_parent_value_pk_column ||', ' ||
483: 'sysdate, ' ||
484: FND_GLOBAL.USER_ID || ', ' ||
485: 'sysdate, ' ||
486: FND_GLOBAL.USER_ID || ' ' ||
487: 'from ' ||
488: p_source_table ;

Line 486: FND_GLOBAL.USER_ID || ' ' ||

482: p_parent_value_pk_column ||', ' ||
483: 'sysdate, ' ||
484: FND_GLOBAL.USER_ID || ', ' ||
485: 'sysdate, ' ||
486: FND_GLOBAL.USER_ID || ' ' ||
487: 'from ' ||
488: p_source_table ;
489:
490: if (v_view_exist = 1) then

Line 744: sysdate, FND_GLOBAL.USER_ID,

740: VALUES( p_instance_id, p_level_id, a_level_value(j),
741: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
742: a_level_value_desc(j),
743: 'I', p_seq_num, p_seq_num,
744: sysdate, FND_GLOBAL.USER_ID,
745: sysdate, FND_GLOBAL.USER_ID,
746: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
747: a_attribute3(j), a_attribute4(j), a_attribute5(j),
748: a_system_attribute1(j), a_system_attribute2(j), --jarorad

Line 745: sysdate, FND_GLOBAL.USER_ID,

741: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
742: a_level_value_desc(j),
743: 'I', p_seq_num, p_seq_num,
744: sysdate, FND_GLOBAL.USER_ID,
745: sysdate, FND_GLOBAL.USER_ID,
746: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
747: a_attribute3(j), a_attribute4(j), a_attribute5(j),
748: a_system_attribute1(j), a_system_attribute2(j), --jarorad
749: a_dp_enabled_flag(j) ); --jarorad

Line 746: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),

742: a_level_value_desc(j),
743: 'I', p_seq_num, p_seq_num,
744: sysdate, FND_GLOBAL.USER_ID,
745: sysdate, FND_GLOBAL.USER_ID,
746: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
747: a_attribute3(j), a_attribute4(j), a_attribute5(j),
748: a_system_attribute1(j), a_system_attribute2(j), --jarorad
749: a_dp_enabled_flag(j) ); --jarorad
750: END IF;

Line 851: sysdate, FND_GLOBAL.USER_ID, sysdate,

847: last_updated_by, last_update_login)
848: VALUES(p_instance_id, p_level_id,
849: a_sr_level_pk(j), a_level_pk(j),
850: a_crn(j) , p_seq_num,
851: sysdate, FND_GLOBAL.USER_ID, sysdate,
852: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
853:
854: /* VM - To be implemented
855: 1. We should mark data deleted from msd_cs_Data for deleted level

Line 852: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

848: VALUES(p_instance_id, p_level_id,
849: a_sr_level_pk(j), a_level_pk(j),
850: a_crn(j) , p_seq_num,
851: sysdate, FND_GLOBAL.USER_ID, sysdate,
852: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
853:
854: /* VM - To be implemented
855: 1. We should mark data deleted from msd_cs_Data for deleted level
856: values

Line 953: sysdate, FND_GLOBAL.USER_ID,

949: creation_date, created_by, last_update_login,
950: created_by_refresh_num, last_refresh_num, action_code)
951: VALUES(p_instance_id, p_level_id, a_sr_level_pk(i),
952: p_parent_level_id, a_sr_parent_level_pk(i),
953: sysdate, FND_GLOBAL.USER_ID,
954: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
955: p_seq_num, p_seq_num, 'I');
956: END IF;
957: END IF; /* End of New Association */

Line 954: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,

950: created_by_refresh_num, last_refresh_num, action_code)
951: VALUES(p_instance_id, p_level_id, a_sr_level_pk(i),
952: p_parent_level_id, a_sr_parent_level_pk(i),
953: sysdate, FND_GLOBAL.USER_ID,
954: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
955: p_seq_num, p_seq_num, 'I');
956: END IF;
957: END IF; /* End of New Association */
958:

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

1116: p_parent_value_column || ', ' ||
1117: p_parent_value_pk_column ||', ' ||
1118: p_parent_level_id || ', ' ||
1119: 'parent_desc_alias' ||', ' ||
1120: 'sysdate, ' || FND_GLOBAL.USER_ID || ', ' ||
1121: 'sysdate, ' || FND_GLOBAL.USER_ID || ' ' ||
1122: 'FROM ' ||
1123: '(select distinct ' || p_parent_value_column || ', ' ||
1124: p_parent_value_pk_column || ', ' ||

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

1117: p_parent_value_pk_column ||', ' ||
1118: p_parent_level_id || ', ' ||
1119: 'parent_desc_alias' ||', ' ||
1120: 'sysdate, ' || FND_GLOBAL.USER_ID || ', ' ||
1121: 'sysdate, ' || FND_GLOBAL.USER_ID || ' ' ||
1122: 'FROM ' ||
1123: '(select distinct ' || p_parent_value_column || ', ' ||
1124: p_parent_value_pk_column || ', ' ||
1125: p_parent_level_id || ', '||

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

1223: 'base_uom, ' ||
1224: 'item_type_id, ' ||
1225: 'forecast_type_id, ' ||
1226: 'sysdate, ' ||
1227: FND_GLOBAL.USER_ID || ', ' ||
1228: 'sysdate, ' ||
1229: FND_GLOBAL.USER_ID || ', ' ||
1230: FND_GLOBAL.USER_ID || ' ' ||
1231: 'FROM ' ||

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

1225: 'forecast_type_id, ' ||
1226: 'sysdate, ' ||
1227: FND_GLOBAL.USER_ID || ', ' ||
1228: 'sysdate, ' ||
1229: FND_GLOBAL.USER_ID || ', ' ||
1230: FND_GLOBAL.USER_ID || ' ' ||
1231: 'FROM ' ||
1232: ' msd_sr_item_list_price_v' || x_dblink ||
1233: ' where sr_item_pk in (select to_number(decode(ltrim(sr_level_pk, ''.0123456789''),' ||

Line 1230: FND_GLOBAL.USER_ID || ' ' ||

1226: 'sysdate, ' ||
1227: FND_GLOBAL.USER_ID || ', ' ||
1228: 'sysdate, ' ||
1229: FND_GLOBAL.USER_ID || ', ' ||
1230: FND_GLOBAL.USER_ID || ' ' ||
1231: 'FROM ' ||
1232: ' msd_sr_item_list_price_v' || x_dblink ||
1233: ' where sr_item_pk in (select to_number(decode(ltrim(sr_level_pk, ''.0123456789''),' ||
1234: ' null, sr_level_pk, null)) ' ||

Line 1297: sysdate, FND_GLOBAL.USER_ID, sysdate,

1293: INSERT INTO msd_deleted_item_list_price(instance, sr_item_pk, created_by_refresh_num,
1294: creation_date, created_by, last_update_date,
1295: last_updated_by, last_update_login)
1296: VALUES(p_instance_id, a_sr_item_pk(j), p_seq_num,
1297: sysdate, FND_GLOBAL.USER_ID, sysdate,
1298: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
1299: */
1300: END IF;
1301:

Line 1298: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

1294: creation_date, created_by, last_update_date,
1295: last_updated_by, last_update_login)
1296: VALUES(p_instance_id, a_sr_item_pk(j), p_seq_num,
1297: sysdate, FND_GLOBAL.USER_ID, sysdate,
1298: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
1299: */
1300: END IF;
1301:
1302: EXCEPTION

Line 1374: sysdate, FND_GLOBAL.USER_ID,

1370: rec_st_rows.avg_discount, rec_st_rows.base_uom,
1371: rec_st_rows.sr_item_pk, rec_st_rows.item_type_id,
1372: rec_st_rows.forecast_type_id,
1373: 'I', p_seq_num, p_seq_num,
1374: sysdate, FND_GLOBAL.USER_ID,
1375: sysdate, FND_GLOBAL.USER_ID,
1376: FND_GLOBAL.LOGIN_ID);
1377:
1378: ELSE

Line 1375: sysdate, FND_GLOBAL.USER_ID,

1371: rec_st_rows.sr_item_pk, rec_st_rows.item_type_id,
1372: rec_st_rows.forecast_type_id,
1373: 'I', p_seq_num, p_seq_num,
1374: sysdate, FND_GLOBAL.USER_ID,
1375: sysdate, FND_GLOBAL.USER_ID,
1376: FND_GLOBAL.LOGIN_ID);
1377:
1378: ELSE
1379:

Line 1376: FND_GLOBAL.LOGIN_ID);

1372: rec_st_rows.forecast_type_id,
1373: 'I', p_seq_num, p_seq_num,
1374: sysdate, FND_GLOBAL.USER_ID,
1375: sysdate, FND_GLOBAL.USER_ID,
1376: FND_GLOBAL.LOGIN_ID);
1377:
1378: ELSE
1379:
1380: /* If this row exists in the fact then check row has been

Line 1549: fnd_global.user_id,

1545: a.sr_org_pk,
1546: a.calendar_type,
1547: a.calendar_code,
1548: sysdate,
1549: fnd_global.user_id,
1550: sysdate,
1551: fnd_global.user_id
1552: from
1553: (select distinct

Line 1551: fnd_global.user_id

1547: a.calendar_code,
1548: sysdate,
1549: fnd_global.user_id,
1550: sysdate,
1551: fnd_global.user_id
1552: from
1553: (select distinct
1554: instance,
1555: sr_org_pk,

Line 1575: fnd_global.user_id || ', ' ||

1571: ' mod.organization_id' || ', ' ||
1572: '''' || p_man_cal_type || '''' || ', ' ||
1573: ' mod.calendar_code' || ', ' ||
1574: ' sysdate' || ', ' ||
1575: fnd_global.user_id || ', ' ||
1576: ' sysdate' || ', ' ||
1577: fnd_global.user_id || ' ' ||
1578: ' From MSD_ORGANIZATION_DEFINITIONS' || x_dblink || ' MOD';
1579: v_stmt := v_stmt || ' where exists (select 1 from msd_app_instance_orgs' || x_dblink || ' maio where MOD.organization_id = MAIO.organization_id)';

Line 1577: fnd_global.user_id || ' ' ||

1573: ' mod.calendar_code' || ', ' ||
1574: ' sysdate' || ', ' ||
1575: fnd_global.user_id || ', ' ||
1576: ' sysdate' || ', ' ||
1577: fnd_global.user_id || ' ' ||
1578: ' From MSD_ORGANIZATION_DEFINITIONS' || x_dblink || ' MOD';
1579: v_stmt := v_stmt || ' where exists (select 1 from msd_app_instance_orgs' || x_dblink || ' maio where MOD.organization_id = MAIO.organization_id)';
1580:
1581: execute immediate v_stmt;

Line 1705: fnd_global.user_id,

1701: a.sr_level_pk,
1702: a.org_level_id,
1703: a.org_sr_level_pk,
1704: sysdate,
1705: fnd_global.user_id,
1706: sysdate,
1707: fnd_global.user_id
1708: from
1709: (select distinct

Line 1707: fnd_global.user_id

1703: a.org_sr_level_pk,
1704: sysdate,
1705: fnd_global.user_id,
1706: sysdate,
1707: fnd_global.user_id
1708: from
1709: (select distinct
1710: instance,
1711: level_id,

Line 1735: fnd_global.user_id || ', ' ||

1731: ' src.level_value_pk ' || ', ' ||
1732: ' src.org_level_id ' || ', ' ||
1733: ' src.org_level_value_pk ' || ', ' ||
1734: ' sysdate ' || ', ' ||
1735: fnd_global.user_id || ', ' ||
1736: ' sysdate ' || ', ' ||
1737: fnd_global.user_id || ' ' ||
1738: ' From ' || p_org_relationship_view || x_dblink || ' src';
1739:

Line 1737: fnd_global.user_id || ' ' ||

1733: ' src.org_level_value_pk ' || ', ' ||
1734: ' sysdate ' || ', ' ||
1735: fnd_global.user_id || ', ' ||
1736: ' sysdate ' || ', ' ||
1737: fnd_global.user_id || ' ' ||
1738: ' From ' || p_org_relationship_view || x_dblink || ' src';
1739:
1740: execute immediate v_stmt;
1741:

Line 1796: fnd_global.user_id,

1792: null,
1793: null,
1794: p_seq_num,
1795: sysdate,
1796: fnd_global.user_id,
1797: sysdate,
1798: fnd_global.user_id
1799: );
1800:

Line 1798: fnd_global.user_id

1794: p_seq_num,
1795: sysdate,
1796: fnd_global.user_id,
1797: sysdate,
1798: fnd_global.user_id
1799: );
1800:
1801: END;
1802: