APPS.PMI_PRODUCTION_SUM dependencies on PS_SCHD_DTL

Line 415: FROM ps_schd_dtl sd, ps_schd_hdr sh,

411: PLANT_CODE_V GME_BATCH_HEADER.PLANT_CODE%type,
412: Batch_day_V DATE )
413: IS
414: SELECT shift_start,shift_duration
415: FROM ps_schd_dtl sd, ps_schd_hdr sh,
416: mr_shcl_dtl sc, mr_shdy_dtl sl
417: WHERE sd.schedule_id = sh.schedule_id
418: AND sd.Calendar_id = sc.Calendar_id
419: AND sc.shopday_no = sl.shopday_no

Line 432: from ps_schd_dtl sd, ps_schd_hdr sh

428: from gme_batch_header
429: where batch_id = batch_id_vi;
430:
431: select count(*) into count2_v
432: from ps_schd_dtl sd, ps_schd_hdr sh
433: where sd.schedule_id = sh.schedule_id
434: and sh.schedule = SCHEDULE_VI
435: AND sd.orgn_code = PLANT_CODE_V1;
436: