[Home] [Help] [Dependency Information]

VIEW: APPS.RLM_CUST_SHIPTO_TERMS_V

Object Details

Object Name:	RLM_CUST_SHIPTO_TERMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	RLM.RLM_CUST_SHIPTO_TERMS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ECE_LOCATION_CODE
,      CITY
,      POSTAL_CODE
,      PROVINCE
,      COUNTY
,      ADDRESS
,      CUST_SHIPTO_TERMS_ID
,      ADDRESS_ID
,      CUSTOMER_ID
,      SHIP_FROM_ORG_ID
,      CUM_CONTROL_CODE
,      SHIP_METHOD
,      INTRANSIT_TIME
,      TIME_UOM_CODE
,      SHIP_DELIVERY_RULE_NAME
,      CUM_CURRENT_RECORD_YEAR
,      CUM_PREVIOUS_RECORD_YEAR
,      CUM_CURRENT_START_DATE
,      CUM_PREVIOUS_START_DATE
,      CUM_ORG_LEVEL_CODE
,      CUM_SHIPMENT_RULE_CODE
,      CUM_YESTERD_TIME_CUTOFF
,      CUST_ASSIGN_SUPPLIER_CD
,      CUSTOMER_RCV_CALENDAR_CD
,      FREIGHT_CODE
,      SUPPLIER_SHP_CALENDAR_CD
,      UNSHIP_FIRM_CUTOFF_DAYS
,      UNSHIPPED_FIRM_DISP_CD
,      USE_EDI_SDP_CODE_FLAG
,      DEMAND_TOLERANCE_ABOVE
,      DEMAND_TOLERANCE_BELOW
,      INACTIVE_DATE
,      MATCH_ACROSS_KEY
,      MATCH_WITHIN_KEY
,      HEADER_ID
,      PRICE_LIST_ID
,      CRITICAL_ATTRIBUTE_KEY
,      CUSTOMER_CONTACT_ID
,      PLN_FIRM_DAY_FROM
,      PLN_FIRM_DAY_TO
,      PLN_FORECAST_DAY_FROM
,      PLN_FORECAST_DAY_TO
,      PLN_FROZEN_DAY_TO
,      PLN_FROZEN_DAY_FROM
,      SEQ_FIRM_DAY_FROM
,      SEQ_FIRM_DAY_TO
,      SEQ_FORECAST_DAY_TO
,      SEQ_FORECAST_DAY_FROM
,      SEQ_FROZEN_DAY_FROM
,      SEQ_FROZEN_DAY_TO
,      SHP_FIRM_DAY_FROM
,      SHP_FIRM_DAY_TO
,      SHP_FROZEN_DAY_TO
,      SHP_FROZEN_DAY_FROM
,      SHP_FORECAST_DAY_TO
,      ROUND_TO_STD_PACK_FLAG
,      SUPPLIER_CONTACT_ID
,      AGREEMENT_ID
,      AGREEMENT_NAME
,      STD_PACK_QTY
,      FUTURE_AGREEMENT_ID
,      FUTURE_AGREEMENT_NAME
,      SHP_FORECAST_DAY_FROM
,      SCHEDULE_HIERARCHY_CODE
,      COMMENTS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      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
,      INTRANSIT_CALC_BASIS
,      DEFAULT_SHIP_FROM
,      PLN_FROZEN_FLAG
,      SHP_FROZEN_FLAG
,      SEQ_FROZEN_FLAG
,      ORG_ID
,      BLANKET_NUMBER
,      RELEASE_RULE
,      RELEASE_TIME_FRAME
,      RELEASE_TIME_FRAME_UOM
,      EXCLUDE_NON_WORKDAYS_FLAG
,      DISABLE_CREATE_CUM_KEY_FLAG
FROM APPS.RLM_CUST_SHIPTO_TERMS_V;

Dependencies

[top of page]

APPS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

RLM_CUST_SHIPTO_TERMS

APPS.RLM_CUST_SHIPTO_TERMS_V is not referenced by any database object