VIEW: RLM.RLM_CUST_ITEM_TERMS_ALL#

Source

View Text - Preformatted

select CUST_ITEM_TERMS_ID CUST_ITEM_TERMS_ID, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, ADDRESS_ID ADDRESS_ID, HEADER_ID HEADER_ID, AGREEMENT_NAME AGREEMENT_NAME, FUTURE_AGREEMENT_NAME FUTURE_AGREEMENT_NAME, CALC_CUM_FLAG CALC_CUM_FLAG, CUM_CURRENT_START_DATE CUM_CURRENT_START_DATE, CUM_PREVIOUS_START_DATE CUM_PREVIOUS_START_DATE, CUST_ITEM_STATUS_CODE CUST_ITEM_STATUS_CODE, ROUND_TO_STD_PACK_FLAG ROUND_TO_STD_PACK_FLAG, SHIP_DELIVERY_RULE_NAME SHIP_DELIVERY_RULE_NAME, SHIP_METHOD SHIP_METHOD, INTRANSIT_TIME INTRANSIT_TIME, STD_PACK_QTY STD_PACK_QTY, TIME_UOM_CODE TIME_UOM_CODE, ORG_ID ORG_ID, PRICE_LIST_ID PRICE_LIST_ID, DEMAND_TOLERANCE_ABOVE DEMAND_TOLERANCE_ABOVE, USE_EDI_SDP_CODE_FLAG USE_EDI_SDP_CODE_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PLN_FIRM_DAY_TO PLN_FIRM_DAY_TO, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PLN_FORECAST_DAY_FROM PLN_FORECAST_DAY_FROM, PLN_FORECAST_DAY_TO PLN_FORECAST_DAY_TO, PLN_FROZEN_DAY_TO PLN_FROZEN_DAY_TO, PLN_FROZEN_DAY_FROM PLN_FROZEN_DAY_FROM, ATTRIBUTE1 ATTRIBUTE1, SEQ_FIRM_DAY_FROM SEQ_FIRM_DAY_FROM, SEQ_FIRM_DAY_TO SEQ_FIRM_DAY_TO, ATTRIBUTE2 ATTRIBUTE2, SEQ_FORECAST_DAY_TO SEQ_FORECAST_DAY_TO, SEQ_FORECAST_DAY_FROM SEQ_FORECAST_DAY_FROM, ATTRIBUTE3 ATTRIBUTE3, SEQ_FROZEN_DAY_FROM SEQ_FROZEN_DAY_FROM, SEQ_FROZEN_DAY_TO SEQ_FROZEN_DAY_TO, ATTRIBUTE4 ATTRIBUTE4, SHP_FIRM_DAY_FROM SHP_FIRM_DAY_FROM, SHP_FIRM_DAY_TO SHP_FIRM_DAY_TO, ATTRIBUTE5 ATTRIBUTE5, SHP_FROZEN_DAY_TO SHP_FROZEN_DAY_TO, SHP_FROZEN_DAY_FROM SHP_FROZEN_DAY_FROM, ATTRIBUTE6 ATTRIBUTE6, SHP_FORECAST_DAY_TO SHP_FORECAST_DAY_TO, SHP_FORECAST_DAY_FROM SHP_FORECAST_DAY_FROM, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DEMAND_TOLERANCE_BELOW DEMAND_TOLERANCE_BELOW, CUSTOMER_CONTACT_ID CUSTOMER_CONTACT_ID, CUSTOMER_ID CUSTOMER_ID, FREIGHT_CODE FREIGHT_CODE, PLN_FIRM_DAY_FROM PLN_FIRM_DAY_FROM, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY, INACTIVE_DATE INACTIVE_DATE, COMMENTS COMMENTS, PLN_MRP_FORECAST_DAY_FROM PLN_MRP_FORECAST_DAY_FROM, PLN_MRP_FORECAST_DAY_TO PLN_MRP_FORECAST_DAY_TO, SHP_MRP_FORECAST_DAY_FROM SHP_MRP_FORECAST_DAY_FROM, SHP_MRP_FORECAST_DAY_TO SHP_MRP_FORECAST_DAY_TO, SEQ_MRP_FORECAST_DAY_FROM SEQ_MRP_FORECAST_DAY_FROM, SEQ_MRP_FORECAST_DAY_TO SEQ_MRP_FORECAST_DAY_TO, DEFAULT_SHIP_FROM DEFAULT_SHIP_FROM, PLN_FROZEN_FLAG PLN_FROZEN_FLAG, SHP_FROZEN_FLAG SHP_FROZEN_FLAG, SEQ_FROZEN_FLAG SEQ_FROZEN_FLAG, ISSUE_WARNING_DROP_PARTS_FLAG ISSUE_WARNING_DROP_PARTS_FLAG, BLANKET_NUMBER BLANKET_NUMBER, RELEASE_RULE RELEASE_RULE, RELEASE_TIME_FRAME RELEASE_TIME_FRAME, RELEASE_TIME_FRAME_UOM RELEASE_TIME_FRAME_UOM, AGREEMENT_ID AGREEMENT_ID, FUTURE_AGREEMENT_ID FUTURE_AGREEMENT_ID, EXCLUDE_NON_WORKDAYS_FLAG EXCLUDE_NON_WORKDAYS_FLAG, DISABLE_CREATE_CUM_KEY_FLAG DISABLE_CREATE_CUM_KEY_FLAG from "RLM"."RLM_CUST_ITEM_TERMS_ALL"

View Text - HTML Formatted

