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

Line 129: FND_GLOBAL.USER_ID,

125: 'SHIPMENT',shipment_line_id
126: ),
127: 1, --manual and user directed
128: receipt_date,
129: FND_GLOBAL.USER_ID,
130: SYSDATE,
131: FND_GLOBAL.LOGIN_ID,
132: FND_GLOBAL.USER_ID,
133: SYSDATE

Line 131: FND_GLOBAL.LOGIN_ID,

127: 1, --manual and user directed
128: receipt_date,
129: FND_GLOBAL.USER_ID,
130: SYSDATE,
131: FND_GLOBAL.LOGIN_ID,
132: FND_GLOBAL.USER_ID,
133: SYSDATE
134: from mtl_supply ms,
135: wms_els_parameters wep,

Line 132: FND_GLOBAL.USER_ID,

128: receipt_date,
129: FND_GLOBAL.USER_ID,
130: SYSDATE,
131: FND_GLOBAL.LOGIN_ID,
132: FND_GLOBAL.USER_ID,
133: SYSDATE
134: from mtl_supply ms,
135: wms_els_parameters wep,
136: mtl_units_of_measure_vl mum

Line 212: FND_GLOBAL.USER_ID,

208: header_id,
209: line_id,
210: 1, -- Manual and user directed
211: promise_date,
212: FND_GLOBAL.USER_ID,
213: SYSDATE,
214: FND_GLOBAL.LOGIN_ID,
215: FND_GLOBAL.USER_ID,
216: SYSDATE

Line 214: FND_GLOBAL.LOGIN_ID,

210: 1, -- Manual and user directed
211: promise_date,
212: FND_GLOBAL.USER_ID,
213: SYSDATE,
214: FND_GLOBAL.LOGIN_ID,
215: FND_GLOBAL.USER_ID,
216: SYSDATE
217: from oe_order_lines_all,
218: wms_els_parameters wep

Line 215: FND_GLOBAL.USER_ID,

211: promise_date,
212: FND_GLOBAL.USER_ID,
213: SYSDATE,
214: FND_GLOBAL.LOGIN_ID,
215: FND_GLOBAL.USER_ID,
216: SYSDATE
217: from oe_order_lines_all,
218: wms_els_parameters wep
219: where line_category_code like 'RETURN'

Line 294: FND_GLOBAL.USER_ID,

290: transaction_header_id,
291: transaction_temp_id,
292: 1, --manual and user directed
293: operation_plan_id,
294: FND_GLOBAL.USER_ID,
295: SYSDATE,
296: FND_GLOBAL.LOGIN_ID,
297: FND_GLOBAL.USER_ID,
298: SYSDATE

Line 296: FND_GLOBAL.LOGIN_ID,

292: 1, --manual and user directed
293: operation_plan_id,
294: FND_GLOBAL.USER_ID,
295: SYSDATE,
296: FND_GLOBAL.LOGIN_ID,
297: FND_GLOBAL.USER_ID,
298: SYSDATE
299: from
300: mtl_material_transactions_temp

Line 297: FND_GLOBAL.USER_ID,

293: operation_plan_id,
294: FND_GLOBAL.USER_ID,
295: SYSDATE,
296: FND_GLOBAL.LOGIN_ID,
297: FND_GLOBAL.USER_ID,
298: SYSDATE
299: from
300: mtl_material_transactions_temp
301: where organization_id = p_org_id

Line 367: FND_GLOBAL.USER_ID,

363: transaction_header_id,
364: transaction_temp_id,
365: 1, --manual and user directed
366: operation_plan_id,
367: FND_GLOBAL.USER_ID,
368: SYSDATE,
369: FND_GLOBAL.LOGIN_ID,
370: FND_GLOBAL.USER_ID,
371: SYSDATE

Line 369: FND_GLOBAL.LOGIN_ID,

365: 1, --manual and user directed
366: operation_plan_id,
367: FND_GLOBAL.USER_ID,
368: SYSDATE,
369: FND_GLOBAL.LOGIN_ID,
370: FND_GLOBAL.USER_ID,
371: SYSDATE
372: from
373: mtl_material_transactions_temp

Line 370: FND_GLOBAL.USER_ID,

366: operation_plan_id,
367: FND_GLOBAL.USER_ID,
368: SYSDATE,
369: FND_GLOBAL.LOGIN_ID,
370: FND_GLOBAL.USER_ID,
371: SYSDATE
372: from
373: mtl_material_transactions_temp
374: where organization_id = p_org_id

