DBA Data[Home] [Help]

APPS.MRP_MANAGER_PK dependencies on MRP_CALENDAR

Line 560: MRP_CALENDAR.DATE_OFFSET (dem.ship_from_org_id,

556: decode(nvl(dem.mfg_lead_time,0),
557: 0, dem.SCHEDULE_SHIP_DATE,
558: decode(dem.line_id,
559: dem.ato_line_id, dem.SCHEDULE_SHIP_DATE,
560: MRP_CALENDAR.DATE_OFFSET (dem.ship_from_org_id,
561: 1,
562: dem.schedule_ship_date,
563: -1*(dem.mfg_lead_time)))),
564: DECODE(dem.ORDERED_QUANTITY,

Line 633: mrp_calendar.date_offset(updates.organization_id,

629: decode(nvl(dem.mfg_lead_time,0),
630: 0,updates.new_schedule_date,
631: decode(dem.line_id,
632: dem.ato_line_id, dem.SCHEDULE_SHIP_DATE,
633: mrp_calendar.date_offset(updates.organization_id,
634: 1,
635: updates.new_schedule_date,
636: dem.mfg_lead_time)))
637: = dem.SCHEDULE_SHIP_DATE

Line 679: MRP_CALENDAR.DATE_OFFSET (dem.ship_from_org_id,

675: decode(nvl(dem.mfg_lead_time,0),
676: 0, dem.SCHEDULE_SHIP_DATE,
677: decode(dem.line_id,
678: dem.ato_line_id, dem.SCHEDULE_SHIP_DATE,
679: MRP_CALENDAR.DATE_OFFSET (dem.ship_from_org_id,
680: 1,
681: dem.schedule_ship_date,
682: -1*(dem.mfg_lead_time)))),
683: DECODE(dem.ORDERED_QUANTITY,