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

Line 85: FND_GLOBAL.USER_ID,

81: 8, -- onhand
82: sum(transaction_qty),
83: NULL, -- reservation quantity
84: SYSDATE,
85: FND_GLOBAL.USER_ID,
86: SYSDATE,
87: FND_GLOBAL.USER_ID,
88: NULL,
89: 2, -- supply

Line 87: FND_GLOBAL.USER_ID,

83: NULL, -- reservation quantity
84: SYSDATE,
85: FND_GLOBAL.USER_ID,
86: SYSDATE,
87: FND_GLOBAL.USER_ID,
88: NULL,
89: 2, -- supply
90: NULL
91: FROM (

Line 163: FND_GLOBAL.USER_ID,

159: DECODE(I.REPETITIVE_PLANNING_FLAG, 'Y',D2.REPETITIVE_DAILY_RATE,
160: D2.SCHEDULE_QUANTITY) ,
161: NULL, -- reservation quantity
162: SYSDATE,
163: FND_GLOBAL.USER_ID,
164: SYSDATE,
165: FND_GLOBAL.USER_ID,
166: D1.DEMAND_CLASS,
167: 2, -- supply

Line 165: FND_GLOBAL.USER_ID,

161: NULL, -- reservation quantity
162: SYSDATE,
163: FND_GLOBAL.USER_ID,
164: SYSDATE,
165: FND_GLOBAL.USER_ID,
166: D1.DEMAND_CLASS,
167: 2, -- supply
168: DECODE(I.BOM_ITEM_TYPE, 5, I.INVENTORY_ITEM_ID, NULL)
169: FROM BOM_CALENDAR_DATES C ,

Line 228: FND_GLOBAL.USER_ID,

224: 16 ,
225: U.PRIMARY_UOM_QUANTITY ,
226: NULL, -- reservation quantity
227: SYSDATE,
228: FND_GLOBAL.USER_ID,
229: SYSDATE,
230: FND_GLOBAL.USER_ID,
231: U.DEMAND_CLASS,
232: 2, -- supply

Line 230: FND_GLOBAL.USER_ID,

226: NULL, -- reservation quantity
227: SYSDATE,
228: FND_GLOBAL.USER_ID,
229: SYSDATE,
230: FND_GLOBAL.USER_ID,
231: U.DEMAND_CLASS,
232: 2, -- supply
233: NULL
234: FROM BOM_CALENDAR_DATES C,

Line 301: FND_GLOBAL.USER_ID,

297: 1,NVL(S.MRP_PRIMARY_QUANTITY, S.TO_ORG_PRIMARY_QUANTITY),
298: S.TO_ORG_PRIMARY_QUANTITY),
299: NULL, -- reservation quantity
300: SYSDATE,
301: FND_GLOBAL.USER_ID,
302: SYSDATE,
303: FND_GLOBAL.USER_ID,
304: NULL,
305: 2, -- supply

Line 303: FND_GLOBAL.USER_ID,

299: NULL, -- reservation quantity
300: SYSDATE,
301: FND_GLOBAL.USER_ID,
302: SYSDATE,
303: FND_GLOBAL.USER_ID,
304: NULL,
305: 2, -- supply
306: NULL
307: FROM BOM_CALENDAR_DATES C ,

Line 393: FND_GLOBAL.USER_ID,

389: D.NET_QUANTITY),
390: D.NET_QUANTITY)-D.QUANTITY_COMPLETED-D.QUANTITY_SCRAPPED),
391: NULL, -- reservation quantity
392: SYSDATE,
393: FND_GLOBAL.USER_ID,
394: SYSDATE,
395: FND_GLOBAL.USER_ID,
396: D.DEMAND_CLASS,
397: 2, -- supply

Line 395: FND_GLOBAL.USER_ID,

391: NULL, -- reservation quantity
392: SYSDATE,
393: FND_GLOBAL.USER_ID,
394: SYSDATE,
395: FND_GLOBAL.USER_ID,
396: D.DEMAND_CLASS,
397: 2, -- supply
398: NULL
399: FROM BOM_CALENDAR_DATES C ,

Line 457: FND_GLOBAL.USER_ID,