Line 440: FND_GLOBAL.USER_ID,

436: transaction_header_id,
437: transaction_temp_id,
438: 1, --manual and user directed
439: operation_plan_id,
440: FND_GLOBAL.USER_ID,
441: SYSDATE,
442: FND_GLOBAL.LOGIN_ID,
443: FND_GLOBAL.USER_ID,
444: SYSDATE

Line 442: FND_GLOBAL.LOGIN_ID,

438: 1, --manual and user directed
439: operation_plan_id,
440: FND_GLOBAL.USER_ID,
441: SYSDATE,
442: FND_GLOBAL.LOGIN_ID,
443: FND_GLOBAL.USER_ID,
444: SYSDATE
445: from
446: mtl_material_transactions_temp

Line 443: FND_GLOBAL.USER_ID,

439: operation_plan_id,
440: FND_GLOBAL.USER_ID,
441: SYSDATE,
442: FND_GLOBAL.LOGIN_ID,
443: FND_GLOBAL.USER_ID,
444: SYSDATE
445: from
446: mtl_material_transactions_temp
447: where organization_id = p_org_id

Line 513: FND_GLOBAL.USER_ID,

509: transaction_header_id,
510: transaction_temp_id,
511: 1, --manual and user directed
512: operation_plan_id,
513: FND_GLOBAL.USER_ID,
514: SYSDATE,
515: FND_GLOBAL.LOGIN_ID,
516: FND_GLOBAL.USER_ID,
517: SYSDATE

Line 515: FND_GLOBAL.LOGIN_ID,

511: 1, --manual and user directed
512: operation_plan_id,
513: FND_GLOBAL.USER_ID,
514: SYSDATE,
515: FND_GLOBAL.LOGIN_ID,
516: FND_GLOBAL.USER_ID,
517: SYSDATE
518: from
519: mtl_material_transactions_temp

Line 516: FND_GLOBAL.USER_ID,

512: operation_plan_id,
513: FND_GLOBAL.USER_ID,
514: SYSDATE,
515: FND_GLOBAL.LOGIN_ID,
516: FND_GLOBAL.USER_ID,
517: SYSDATE
518: from
519: mtl_material_transactions_temp
520: where organization_id = p_org_id

Line 585: FND_GLOBAL.USER_ID,

581: locator_id,
582: transaction_header_id,
583: transaction_temp_id,
584: 1, --manual and user directed
585: FND_GLOBAL.USER_ID,
586: SYSDATE,
587: FND_GLOBAL.LOGIN_ID,
588: FND_GLOBAL.USER_ID,
589: SYSDATE

Line 587: FND_GLOBAL.LOGIN_ID,

583: transaction_temp_id,
584: 1, --manual and user directed
585: FND_GLOBAL.USER_ID,
586: SYSDATE,
587: FND_GLOBAL.LOGIN_ID,
588: FND_GLOBAL.USER_ID,
589: SYSDATE
590: from mtl_material_transactions_temp
591: where organization_id = p_org_id

Line 588: FND_GLOBAL.USER_ID,

584: 1, --manual and user directed
585: FND_GLOBAL.USER_ID,
586: SYSDATE,
587: FND_GLOBAL.LOGIN_ID,
588: FND_GLOBAL.USER_ID,
589: SYSDATE
590: from mtl_material_transactions_temp
591: where organization_id = p_org_id
592: and transaction_type_id = 44

Line 660: FND_GLOBAL.USER_ID,

656: mcce.inventory_item_id,
657: mcce.cycle_count_header_id,
658: mcce.cycle_count_entry_id,
659: 1, --Individual and System Directed
660: FND_GLOBAL.USER_ID,
661: SYSDATE,
662: FND_GLOBAL.LOGIN_ID,
663: FND_GLOBAL.USER_ID,
664: SYSDATE

Line 662: FND_GLOBAL.LOGIN_ID,

658: mcce.cycle_count_entry_id,
659: 1, --Individual and System Directed
660: FND_GLOBAL.USER_ID,
661: SYSDATE,
662: FND_GLOBAL.LOGIN_ID,
663: FND_GLOBAL.USER_ID,
664: SYSDATE
665: from
666: mtl_cycle_Count_entries mcce

Line 663: FND_GLOBAL.USER_ID,

659: 1, --Individual and System Directed
660: FND_GLOBAL.USER_ID,
661: SYSDATE,
662: FND_GLOBAL.LOGIN_ID,
663: FND_GLOBAL.USER_ID,
664: SYSDATE
665: from
666: mtl_cycle_Count_entries mcce
667: WHERE

