VIEW: APPS.WMS_DOCK_APPOINTMENTS_V

Source

View Text - Preformatted

SELECT B.dock_appointment_ID dock_appointment_ID, B.appointment_type appointment_type, B.dock_ID dock_ID, B.organization_ID organization_ID, B.start_time start_time, B.end_time end_time, B.carrier carrier, B.source_type source_type, B.source_header_id source_header_id, B.source_line_id source_line_id, B.TRIP_STOP TRIP_STOP, B.REP_START_DATE REP_START_DATE, B.REP_END_DATE REP_END_DATE, B.REP_ORIGIN REP_ORIGIN, B.REP_FREQUENCY REP_FREQUENCY, B.APPOINTMENT_STATUS APPOINTMENT_STATUS, B.created_by created_by, B.creation_date creation_date, B.last_updated_by last_updated_by, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.last_update_login last_update_login, T.subject subject, T.description description, B.staging_lane_id staging_lane_id, B.CARRIER_CODE from WMS_DOCK_APPOINTMENTS_B B, WMS_DOCK_APPOINTMENTS_TL T WHERE B.dock_appointment_ID = T.dock_appointment_ID and T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.DOCK_APPOINTMENT_ID DOCK_APPOINTMENT_ID
, B.APPOINTMENT_TYPE APPOINTMENT_TYPE
, B.DOCK_ID DOCK_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.START_TIME START_TIME
, B.END_TIME END_TIME
, B.CARRIER CARRIER
, B.SOURCE_TYPE SOURCE_TYPE
, B.SOURCE_HEADER_ID SOURCE_HEADER_ID
, B.SOURCE_LINE_ID SOURCE_LINE_ID
, B.TRIP_STOP TRIP_STOP
, B.REP_START_DATE REP_START_DATE
, B.REP_END_DATE REP_END_DATE
, B.REP_ORIGIN REP_ORIGIN
, B.REP_FREQUENCY REP_FREQUENCY
, B.APPOINTMENT_STATUS APPOINTMENT_STATUS
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.SUBJECT SUBJECT
, T.DESCRIPTION DESCRIPTION
, B.STAGING_LANE_ID STAGING_LANE_ID
, B.CARRIER_CODE
FROM WMS_DOCK_APPOINTMENTS_B B
, WMS_DOCK_APPOINTMENTS_TL T
WHERE B.DOCK_APPOINTMENT_ID = T.DOCK_APPOINTMENT_ID
AND T.LANGUAGE = USERENV('LANG')