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


VIEW: APPS.OP_CUST_MST_V

Object Details
Object Name: OP_CUST_MST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.OP_CUST_MST_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

MultiLingual view (a language resolved view of the data.)


View of op_cust_mst for OPM OF customers


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_ID NUMBER (15) Yes identifier for a customer master record
CUST_NO VARCHAR2 (4000)
identifier of a customer
ADDR_ID NUMBER (15) Yes Surrogate ID uniquely identifying an adress
CUSTSORT_NO VARCHAR2 (30) Yes Customer sort number. Used to sort customers for lookups and other purposes.
CUST_NAME VARCHAR2 (40)
Customer name
PHONE_NO VARCHAR2 (0)
Customer phone number.
FAX_NO VARCHAR2 (0)
Customer fax number.
TELEX_NO VARCHAR2 (0)
Customer telex number.
ALTCUST_NO VARCHAR2 (0)
Alternate customer number. Not validated, for customer use.
CO_CODE VARCHAR2 (4) Yes Company for which the customer number is defined. A NULL value indicates the customer is defined for all companies.
MAILADDR_ID NUMBER

Pointer to sy_addr_mst which holds the mailing address. This address is used for invoicing and billing purposes.
TERMS_CODE VARCHAR2 (0)
Default payment terms code for customer.
TERMS_VARY VARCHAR2 (0)
Indicates if terms code can vary for this customer on an order. 0 means that the terms code can not be changed on an order; 1 means that the terms code can be changed.
FOB_CODE VARCHAR2 (0)
Default fob code for this customer.
SLSREP_CODE VARCHAR2 (0)
Default sales rep for this customer.
COMMISSION_CODE VARCHAR2 (0)
Default commission code for this customer. Indicates commission group.
BACKORDER_IND VARCHAR2 (0)
Indicates if the customer accepts backorders. Value of 0 means that the customer does not accept backorders (i.e., if the entire order qty can not be shipped, then the remaining qty is not backordered). Value of 1 means that the customer
STMT_IND NUMBER

For future use: indicates if the customer is sent a statement. Value of 0 means that the customer is not sent a statement; value of 1 means that the customer is sent a monthly statement.
SVCCHG_IND NUMBER

For future use; indicates if the customer is charged a service charge for overdue payments. Value of 0 means that the customer is not charged a service charge; value of 1 means that the customer is charged a service charge for overdue pay
INACTIVE_IND NUMBER

Indicates whether a customer is active or not. Value of 0 means that the customer is active; a value of 1 means that the customer is inactive. Defaults to 0.
BILL_IND NUMBER

Indicates whether the customer is a bill-to. Value of 0 means that the customer is not a bill-to customer; value of 1 means that the customer is a bill-to customer.
SHIP_IND NUMBER

Indicates whether a customer is a ship-to customer. A value of 0 means that the customer is not a ship-to customer; a value of 1 means that the customer is a ship-to customer
CUST_TYPE VARCHAR2 (0)
Designates the type of customer. Valid values are: 0 means "normal" customer 1 means consignment customer 2 means transfer/interplant customer
SIC_CODE VARCHAR2 (0)
Unvalidated field which can hold the u.s. standard industry code.
FROM_WHSE VARCHAR2 (0)
Default warehouse where shipments will originate for this customer.
TO_WHSE VARCHAR2 (0)
Default receiving warehouse for this customer. For use with consignment and transfer customers only.
SPLC_CODE VARCHAR2 (0)
Unvalidated field which can contain the standard point location code used in the u.s. for freight and shipping purposes.
FRTBILL_MTHD VARCHAR2 (0)
Default freight bill method for this customer
CREDIT_LIMIT VARCHAR2 (0)
Customer credit limit
PRICECUST_ID VARCHAR2 (0)
Contains the customer id of the customer to be used for customer-specific pricing.
CUST_TERRITORY VARCHAR2 (0)
Customer territory; unvalidated field.
CUST_CURRENCY VARCHAR2 (0)
Billing currency of the customer.
CUST_CLASS VARCHAR2 (0)
Customer class.
CUSTTRADE_CLASS VARCHAR2 (0)
Customer trade class .
CUSTGL_CLASS VARCHAR2 (150)
Customer gl class used for gl mapping; reference to op_cgld_cls.
TAXLOC_CODE VARCHAR2 (0)
Tax location code of customer; reference to tx_tloc_cds.
TAXCALC_CODE VARCHAR2 (0)
Tax calculation code for customer to specify special tax calculation flags for this customer; reference to tx_calc_mst.
OPM_CUST_ID NUMBER (15) Yes Field to hold cust_id from op_cust_mst_opm
OF_SHIP_TO_ADDRESS_ID NUMBER

Surrogate from Oracle Financials identifying the customer address.
OF_SHIP_TO_SITE_USE_ID NUMBER

Surrogate from Oracle Financials identifying the customer location.
OF_BILL_TO_ADDRESS_ID NUMBER