Line 856: FND_GLOBAL.USER_ID,

852: end), /*mmtt.demand_source_line, Modified for bug # 5478983(For Bulk Tasks,
853: demand_source_line will be NULL. hence, parent_line_id will be populated for BULK tasks) */
854: 3, --Individual and system directed
855: operation_plan_id,
856: FND_GLOBAL.USER_ID,
857: SYSDATE,
858: FND_GLOBAL.LOGIN_ID,
859: FND_GLOBAL.USER_ID,
860: SYSDATE

Line 858: FND_GLOBAL.LOGIN_ID,

854: 3, --Individual and system directed
855: operation_plan_id,
856: FND_GLOBAL.USER_ID,
857: SYSDATE,
858: FND_GLOBAL.LOGIN_ID,
859: FND_GLOBAL.USER_ID,
860: SYSDATE
861: from
862: mtl_material_transactions_temp mmtt

Line 859: FND_GLOBAL.USER_ID,

855: operation_plan_id,
856: FND_GLOBAL.USER_ID,
857: SYSDATE,
858: FND_GLOBAL.LOGIN_ID,
859: FND_GLOBAL.USER_ID,
860: SYSDATE
861: from
862: mtl_material_transactions_temp mmtt
863: where

Line 1097: FND_GLOBAL.USER_ID,

1093: end), /*mmtt.demand_source_line, Modified for bug # 5478983(For Bulk Tasks,
1094: demand_source_line will be NULL. hence, parent_line_id will be populated for BULK tasks) */
1095: 3, --Individual and system directed
1096: mmtt.operation_plan_id,
1097: FND_GLOBAL.USER_ID,
1098: SYSDATE,
1099: FND_GLOBAL.LOGIN_ID,
1100: FND_GLOBAL.USER_ID,
1101: SYSDATE

Line 1099: FND_GLOBAL.LOGIN_ID,

1095: 3, --Individual and system directed
1096: mmtt.operation_plan_id,
1097: FND_GLOBAL.USER_ID,
1098: SYSDATE,
1099: FND_GLOBAL.LOGIN_ID,
1100: FND_GLOBAL.USER_ID,
1101: SYSDATE
1102: from
1103: mtl_material_transactions_temp mmtt,

Line 1100: FND_GLOBAL.USER_ID,

1096: mmtt.operation_plan_id,
1097: FND_GLOBAL.USER_ID,
1098: SYSDATE,
1099: FND_GLOBAL.LOGIN_ID,
1100: FND_GLOBAL.USER_ID,
1101: SYSDATE
1102: from
1103: mtl_material_transactions_temp mmtt,
1104: wms_dispatched_tasks wdt

Line 1315: FND_GLOBAL.USER_ID,

1311: mmtt.transaction_temp_id, -- mmtt.demand_source_header_id, Modified for bug # 5169490
1312: mmtt.demand_source_line,
1313: 3, --Individual and system directed
1314: mmtt.operation_plan_id,
1315: FND_GLOBAL.USER_ID,
1316: SYSDATE,
1317: FND_GLOBAL.LOGIN_ID,
1318: FND_GLOBAL.USER_ID,
1319: SYSDATE

Line 1317: FND_GLOBAL.LOGIN_ID,

1313: 3, --Individual and system directed
1314: mmtt.operation_plan_id,
1315: FND_GLOBAL.USER_ID,
1316: SYSDATE,
1317: FND_GLOBAL.LOGIN_ID,
1318: FND_GLOBAL.USER_ID,
1319: SYSDATE
1320: from
1321: mtl_material_transactions_temp mmtt

Line 1318: FND_GLOBAL.USER_ID,

1314: mmtt.operation_plan_id,
1315: FND_GLOBAL.USER_ID,
1316: SYSDATE,
1317: FND_GLOBAL.LOGIN_ID,
1318: FND_GLOBAL.USER_ID,
1319: SYSDATE
1320: from
1321: mtl_material_transactions_temp mmtt
1322: where

Line 1526: FND_GLOBAL.USER_ID,

1522: mmtt.transaction_temp_id, -- mmtt.demand_source_header_id, Modified for bug # 5169490
1523: mmtt.demand_source_line,
1524: 3, --Individual and system directed
1525: mmtt.operation_plan_id,
1526: FND_GLOBAL.USER_ID,
1527: SYSDATE,
1528: FND_GLOBAL.LOGIN_ID,
1529: FND_GLOBAL.USER_ID,
1530: SYSDATE

