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.WMS_LMS_UTILS dependencies on FND_GLOBAL

Line 355: FND_GLOBAL.USER_ID,

351: travel_time,
352: transaction_time,
353: idle_time,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: FND_GLOBAL.USER_ID,
357: SYSDATE
358: FROM
359: (SELECT ELS_DATA_ID els_data_id,

Line 356: FND_GLOBAL.USER_ID,

352: transaction_time,
353: idle_time,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: FND_GLOBAL.USER_ID,
357: SYSDATE
358: FROM
359: (SELECT ELS_DATA_ID els_data_id,
360: organization_id,

Line 702: , FND_GLOBAL.USER_ID

698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED
702: , FND_GLOBAL.USER_ID
703: , FND_GLOBAL.LOGIN_ID
704: , FND_GLOBAL.USER_ID
705: , SYSDATE
706: , SYSDATE

Line 703: , FND_GLOBAL.LOGIN_ID

699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED
702: , FND_GLOBAL.USER_ID
703: , FND_GLOBAL.LOGIN_ID
704: , FND_GLOBAL.USER_ID
705: , SYSDATE
706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY

Line 704: , FND_GLOBAL.USER_ID

700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED
702: , FND_GLOBAL.USER_ID
703: , FND_GLOBAL.LOGIN_ID
704: , FND_GLOBAL.USER_ID
705: , SYSDATE
706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1

Line 739: , FND_GLOBAL.USER_ID

735: VALUES( l_new_els_data_id
736: , els_individual_tasks_tl_rec.language
737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID
741: , FND_GLOBAL.USER_ID
742: , SYSDATE
743: , SYSDATE);

Line 740: , FND_GLOBAL.LOGIN_ID

736: , els_individual_tasks_tl_rec.language
737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID
741: , FND_GLOBAL.USER_ID
742: , SYSDATE
743: , SYSDATE);
744: END LOOP;

Line 741: , FND_GLOBAL.USER_ID

737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID
741: , FND_GLOBAL.USER_ID
742: , SYSDATE
743: , SYSDATE);
744: END LOOP;
745: END LOOP;

Line 760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID, -- Added for bug # 5520074

756: Expected_Travel_Time = NVL(Actual_Travel_time,Expected_Travel_Time),
757: Expected_Txn_Time = NVL(Actual_Txn_Time,Expected_Txn_Time),
758: Expected_Idle_Time = NVL(Actual_Idle_Time,Expected_Idle_Time),
759: NUM_TRX_MATCHED = NULL, -- Added for bug # 5520074
760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID, -- Added for bug # 5520074
761: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, -- Added for bug # 5520074
762: LAST_UPDATE_DATE = SYSDATE -- Added for bug # 5520074
763: WHERE
764: organization_id= p_org_id

Line 761: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, -- Added for bug # 5520074

757: Expected_Txn_Time = NVL(Actual_Txn_Time,Expected_Txn_Time),
758: Expected_Idle_Time = NVL(Actual_Idle_Time,Expected_Idle_Time),
759: NUM_TRX_MATCHED = NULL, -- Added for bug # 5520074
760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID, -- Added for bug # 5520074
761: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, -- Added for bug # 5520074
762: LAST_UPDATE_DATE = SYSDATE -- Added for bug # 5520074
763: WHERE
764: organization_id= p_org_id
765: AND history_flag IS NULL;

Line 1734: , FND_GLOBAL.USER_ID

1730: , NULL
1731: , travel_and_idle_time
1732: , transaction_time
1733: , idle_time
1734: , FND_GLOBAL.USER_ID
1735: , sysdate
1736: , FND_GLOBAL.LOGIN_ID
1737: , FND_GLOBAL.USER_ID
1738: , sysdate

Line 1736: , FND_GLOBAL.LOGIN_ID

