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 MRP_CALENDAR

Line 80: MRP_CALENDAR.next_work_day(org_id, 1, SYSDATE),

76: 0, -- source identifier
77: -1, -- plan_id
78: org_id,
79: item_id,
80: MRP_CALENDAR.next_work_day(org_id, 1, SYSDATE),
81: 8, -- onhand
82: sum(transaction_qty),
83: NULL, -- reservation quantity
84: SYSDATE,

Line 195: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

191: AND NVL(D2.RATE_END_DATE, D2.SCHEDULE_DATE)
192: AND C.SEQ_NUM IS NOT NULL
193: AND C.CALENDAR_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
194: NULL, C.CALENDAR_DATE,
195: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
196: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)));
197:
198: -- insert user defined supply
199: INSERT INTO mrp_atp_supply_demand(

Line 247: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

243: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
244: AND R.INCLUDE_USER_DEFINED_SUPPLY = 1
245: AND C.NEXT_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
246: NULL, C.NEXT_DATE,
247: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
248: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)))
249: AND C.CALENDAR_CODE = P.CALENDAR_CODE
250: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
251: AND C.CALENDAR_DATE = TRUNC(U.EXPECTED_DELIVERY_DATE);

Line 351: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

347: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
348: AND C.CALENDAR_DATE = TRUNC(S.EXPECTED_DELIVERY_DATE)
349: AND C.NEXT_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
350: NULL, C.NEXT_DATE,
351: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
352: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)));
353:
354: -- insert wip discrete job information
355: -- question here: do I need to apply bug 791215 here?

Line 418: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

414: OR
415: D.JOB_TYPE =DECODE(R.INCLUDE_NONSTD_WIP_RECEIPTS, 1, 3, -1))
416: AND C.NEXT_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
417: NULL, C.NEXT_DATE,
418: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
419: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)))
420: AND C.CALENDAR_CODE = P.CALENDAR_CODE
421: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
422: AND C.CALENDAR_DATE = TRUNC(D.SCHEDULED_COMPLETION_DATE);

Line 487: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

483: D.JOB_TYPE = DECODE(R.INCLUDE_NONSTD_WIP_RECEIPTS, 1, 3, -1))
484: AND D.STATUS_TYPE IN (1,3, 4,6)
485: AND C.NEXT_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
486: NULL, C.NEXT_DATE,
487: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
488: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)))
489: AND C.CALENDAR_CODE = P.CALENDAR_CODE
490: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
491: AND C.CALENDAR_DATE = TRUNC(D.SCHEDULED_COMPLETION_DATE);

Line 566: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

562: LEAST(C.NEXT_SEQ_NUM-C1.NEXT_SEQ_NUM+1,
563: WRS.PROCESSING_WORK_DAYS) > WRS.QUANTITY_COMPLETED
564: AND C.CALENDAR_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
565: NULL, C.CALENDAR_DATE,
566: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
567: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)));
568:
569: -- insert flow schedule supply information
570:

Line 627: AND C.NEXT_DATE >= MRP_CALENDAR.next_work_day(

623: AND D.PRIMARY_ITEM_ID= I.INVENTORY_ITEM_ID
624: AND C.CALENDAR_CODE = P.CALENDAR_CODE
625: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
626: AND C.CALENDAR_DATE = TRUNC(D.SCHEDULED_COMPLETION_DATE)
627: AND C.NEXT_DATE >= MRP_CALENDAR.next_work_day(
628: P.ORGANIZATION_ID,1,SYSDATE);
629:
630: -- now we insert the demand information
631: -- insert wip discrete requirement information

Line 693: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

689: D.JOB_TYPE =DECODE(R.INCLUDE_NONSTD_WIP_DEMAND, 1, 3, -1))
690: AND D.STATUS_TYPE IN (1,3,4,6)
691: AND C.PRIOR_DATE >= DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
692: NULL, C.PRIOR_DATE,
693: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
694: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)))
695: AND C.CALENDAR_CODE = P.CALENDAR_CODE
696: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
697: AND C.CALENDAR_DATE = TRUNC(O.DATE_REQUIRED);

Line 779: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

775: AND C.SEQ_NUM BETWEEN C1.PRIOR_SEQ_NUM AND
776: C1.PRIOR_SEQ_NUM + CEIL(WRS.PROCESSING_WORK_DAYS - 1)
777: AND C.CALENDAR_DATE >= DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
778: NULL, C.CALENDAR_DATE,
779: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
780: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)));
781:
782: -- insert user defined demand information
783: INSERT INTO mrp_atp_supply_demand(

Line 831: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

827: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
828: AND R.INCLUDE_USER_DEFINED_DEMAND = 1
829: AND C.PRIOR_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
830: NULL, C.PRIOR_DATE,
831: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
832: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)))
833: AND C.CALENDAR_CODE = P.CALENDAR_CODE
834: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
835: AND C.CALENDAR_DATE = TRUNC(U.REQUIREMENT_DATE);

Line 901: AND C.PRIOR_DATE>=MRP_CALENDAR.next_work_day

897: AND (F.PLANNED_QUANTITY - F.QUANTITY_COMPLETED) >0
898: AND C.CALENDAR_CODE = P.CALENDAR_CODE
899: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
900: AND C.CALENDAR_DATE = TRUNC(F.SCHEDULED_COMPLETION_DATE)
901: AND C.PRIOR_DATE>=MRP_CALENDAR.next_work_day
902: (P.ORGANIZATION_ID, 1, SYSDATE);
903:
904: SELECT OE_INSTALL.Get_Active_Product
905: INTO l_oe_install

Line 982: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

978: ((R.include_DISCRETE_WIP_RECEIPTS = 1) or
979: (R.include_NONSTD_WIP_RECEIPTS = 1))))
980: AND C.PRIOR_DATE >= DECODE(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,
981: NULL, C.PRIOR_DATE,
982: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
983: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)))
984: AND C.CALENDAR_CODE = P.CALENDAR_CODE
985: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
986: AND C.CALENDAR_DATE = TRUNC(D.REQUIREMENT_DATE);

Line 1039: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

1035: AND L.VISIBLE_DEMAND_FLAG = 'Y'
1036: AND L.ORDERED_QUANTITY > NVL(L.SHIPPED_QUANTITY,0)
1037: AND C.PRIOR_DATE >= DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
1038: NULL, C.PRIOR_DATE,
1039: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
1040: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)))
1041: AND C.CALENDAR_CODE = P.CALENDAR_CODE
1042: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
1043: AND C.CALENDAR_DATE = TRUNC(L.SCHEDULE_SHIP_DATE);

Line 1117: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,

1113: DECODE(R.INCLUDE_REP_WIP_DEMAND, 1, 4, -1))
1114: AND D.USING_ASSEMBLY_DEMAND_DATE >=
1115: DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
1116: NULL,NVL(D.FIRM_DATE, D.USING_REQUIREMENT_QUANTITY),
1117: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
1118: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)));
1119:
1120: */
1121: END Collect_Atp_Info;