VIEW: WSH.WSH_SHIP_CONFIRM_RULES#

Source

View Text - Preformatted

select SHIP_CONFIRM_RULE_ID SHIP_CONFIRM_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, NAME NAME, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ACTION_FLAG ACTION_FLAG, STAGE_DEL_FLAG STAGE_DEL_FLAG, SHIP_METHOD_CODE SHIP_METHOD_CODE, AC_ACTUAL_DEP_DATE_DEFAULT AC_ACTUAL_DEP_DATE_DEFAULT, AC_INTRANSIT_FLAG AC_INTRANSIT_FLAG, AC_CLOSE_TRIP_FLAG AC_CLOSE_TRIP_FLAG, AC_BOL_FLAG AC_BOL_FLAG, AC_DEFER_INTERFACE_FLAG AC_DEFER_INTERFACE_FLAG, MC_INTRANSIT_FLAG MC_INTRANSIT_FLAG, MC_CLOSE_TRIP_FLAG MC_CLOSE_TRIP_FLAG, MC_DEFER_INTERFACE_FLAG MC_DEFER_INTERFACE_FLAG, REPORT_SET_ID REPORT_SET_ID, SEND_945_FLAG SEND_945_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, MC_BOL_FLAG MC_BOL_FLAG, SHIP_METHOD_DEFAULT_FLAG SHIP_METHOD_DEFAULT_FLAG from "WSH"."WSH_SHIP_CONFIRM_RULES"

View Text - HTML Formatted

SELECT SHIP_CONFIRM_RULE_ID SHIP_CONFIRM_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, NAME NAME
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ACTION_FLAG ACTION_FLAG
, STAGE_DEL_FLAG STAGE_DEL_FLAG
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, AC_ACTUAL_DEP_DATE_DEFAULT AC_ACTUAL_DEP_DATE_DEFAULT
, AC_INTRANSIT_FLAG AC_INTRANSIT_FLAG
, AC_CLOSE_TRIP_FLAG AC_CLOSE_TRIP_FLAG
, AC_BOL_FLAG AC_BOL_FLAG
, AC_DEFER_INTERFACE_FLAG AC_DEFER_INTERFACE_FLAG
, MC_INTRANSIT_FLAG MC_INTRANSIT_FLAG
, MC_CLOSE_TRIP_FLAG MC_CLOSE_TRIP_FLAG
, MC_DEFER_INTERFACE_FLAG MC_DEFER_INTERFACE_FLAG
, REPORT_SET_ID REPORT_SET_ID
, SEND_945_FLAG SEND_945_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, MC_BOL_FLAG MC_BOL_FLAG
, SHIP_METHOD_DEFAULT_FLAG SHIP_METHOD_DEFAULT_FLAG
FROM "WSH"."WSH_SHIP_CONFIRM_RULES"