Product: | WMS - Warehouse Management |
---|---|
Description: | Used by WMS dock appointment form. |
Implementation/DBA Data: | APPS.WMS_DOCK_APPOINTMENTS_V |
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')