1732: , transaction_time
1733: , idle_time
1734: , FND_GLOBAL.USER_ID
1735: , sysdate
1736: , FND_GLOBAL.LOGIN_ID
1737: , FND_GLOBAL.USER_ID
1738: , sysdate
1739: FROM WMS_ELS_TRX_SRC
1740: WHERE ELS_DATA_ID IS NULL

Line 1737: , FND_GLOBAL.USER_ID

1733: , idle_time
1734: , FND_GLOBAL.USER_ID
1735: , sysdate
1736: , FND_GLOBAL.LOGIN_ID
1737: , FND_GLOBAL.USER_ID
1738: , sysdate
1739: FROM WMS_ELS_TRX_SRC
1740: WHERE ELS_DATA_ID IS NULL
1741: AND ELS_TRX_SRC_ID = l_els_trx_src_id

Line 1881: ' , FND_GLOBAL.USER_ID last_updated_by ' ||

1877: ' , task_range_from' ||
1878: ' , task_range_to' ||
1879: ' , exp_travel_time' ||
1880: ' , act_travel_Time' ||
1881: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
1882: ' , sysdate last_update_date' ||
1883: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
1884: ' , FND_GLOBAL.USER_ID created_by' ||
1885: ' , sysdate creation_date' ||

Line 1883: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||

1879: ' , exp_travel_time' ||
1880: ' , act_travel_Time' ||
1881: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
1882: ' , sysdate last_update_date' ||
1883: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
1884: ' , FND_GLOBAL.USER_ID created_by' ||
1885: ' , sysdate creation_date' ||
1886: ' FROM ' ||
1887: '( select organization_id' ||

Line 1884: ' , FND_GLOBAL.USER_ID created_by' ||

1880: ' , act_travel_Time' ||
1881: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
1882: ' , sysdate last_update_date' ||
1883: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
1884: ' , FND_GLOBAL.USER_ID created_by' ||
1885: ' , sysdate creation_date' ||
1886: ' FROM ' ||
1887: '( select organization_id' ||
1888: ' , activity_id' ||

Line 2130: || ' , FND_GLOBAL.USER_ID '

2126: || ' , NULL' --expected_idle_time
2127: || ' , travel_and_idle_time ' --actual_travel_time
2128: || ' , transaction_time ' --actual_txn_time
2129: || ' , idle_time ' --actual_idle_time
2130: || ' , FND_GLOBAL.USER_ID '
2131: || ' , sysdate '
2132: || ' , FND_GLOBAL.LOGIN_ID '
2133: || ' , FND_GLOBAL.USER_ID '
2134: || ' , sysdate '

Line 2132: || ' , FND_GLOBAL.LOGIN_ID '

2128: || ' , transaction_time ' --actual_txn_time
2129: || ' , idle_time ' --actual_idle_time
2130: || ' , FND_GLOBAL.USER_ID '
2131: || ' , sysdate '
2132: || ' , FND_GLOBAL.LOGIN_ID '
2133: || ' , FND_GLOBAL.USER_ID '
2134: || ' , sysdate '
2135: || ' FROM '
2136: || ' ( '

Line 2133: || ' , FND_GLOBAL.USER_ID '

2129: || ' , idle_time ' --actual_idle_time
2130: || ' , FND_GLOBAL.USER_ID '
2131: || ' , sysdate '
2132: || ' , FND_GLOBAL.LOGIN_ID '
2133: || ' , FND_GLOBAL.USER_ID '
2134: || ' , sysdate '
2135: || ' FROM '
2136: || ' ( '
2137: || ' SELECT '

Line 2246: || ' , FND_GLOBAL.USER_ID '

2242: || ' , NULL' --expected_idle_time
2243: || ' , travel_and_idle_time ' --actual_travel_time
2244: || ' , transaction_time ' --actual_txn_time
2245: || ' , idle_time ' --actual_idle_time
2246: || ' , FND_GLOBAL.USER_ID '
2247: || ' , sysdate '
2248: || ' , FND_GLOBAL.LOGIN_ID '
2249: || ' , FND_GLOBAL.USER_ID '
2250: || ' , sysdate '