SELECT CUST_ITEM_TERMS_ID CUST_ITEM_TERMS_ID
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, ADDRESS_ID ADDRESS_ID
, HEADER_ID HEADER_ID
, AGREEMENT_NAME AGREEMENT_NAME
, FUTURE_AGREEMENT_NAME FUTURE_AGREEMENT_NAME
, CALC_CUM_FLAG CALC_CUM_FLAG
, CUM_CURRENT_START_DATE CUM_CURRENT_START_DATE
, CUM_PREVIOUS_START_DATE CUM_PREVIOUS_START_DATE
, CUST_ITEM_STATUS_CODE CUST_ITEM_STATUS_CODE
, ROUND_TO_STD_PACK_FLAG ROUND_TO_STD_PACK_FLAG
, SHIP_DELIVERY_RULE_NAME SHIP_DELIVERY_RULE_NAME
, SHIP_METHOD SHIP_METHOD
, INTRANSIT_TIME INTRANSIT_TIME
, STD_PACK_QTY STD_PACK_QTY
, TIME_UOM_CODE TIME_UOM_CODE
, ORG_ID ORG_ID
, PRICE_LIST_ID PRICE_LIST_ID
, DEMAND_TOLERANCE_ABOVE DEMAND_TOLERANCE_ABOVE
, USE_EDI_SDP_CODE_FLAG USE_EDI_SDP_CODE_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PLN_FIRM_DAY_TO PLN_FIRM_DAY_TO
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PLN_FORECAST_DAY_FROM PLN_FORECAST_DAY_FROM
, PLN_FORECAST_DAY_TO PLN_FORECAST_DAY_TO
, PLN_FROZEN_DAY_TO PLN_FROZEN_DAY_TO
, PLN_FROZEN_DAY_FROM PLN_FROZEN_DAY_FROM
, ATTRIBUTE1 ATTRIBUTE1
, SEQ_FIRM_DAY_FROM SEQ_FIRM_DAY_FROM
, SEQ_FIRM_DAY_TO SEQ_FIRM_DAY_TO
, ATTRIBUTE2 ATTRIBUTE2
, SEQ_FORECAST_DAY_TO SEQ_FORECAST_DAY_TO
, SEQ_FORECAST_DAY_FROM SEQ_FORECAST_DAY_FROM
, ATTRIBUTE3 ATTRIBUTE3
, SEQ_FROZEN_DAY_FROM SEQ_FROZEN_DAY_FROM
, SEQ_FROZEN_DAY_TO SEQ_FROZEN_DAY_TO
, ATTRIBUTE4 ATTRIBUTE4
, SHP_FIRM_DAY_FROM SHP_FIRM_DAY_FROM
, SHP_FIRM_DAY_TO SHP_FIRM_DAY_TO
, ATTRIBUTE5 ATTRIBUTE5
, SHP_FROZEN_DAY_TO SHP_FROZEN_DAY_TO
, SHP_FROZEN_DAY_FROM SHP_FROZEN_DAY_FROM
, ATTRIBUTE6 ATTRIBUTE6
, SHP_FORECAST_DAY_TO SHP_FORECAST_DAY_TO
, SHP_FORECAST_DAY_FROM SHP_FORECAST_DAY_FROM
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DEMAND_TOLERANCE_BELOW DEMAND_TOLERANCE_BELOW
, CUSTOMER_CONTACT_ID CUSTOMER_CONTACT_ID
, CUSTOMER_ID CUSTOMER_ID
, FREIGHT_CODE FREIGHT_CODE
, PLN_FIRM_DAY_FROM PLN_FIRM_DAY_FROM
, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY
, INACTIVE_DATE INACTIVE_DATE
, COMMENTS COMMENTS
, PLN_MRP_FORECAST_DAY_FROM PLN_MRP_FORECAST_DAY_FROM
, PLN_MRP_FORECAST_DAY_TO PLN_MRP_FORECAST_DAY_TO
, SHP_MRP_FORECAST_DAY_FROM SHP_MRP_FORECAST_DAY_FROM
, SHP_MRP_FORECAST_DAY_TO SHP_MRP_FORECAST_DAY_TO
, SEQ_MRP_FORECAST_DAY_FROM SEQ_MRP_FORECAST_DAY_FROM
, SEQ_MRP_FORECAST_DAY_TO SEQ_MRP_FORECAST_DAY_TO
, DEFAULT_SHIP_FROM DEFAULT_SHIP_FROM
, PLN_FROZEN_FLAG PLN_FROZEN_FLAG
, SHP_FROZEN_FLAG SHP_FROZEN_FLAG
, SEQ_FROZEN_FLAG SEQ_FROZEN_FLAG
, ISSUE_WARNING_DROP_PARTS_FLAG ISSUE_WARNING_DROP_PARTS_FLAG
, BLANKET_NUMBER BLANKET_NUMBER
, RELEASE_RULE RELEASE_RULE
, RELEASE_TIME_FRAME RELEASE_TIME_FRAME
, RELEASE_TIME_FRAME_UOM RELEASE_TIME_FRAME_UOM
, AGREEMENT_ID AGREEMENT_ID
, FUTURE_AGREEMENT_ID FUTURE_AGREEMENT_ID
, EXCLUDE_NON_WORKDAYS_FLAG EXCLUDE_NON_WORKDAYS_FLAG
, DISABLE_CREATE_CUM_KEY_FLAG DISABLE_CREATE_CUM_KEY_FLAG
FROM "RLM"."RLM_CUST_ITEM_TERMS_ALL"