eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OPM_CUSTOMERS

Object Details

Object Name:	OPM_CUSTOMERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.OPM_CUSTOMERS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Used for OPM customer synchronization

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ID	NUMBER			Cust Id
CUST_NO	VARCHAR2	(4000)		Cust No
ADDR_ID	NUMBER			Addr Id
CUSTSORT_NO	VARCHAR2	(30)	Yes	Custsort No
CUST_NAME	VARCHAR2	(360)	Yes	Cust Name
PHONE_NO	VARCHAR2	(4000)		Phone No
FAX_NO	VARCHAR2	(4000)		Fax No
TELEX_NO	VARCHAR2	(4000)		Telex No
ALTCUST_NO	VARCHAR2	(4000)		Altcust No
CO_CODE	VARCHAR2	(4)		Co Code
MAILADDR_ID	NUMBER			Mailaddr Id
TERMS_CODE	VARCHAR2	(4000)		Terms Code
TERMS_VARY	NUMBER			Terms Vary
FOB_CODE	VARCHAR2	(30)		Fob Code
SLSREP_CODE	VARCHAR2	(4000)		Slsrep Code
COMMISSION_CODE	VARCHAR2	(2)		Commission Code
BACKORDER_IND	NUMBER			Backorder Ind
STMT_IND	NUMBER			Stmt Ind
SVCCHG_IND	NUMBER			Svcchg Ind
INACTIVE_IND	NUMBER			Inactive Ind
BILL_IND	NUMBER			Bill Ind
SHIP_IND	NUMBER			Ship Ind
CUST_TYPE	NUMBER			Cust Type
SIC_CODE	VARCHAR2	(30)		Sic Code
FROM_WHSE	VARCHAR2	(150)		From Whse
TO_WHSE	VARCHAR2	(2)		To Whse
SPLC_CODE	VARCHAR2	(2)		Splc Code
FRTBILL_MTHD	VARCHAR2	(150)		Frtbill Mthd
CREDIT_LIMIT	NUMBER			Credit Limit
PRICECUST_ID	NUMBER			Pricecust Id
CUST_TERRITORY	VARCHAR2	(2)		Cust Territory
CUST_CURRENCY	VARCHAR2	(4000)		Cust Currency
CUST_CLASS	VARCHAR2	(30)		Cust Class
CUSTTRADE_CLASS	VARCHAR2	(2)		Custtrade Class
CUSTGL_CLASS	VARCHAR2	(150)		Custgl Class
TAXLOC_CODE	VARCHAR2	(150)		Taxloc Code
TAXCALC_CODE	VARCHAR2	(150)		Taxcalc Code
OF_CUST_ID	NUMBER	(15)	Yes	Of Cust Id
OF_SHIP_TO_ADDRESS_ID	NUMBER			Of Ship To Address Id
OF_SHIP_TO_SITE_USE_ID	NUMBER			Of Ship To Site Use Id
OF_BILL_TO_ADDRESS_ID	NUMBER			Of Bill To Address Id
OF_BILL_TO_SITE_USE_ID	NUMBER			Of Bill To Site Use Id
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER			Trans Cnt
DELETE_MARK	NUMBER			Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER			Text Code
OPEN_BALANCE	NUMBER			Open Balance
CUSTPRICE_CLASS	VARCHAR2	(150)		Custprice Class
EMAIL_ADDRESS	VARCHAR2	(2)		Email Address
LOCKBOX_CODE	VARCHAR2	(2)		Lockbox Code
EDI_FLAG	NUMBER			Edi Flag
USE_PROFILE	NUMBER			Use Profile
RESTRICT_TO_CUSTITEMS	NUMBER			Restrict To Custitems
SOCONFIRM_IND	NUMBER			Soconfirm Ind
PROGRAM_APPLICATION_ID	VARCHAR2	(2)		Concurrent Standard who column
PROGRAM_ID	VARCHAR2	(2)		Concurrent Standard who column
PROGRAM_UPDATE_DATE	VARCHAR2	(2)		Concurrent Standard who column
REQUEST_ID	VARCHAR2	(2)		Concurrent Standard who column
ATTRIBUTE1	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE16	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE25	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE26	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE27	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE28	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE29	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE30	VARCHAR2	(2)		Descriptive Flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(2)		Descriptive Flexfield segment
LOWEST_PRICE_IND	NUMBER			Lowest Price Ind
SHIP_VIA	VARCHAR2	(30)		Ship Via
ADDR1	VARCHAR2	(240)	Yes	Address
ADDR2	VARCHAR2	(240)		Address
ADDR3	VARCHAR2	(240)		Address
ADDR4	VARCHAR2	(240)		Address
ORA_ADDR4	VARCHAR2	(60)		Ora Addr4
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
STATE_CODE	VARCHAR2	(60)		State Code
POSTAL_CODE	VARCHAR2	(60)		Postal Code
COUNTRY_CODE	VARCHAR2	(60)	Yes	Country Code
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill To Site Use Id
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	Customer Number
INTERFACE_IND	NUMBER			Interface Ind
SITE_USE_CODE	VARCHAR2	(30)	Yes	Site Use Code

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
,      OF_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
,      SHIP_VIA
,      ADDR1
,      ADDR2
,      ADDR3
,      ADDR4
,      ORA_ADDR4
,      PROVINCE
,      COUNTY
,      STATE_CODE
,      POSTAL_CODE
,      COUNTRY_CODE
,      BILL_TO_SITE_USE_ID
,      CUSTOMER_NUMBER
,      INTERFACE_IND
,      SITE_USE_CODE
FROM APPS.OPM_CUSTOMERS;

Dependencies

[top of page]

APPS.OPM_CUSTOMERS references the following:

APPS: FND_PROFILE - show dependent code; GL_PLCY_MST; GMF_AR_CUSTOMER - show dependent code; GML_INVALID_CUSTOMERS; HZ_CUSTOMER_PROFILES; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.OPM_CUSTOMERS is referenced by following:

APPS: GMF_CUSTOMER_SYNC - show dependent code; GMF_CUSTOMER_SYNC - show dependent code