Line 2248: || ' , FND_GLOBAL.LOGIN_ID '

2244: || ' , transaction_time ' --actual_txn_time
2245: || ' , idle_time ' --actual_idle_time
2246: || ' , FND_GLOBAL.USER_ID '
2247: || ' , sysdate '
2248: || ' , FND_GLOBAL.LOGIN_ID '
2249: || ' , FND_GLOBAL.USER_ID '
2250: || ' , sysdate '
2251: || ' FROM '
2252: || ' ( '

Line 2249: || ' , FND_GLOBAL.USER_ID '

2245: || ' , idle_time ' --actual_idle_time
2246: || ' , FND_GLOBAL.USER_ID '
2247: || ' , sysdate '
2248: || ' , FND_GLOBAL.LOGIN_ID '
2249: || ' , FND_GLOBAL.USER_ID '
2250: || ' , sysdate '
2251: || ' FROM '
2252: || ' ( '
2253: || ' SELECT '

Line 2364: || ' , FND_GLOBAL.USER_ID '

2360: || ' , NULL' --expected_idle_time
2361: || ' , travel_and_idle_time ' --actual_travel_time
2362: || ' , transaction_time ' --actual_txn_time
2363: || ' , idle_time ' --actual_idle_time
2364: || ' , FND_GLOBAL.USER_ID '
2365: || ' , sysdate '
2366: || ' , FND_GLOBAL.LOGIN_ID '
2367: || ' , FND_GLOBAL.USER_ID '
2368: || ' , sysdate '

Line 2366: || ' , FND_GLOBAL.LOGIN_ID '

2362: || ' , transaction_time ' --actual_txn_time
2363: || ' , idle_time ' --actual_idle_time
2364: || ' , FND_GLOBAL.USER_ID '
2365: || ' , sysdate '
2366: || ' , FND_GLOBAL.LOGIN_ID '
2367: || ' , FND_GLOBAL.USER_ID '
2368: || ' , sysdate '
2369: || ' FROM '
2370: || ' ( '

Line 2367: || ' , FND_GLOBAL.USER_ID '

2363: || ' , idle_time ' --actual_idle_time
2364: || ' , FND_GLOBAL.USER_ID '
2365: || ' , sysdate '
2366: || ' , FND_GLOBAL.LOGIN_ID '
2367: || ' , FND_GLOBAL.USER_ID '
2368: || ' , sysdate '
2369: || ' FROM '
2370: || ' ( '
2371: || ' SELECT '

Line 2556: ' , FND_GLOBAL.USER_ID last_updated_by ' ||

2552: ' , task_range_from' ||
2553: ' , task_range_to' ||
2554: ' , exp_travel_time' ||
2555: ' , act_travel_Time' ||
2556: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
2557: ' , sysdate last_update_date' ||
2558: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
2559: ' , FND_GLOBAL.USER_ID created_by' ||
2560: ' , sysdate creation_date' ||

Line 2558: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||

2554: ' , exp_travel_time' ||
2555: ' , act_travel_Time' ||
2556: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
2557: ' , sysdate last_update_date' ||
2558: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
2559: ' , FND_GLOBAL.USER_ID created_by' ||
2560: ' , sysdate creation_date' ||
2561: ' FROM ' ||
2562: '( select organization_id' ||

Line 2559: ' , FND_GLOBAL.USER_ID created_by' ||

2555: ' , act_travel_Time' ||
2556: ' , FND_GLOBAL.USER_ID last_updated_by ' ||
2557: ' , sysdate last_update_date' ||
2558: ' , FND_GLOBAL.LOGIN_ID last_update_login' ||
2559: ' , FND_GLOBAL.USER_ID created_by' ||
2560: ' , sysdate creation_date' ||
2561: ' FROM ' ||
2562: '( select organization_id' ||
2563: ' , activity_id' ||