453: DECODE(D.JOB_TYPE, 1, 5, 7) ,
454: -1*O.REQUIRED_QUANTITY ,
455: NULL, -- reservation quantity
456: SYSDATE,
457: FND_GLOBAL.USER_ID,
458: SYSDATE,
459: FND_GLOBAL.USER_ID,
460: D.DEMAND_CLASS,
461: 2, -- supply

Line 459: FND_GLOBAL.USER_ID,

455: NULL, -- reservation quantity
456: SYSDATE,
457: FND_GLOBAL.USER_ID,
458: SYSDATE,
459: FND_GLOBAL.USER_ID,
460: D.DEMAND_CLASS,
461: 2, -- supply
462: NULL
463: FROM BOM_CALENDAR_DATES C ,

Line 531: FND_GLOBAL.USER_ID,

527: LEAST(C1.NEXT_SEQ_NUM+WRS.PROCESSING_WORK_DAYS
528: -C.NEXT_SEQ_NUM,1) *WRS.DAILY_PRODUCTION_RATE) ,
529: NULL, -- reservation quantity
530: SYSDATE,
531: FND_GLOBAL.USER_ID,
532: SYSDATE,
533: FND_GLOBAL.USER_ID,
534: WRS.DEMAND_CLASS,
535: 2, -- supply

Line 533: FND_GLOBAL.USER_ID,

529: NULL, -- reservation quantity
530: SYSDATE,
531: FND_GLOBAL.USER_ID,
532: SYSDATE,
533: FND_GLOBAL.USER_ID,
534: WRS.DEMAND_CLASS,
535: 2, -- supply
536: NULL
537: FROM BOM_CALENDAR_DATES C ,

Line 605: FND_GLOBAL.USER_ID,

601: D.PLANNED_QUANTITY),
602: D.PLANNED_QUANTITY) - D.QUANTITY_COMPLETED) ,
603: NULL, -- reservation quantity
604: SYSDATE,
605: FND_GLOBAL.USER_ID,
606: SYSDATE,
607: FND_GLOBAL.USER_ID,
608: D.DEMAND_CLASS,
609: 2, -- supply

Line 607: FND_GLOBAL.USER_ID,

603: NULL, -- reservation quantity
604: SYSDATE,
605: FND_GLOBAL.USER_ID,
606: SYSDATE,
607: FND_GLOBAL.USER_ID,
608: D.DEMAND_CLASS,
609: 2, -- supply
610: NULL
611: FROM BOM_CALENDAR_DATES C ,

Line 662: FND_GLOBAL.USER_ID,

658: DECODE(D.JOB_TYPE, 1, 5, 7) ,
659: LEAST(-1*(O.REQUIRED_QUANTITY-O.QUANTITY_ISSUED),0) ,
660: NULL, -- reservation quantity
661: SYSDATE,
662: FND_GLOBAL.USER_ID,
663: SYSDATE,
664: FND_GLOBAL.USER_ID,
665: D.DEMAND_CLASS,
666: 1, -- demand

Line 664: FND_GLOBAL.USER_ID,

660: NULL, -- reservation quantity
661: SYSDATE,
662: FND_GLOBAL.USER_ID,
663: SYSDATE,
664: FND_GLOBAL.USER_ID,
665: D.DEMAND_CLASS,
666: 1, -- demand
667: I.PRODUCT_FAMILY_ITEM_ID
668: FROM BOM_CALENDAR_DATES C ,

Line 740: FND_GLOBAL.USER_ID,

736: WRS.PROCESSING_WORK_DAYS,-1)*WRS.DAILY_PRODUCTION_RATE
737: *WRO.QUANTITY_PER_ASSEMBLY) ,
738: NULL, -- reservation quantity
739: SYSDATE,
740: FND_GLOBAL.USER_ID,
741: SYSDATE,
742: FND_GLOBAL.USER_ID,
743: WRS.DEMAND_CLASS,
744: 1, -- demand

Line 742: FND_GLOBAL.USER_ID,

738: NULL, -- reservation quantity
739: SYSDATE,
740: FND_GLOBAL.USER_ID,
741: SYSDATE,
742: FND_GLOBAL.USER_ID,
743: WRS.DEMAND_CLASS,
744: 1, -- demand
745: I.PRODUCT_FAMILY_ITEM_ID
746: FROM BOM_CALENDAR_DATES C ,