Line 1528: FND_GLOBAL.LOGIN_ID,

1524: 3, --Individual and system directed
1525: mmtt.operation_plan_id,
1526: FND_GLOBAL.USER_ID,
1527: SYSDATE,
1528: FND_GLOBAL.LOGIN_ID,
1529: FND_GLOBAL.USER_ID,
1530: SYSDATE
1531: from
1532: mtl_material_transactions_temp mmtt,

Line 1529: FND_GLOBAL.USER_ID,

1525: mmtt.operation_plan_id,
1526: FND_GLOBAL.USER_ID,
1527: SYSDATE,
1528: FND_GLOBAL.LOGIN_ID,
1529: FND_GLOBAL.USER_ID,
1530: SYSDATE
1531: from
1532: mtl_material_transactions_temp mmtt,
1533: wms_dispatched_tasks wdt

Line 1723: FND_GLOBAL.USER_ID,

1719: mmtt2.transaction_temp_id, -- mmtt.demand_source_header_id, Modified for bug # 5169490
1720: mmtt2.demand_source_line,
1721: 3, --Individual and system directed
1722: mmtt2.operation_plan_id,
1723: FND_GLOBAL.USER_ID,
1724: SYSDATE,
1725: FND_GLOBAL.LOGIN_ID,
1726: FND_GLOBAL.USER_ID,
1727: SYSDATE

Line 1725: FND_GLOBAL.LOGIN_ID,

1721: 3, --Individual and system directed
1722: mmtt2.operation_plan_id,
1723: FND_GLOBAL.USER_ID,
1724: SYSDATE,
1725: FND_GLOBAL.LOGIN_ID,
1726: FND_GLOBAL.USER_ID,
1727: SYSDATE
1728: from
1729: mtl_material_transactions_temp mmtt1,

Line 1726: FND_GLOBAL.USER_ID,

1722: mmtt2.operation_plan_id,
1723: FND_GLOBAL.USER_ID,
1724: SYSDATE,
1725: FND_GLOBAL.LOGIN_ID,
1726: FND_GLOBAL.USER_ID,
1727: SYSDATE
1728: from
1729: mtl_material_transactions_temp mmtt1,
1730: mtl_material_transactions_temp mmtt2,

Line 1842: FND_GLOBAL.USER_ID,

1838: inventory_item_id,
1839: source_header_id,
1840: source_line_id,
1841: group_id,
1842: FND_GLOBAL.USER_ID,
1843: SYSDATE,
1844: FND_GLOBAL.LOGIN_ID,
1845: FND_GLOBAL.USER_ID,
1846: SYSDATE

Line 1844: FND_GLOBAL.LOGIN_ID,

1840: source_line_id,
1841: group_id,
1842: FND_GLOBAL.USER_ID,
1843: SYSDATE,
1844: FND_GLOBAL.LOGIN_ID,
1845: FND_GLOBAL.USER_ID,
1846: SYSDATE
1847: FROM
1848: (

Line 1845: FND_GLOBAL.USER_ID,

1841: group_id,
1842: FND_GLOBAL.USER_ID,
1843: SYSDATE,
1844: FND_GLOBAL.LOGIN_ID,
1845: FND_GLOBAL.USER_ID,
1846: SYSDATE
1847: FROM
1848: (
1849: SELECT DISTINCT

Line 1941: FND_GLOBAL.USER_ID,

1937: source_header_id,
1938: source_line_id,
1939: operation_plan_id,
1940: group_id,
1941: FND_GLOBAL.USER_ID,
1942: SYSDATE,
1943: FND_GLOBAL.LOGIN_ID,
1944: FND_GLOBAL.USER_ID,
1945: SYSDATE

Line 1943: FND_GLOBAL.LOGIN_ID,

1939: operation_plan_id,
1940: group_id,
1941: FND_GLOBAL.USER_ID,
1942: SYSDATE,
1943: FND_GLOBAL.LOGIN_ID,
1944: FND_GLOBAL.USER_ID,
1945: SYSDATE
1946: from
1947: (

Line 1944: FND_GLOBAL.USER_ID,

1940: group_id,
1941: FND_GLOBAL.USER_ID,
1942: SYSDATE,
1943: FND_GLOBAL.LOGIN_ID,
1944: FND_GLOBAL.USER_ID,
1945: SYSDATE
1946: from
1947: (
1948: select distinct