Surrogate from Oracle Financials identifying the customer bill to address.
OF_BILL_TO_SITE_USE_ID NUMBER

Surrogate from Oracle Financials identifying the customer bill to site use id.
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TRANS_CNT VARCHAR2 (0)
Not currently used
DELETE_MARK NUMBER

Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE VARCHAR2 (0)
ID which joins any rows of text in this table to the Text Table for this Module
OPEN_BALANCE VARCHAR2 (0)
Contains current open order balance (value of unshipped orders). This amount is updated during order entry and shipping for use in credit checking under oracle financials. Balance is incremented for new open orders and decremented when an
CUSTPRICE_CLASS VARCHAR2 (0)
Class to group customers for pricing purposes. Used in pricing tables. reference to op_cprc_cls.
EMAIL_ADDRESS VARCHAR2 (0)
Freeform text to store email address for customer.
LOCKBOX_CODE VARCHAR2 (0)
Default lockbox code where customer remits payment. reference to op_lkbx_mst.
EDI_FLAG VARCHAR2 (0)
For future use; identifies if customer uses edi.
USE_PROFILE VARCHAR2 (0)
Indicates if order profile should be used to create orders for customer. Values are: 0 means that order profile is not used automatically when an order is taken for the customer 1 means that the order profile is automatically copied in wh
RESTRICT_TO_CUSTITEMS VARCHAR2 (0)
Indicates if customer can order items which are not defined in the customer-item table. Value of 1 means that only items defined in the customer-item table can be ordered by this customer. Value of 0 means that any items can be ordered b
SOCONFIRM_IND VARCHAR2 (0)
Indicates if customer requires a sales order confirmation. Value of 0 means that no confirmation is required; value of 1 means that a sales order confirmation must be sent. Indicator will be used in the future
PROGRAM_APPLICATION_ID VARCHAR2 (0)
Concurrent who column
PROGRAM_ID VARCHAR2 (0)
Concurrent who column
PROGRAM_UPDATE_DATE VARCHAR2 (0)
Concurrent who column
REQUEST_ID VARCHAR2 (0)
Concurrent who column
ATTRIBUTE1 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (0)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (0)
Descriptive flexfield segment
LOWEST_PRICE_IND VARCHAR2 (0)
Value of 0 (zero) means that normal pricing rules are in effect; value of 1 (one) means that pricing of an order for this customer will select the lowest price from effective pricelists established for this customer.
PO_REQUIRED VARCHAR2 (0)
Option which allows bill-to customers to require entry of a PO Number in any sales order created against them. 1 -require a customer PO , 0 or NULL- do not require a customer PO on orders
OF_CUST_ID NUMBER (15) Yes Surrogate from Oracle Financials identifying the customer.
ORG_ID NUMBER (15)
Identifier for Operating Unit
Query Text

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


SELECT CUST_ID
,      CUST_NO
,      ADDR_ID
,      CUSTSORT_NO
,      CUST_NAME
,      PHONE_NO
,      FAX_NO
,      TELEX_NO
,      ALTCUST_NO
,      CO_CODE
,      MAILADDR_ID
,      TERMS_CODE
,      TERMS_VARY
,      FOB_CODE
,      SLSREP_CODE
,      COMMISSION_CODE
,      BACKORDER_IND
,      STMT_IND
,      SVCCHG_IND
,      INACTIVE_IND
,      BILL_IND
,      SHIP_IND
,      CUST_TYPE
,      SIC_CODE
,      FROM_WHSE
,      TO_WHSE
,      SPLC_CODE
,      FRTBILL_MTHD
,      CREDIT_LIMIT
,      PRICECUST_ID
,      CUST_TERRITORY
,      CUST_CURRENCY
,      CUST_CLASS
,      CUSTTRADE_CLASS
,      CUSTGL_CLASS
,      TAXLOC_CODE
,      TAXCALC_CODE
,      OPM_CUST_ID
,      OF_SHIP_TO_ADDRESS_ID
,      OF_SHIP_TO_SITE_USE_ID
,      OF_BILL_TO_ADDRESS_ID
,      OF_BILL_TO_SITE_USE_ID
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      OPEN_BALANCE
,      CUSTPRICE_CLASS
,      EMAIL_ADDRESS
,      LOCKBOX_CODE
,      EDI_FLAG
,      USE_PROFILE
,      RESTRICT_TO_CUSTITEMS
,      SOCONFIRM_IND
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      LOWEST_PRICE_IND
,      PO_REQUIRED
,      OF_CUST_ID
,      ORG_ID
FROM APPS.OP_CUST_MST_V;

Dependencies

[top of page]

APPS.OP_CUST_MST_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_PLCY_MST
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
APPS.OP_CUST_MST_V is referenced by following:

SchemaAPPS
Package BodyGML_UPDATE_CUST_DATA_PVT - show dependent code
SynonymOP_CUST_MST