APPS.OPI_EDW_OPM_PRD_PKG dependencies on PS_SCHD_DTL

Line 268: FROM ps_schd_dtl sd, ps_schd_hdr sh,

264: PLANT_CODE_V PM_BTCH_HDR.PLANT_CODE%type,
265: Batch_day_V DATE )
266: IS
267: SELECT shift_start,shift_duration
268: FROM ps_schd_dtl sd, ps_schd_hdr sh,
269: mr_shcl_dtl sc, mr_shdy_dtl sl
270: WHERE sd.schedule_id = sh.schedule_id
271: AND sd.Calendar_id = sc.Calendar_id
272: AND sc.shopday_no = sl.shopday_no

Line 289: from ps_schd_dtl sd, ps_schd_hdr sh

285: CMPLT_DATE_V:=CMPLT_DATE;
286: SCHEDULE_VI := fnd_profile.value('GEMMS_DEFAULT_SCHEDULE');
287:
288: select count(*) into count2_v
289: from ps_schd_dtl sd, ps_schd_hdr sh
290: where sd.schedule_id = sh.schedule_id
291: and sh.schedule = SCHEDULE_VI
292: AND sd.orgn_code = PLANT_CODE_V1;
293: