DBA Data[Home] [Help]

APPS.MRP_ADJUST_DATES_PK dependencies on MRP_SCHEDULE_DESIGNATORS

Line 158: mrp_schedule_designators desig

154: dates.schedule_workdate =
155: (SELECT DECODE(desig.schedule_type, 1, prior_date,
156: next_date)
157: FROM bom_calendar_dates cal,
158: mrp_schedule_designators desig
159: WHERE cal.calendar_code = cal_code
160: AND cal.exception_set_id = except_set_id
161: /*2285842 AND cal.calendar_date = dates.schedule_workdate*/
162: AND cal.calendar_date = dates.schedule_date

Line 189: FROM mrp_schedule_designators desig,

185: dates.last_updated_by = user_id,
186: dates.schedule_date = schedule_workdate
187: WHERE ((organization_id, schedule_designator) IN
188: (SELECT org_id, desig.schedule_designator
189: FROM mrp_schedule_designators desig,
190: mrp_plan_organizations_v orgs
191: WHERE orgs.planned_organization (+) = org_id
192: AND desig.organization_id = NVL(orgs.organization_id,
193: org_id)