OSR 6 1517 C Event|//|Property 10 7 Arial Left CHAR e.EV_RESORT e 21 1512 C Start|//|Date 10 7 Arial Left Date trunc(e.START_TIME) e 24 1513 C Start|//|Time 5 7 Arial Left Char e.EVENT_START_TIME e 27 1508 C End|//|Date 10 7 Arial Left Date trunc(e.END_TIME) e 30 1509 C End|//|Time 5 7 Arial Left Char e.EVENT_END_TIME e 39 1529 C Function|//|Space 10 7 Arial Left Char e.ROOM_NAME e 42 1528 C Function|//|Space Code 10 7 Arial Left CHAR e.ROOM e 54 1514 C Status 10 7 Arial Left CHAR e.EVENT_STATUS e 60 1532 C Total Event Time|//|(with Setup/Setdown) 10 7 Arial Left Char e.SETUP_SETDWN_TIME e 69 1512 F between &pms_p.business_date 71 &pms_p.business_date Date 70 trunc(e.START_TIME) e 72 1517 F in CHAR 73 e.EV_RESORT e 75 1514 F in CHAR 76 e.EVENT_STATUS e 63 1512 O ASC Start Date 10 Left Date trunc(e.START_TIME) e 66 1513 O ASC Start Time 5 Left Char e.EVENT_START_TIME e 0 1 R Expedia Availability Report 9 Arial Y Y osr_landscape 3 1501 S LEFT OUTER Events e.resort in (select resort from mh_resort_view) e -1 73 P_CHAR11 Event Property CHAR select m.resort,r.name from mh_resort_view m, resort r where m.resort=r.resort 76 P_CHAR12 Status CHAR SELECT STATUS,DESCRIPTION FROM BOOKING_STATUS order by order_by,status 70 P_DATE11 Start Date Date &pms_p.business_date 71 P_DATE12 To Start Date Date &pms_p.business_date -1