Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: RLM.RLM_CUST_ITEM_TERMS_ALL#

Object Details
Object Name: RLM_CUST_ITEM_TERMS_ALL#
Object Type: VIEW
Owner: RLM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_ITEM_TERMS_ID NUMBER
Yes
CUSTOMER_ITEM_ID NUMBER
Yes
SHIP_FROM_ORG_ID NUMBER
Yes
ADDRESS_ID NUMBER

HEADER_ID NUMBER

AGREEMENT_NAME VARCHAR2 (240)
FUTURE_AGREEMENT_NAME VARCHAR2 (240)
CALC_CUM_FLAG VARCHAR2 (1)
CUM_CURRENT_START_DATE DATE

CUM_PREVIOUS_START_DATE DATE

CUST_ITEM_STATUS_CODE VARCHAR2 (25)
ROUND_TO_STD_PACK_FLAG VARCHAR2 (1)
SHIP_DELIVERY_RULE_NAME VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

STD_PACK_QTY NUMBER

TIME_UOM_CODE VARCHAR2 (3)
ORG_ID NUMBER

PRICE_LIST_ID NUMBER

DEMAND_TOLERANCE_ABOVE NUMBER

USE_EDI_SDP_CODE_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
PLN_FIRM_DAY_TO NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_FORECAST_DAY_FROM NUMBER

PLN_FORECAST_DAY_TO NUMBER

PLN_FROZEN_DAY_TO NUMBER

PLN_FROZEN_DAY_FROM NUMBER

ATTRIBUTE1 VARCHAR2 (150)
SEQ_FIRM_DAY_FROM NUMBER

SEQ_FIRM_DAY_TO NUMBER

ATTRIBUTE2 VARCHAR2 (150)
SEQ_FORECAST_DAY_TO NUMBER

SEQ_FORECAST_DAY_FROM NUMBER

ATTRIBUTE3 VARCHAR2 (150)
SEQ_FROZEN_DAY_FROM NUMBER

SEQ_FROZEN_DAY_TO NUMBER

ATTRIBUTE4 VARCHAR2 (150)
SHP_FIRM_DAY_FROM NUMBER

SHP_FIRM_DAY_TO NUMBER

ATTRIBUTE5 VARCHAR2 (150)
SHP_FROZEN_DAY_TO NUMBER

SHP_FROZEN_DAY_FROM NUMBER

ATTRIBUTE6 VARCHAR2 (150)
SHP_FORECAST_DAY_TO NUMBER

SHP_FORECAST_DAY_FROM NUMBER

ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DEMAND_TOLERANCE_BELOW NUMBER

CUSTOMER_CONTACT_ID NUMBER

CUSTOMER_ID NUMBER
Yes
FREIGHT_CODE VARCHAR2 (25)
PLN_FIRM_DAY_FROM NUMBER

SUPPLIER_CONTACT_ID NUMBER

TP_ATTRIBUTE1 VARCHAR2 (150)
TP_ATTRIBUTE2 VARCHAR2 (150)
TP_ATTRIBUTE3 VARCHAR2 (150)
TP_ATTRIBUTE4 VARCHAR2 (150)
TP_ATTRIBUTE5 VARCHAR2 (150)
TP_ATTRIBUTE6 VARCHAR2 (150)
TP_ATTRIBUTE7 VARCHAR2 (150)
TP_ATTRIBUTE8 VARCHAR2 (150)
TP_ATTRIBUTE9 VARCHAR2 (150)
TP_ATTRIBUTE10 VARCHAR2 (150)
TP_ATTRIBUTE11 VARCHAR2 (150)
TP_ATTRIBUTE12 VARCHAR2 (150)
TP_ATTRIBUTE13 VARCHAR2 (150)
TP_ATTRIBUTE14 VARCHAR2 (150)
TP_ATTRIBUTE15 VARCHAR2 (150)
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
INACTIVE_DATE DATE

COMMENTS VARCHAR2 (240)
PLN_MRP_FORECAST_DAY_FROM NUMBER

PLN_MRP_FORECAST_DAY_TO NUMBER

SHP_MRP_FORECAST_DAY_FROM NUMBER

SHP_MRP_FORECAST_DAY_TO NUMBER

SEQ_MRP_FORECAST_DAY_FROM NUMBER

SEQ_MRP_FORECAST_DAY_TO NUMBER

DEFAULT_SHIP_FROM VARCHAR2 (1)
PLN_FROZEN_FLAG VARCHAR2 (1)
SHP_FROZEN_FLAG VARCHAR2 (1)
SEQ_FROZEN_FLAG VARCHAR2 (1)
ISSUE_WARNING_DROP_PARTS_FLAG VARCHAR2 (1)
BLANKET_NUMBER NUMBER

RELEASE_RULE VARCHAR2 (2)
RELEASE_TIME_FRAME NUMBER

RELEASE_TIME_FRAME_UOM VARCHAR2 (3)
AGREEMENT_ID NUMBER

FUTURE_AGREEMENT_ID NUMBER

EXCLUDE_NON_WORKDAYS_FLAG VARCHAR2 (1)
DISABLE_CREATE_CUM_KEY_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

RLM.RLM_CUST_ITEM_TERMS_ALL# references the following:

SchemaRLM
TableRLM_CUST_ITEM_TERMS_ALL
RLM.RLM_CUST_ITEM_TERMS_ALL# is referenced by following:

SchemaAPPS
SynonymRLM_CUST_ITEM_TERMS
SynonymRLM_CUST_ITEM_TERMS_ALL