Line 812: FND_GLOBAL.USER_ID,

808: 17 ,
809: -1*U.PRIMARY_UOM_QUANTITY ,
810: NULL, -- reservation quantity
811: SYSDATE,
812: FND_GLOBAL.USER_ID,
813: SYSDATE,
814: FND_GLOBAL.USER_ID,
815: U.DEMAND_CLASS,
816: 1, -- demand

Line 814: FND_GLOBAL.USER_ID,

810: NULL, -- reservation quantity
811: SYSDATE,
812: FND_GLOBAL.USER_ID,
813: SYSDATE,
814: FND_GLOBAL.USER_ID,
815: U.DEMAND_CLASS,
816: 1, -- demand
817: I.PRODUCT_FAMILY_ITEM_ID
818: FROM BOM_CALENDAR_DATES C,

Line 870: FND_GLOBAL.USER_ID,

866: LEAST(-1*(F.PLANNED_QUANTITY-F.QUANTITY_COMPLETED)*
867: COMPONENT_QUANTITY, 0),
868: NULL, -- reservation quantity
869: SYSDATE,
870: FND_GLOBAL.USER_ID,
871: SYSDATE,
872: FND_GLOBAL.USER_ID,
873: F.DEMAND_CLASS,
874: 1, -- demand

Line 872: FND_GLOBAL.USER_ID,

868: NULL, -- reservation quantity
869: SYSDATE,
870: FND_GLOBAL.USER_ID,
871: SYSDATE,
872: FND_GLOBAL.USER_ID,
873: F.DEMAND_CLASS,
874: 1, -- demand
875: I.PRODUCT_FAMILY_ITEM_ID
876: FROM WIP_FLOW_SCHEDULES F,

Line 946: FND_GLOBAL.USER_ID,

942: -1*(D.PRIMARY_UOM_QUANTITY-
943: GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)),
944: NULL,
945: SYSDATE,
946: FND_GLOBAL.USER_ID,
947: SYSDATE,
948: FND_GLOBAL.USER_ID,
949: D.DEMAND_CLASS,
950: 1, -- demand

Line 948: FND_GLOBAL.USER_ID,

944: NULL,
945: SYSDATE,
946: FND_GLOBAL.USER_ID,
947: SYSDATE,
948: FND_GLOBAL.USER_ID,
949: D.DEMAND_CLASS,
950: 1, -- demand
951: I.PRODUCT_FAMILY_ITEM_ID
952: FROM BOM_CALENDAR_DATES C ,

Line 1018: FND_GLOBAL.USER_ID,

1014: 2 ,
1015: -1*(L.ORDERED_QUANTITY-NVL(SHIPPED_QUANTITY, 0)),
1016: NULL, -- reservation quantity
1017: SYSDATE,
1018: FND_GLOBAL.USER_ID,
1019: SYSDATE,
1020: FND_GLOBAL.USER_ID,
1021: L.DEMAND_CLASS_CODE,
1022: 1, -- demand

Line 1020: FND_GLOBAL.USER_ID,

1016: NULL, -- reservation quantity
1017: SYSDATE,
1018: FND_GLOBAL.USER_ID,
1019: SYSDATE,
1020: FND_GLOBAL.USER_ID,
1021: L.DEMAND_CLASS_CODE,
1022: 1, -- demand
1023: I.PRODUCT_FAMILY_ITEM_ID
1024: FROM BOM_CALENDAR_DATES C ,

Line 1087: FND_GLOBAL.USER_ID,

1083: 24, SALES_ORDER_DEMAND),
1084: -1*D.USING_REQUIREMENT_QUANTITY,
1085: NULL, -- reservation quantity
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: SYSDATE,
1089: FND_GLOBAL.USER_ID,
1090: D.DEMAND_CLASS,
1091: 1, -- demand

Line 1089: FND_GLOBAL.USER_ID,

1085: NULL, -- reservation quantity
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: SYSDATE,
1089: FND_GLOBAL.USER_ID,
1090: D.DEMAND_CLASS,
1091: 1, -- demand
1092: NULL -- actually this should be the product family item id
1093: FROM MSC_DEMANDS D,