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_SITE_USES_ALL

Object Details

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

View Type

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

OPM site uses view

[View Source]

Columns

Name	Datatype	Length	Comments
SITE_USE_ID	VARCHAR2	(0)	Site Use Id
LAST_UPDATE_DATE	VARCHAR2	(0)	Standard who column
LAST_UPDATED_BY	VARCHAR2	(0)	Standard who column
CREATION_DATE	VARCHAR2	(0)	Standard who column
CREATED_BY	VARCHAR2	(0)	Standard who column
SITE_USE_CODE	VARCHAR2	(0)	Site Use Code
ADDRESS_ID	VARCHAR2	(0)	Address Id
PRIMARY_FLAG	VARCHAR2	(0)	Primary Flag
STATUS	VARCHAR2	(0)	Status
LOCATION	VARCHAR2	(0)	Location
LAST_UPDATE_LOGIN	VARCHAR2	(0)	Standard who column
CONTACT_ID	VARCHAR2	(0)	Contact Id
BILL_TO_SITE_USE_ID	VARCHAR2	(0)	Bill To Site Use Id
ORIG_SYSTEM_REFERENCE	VARCHAR2	(0)	Orig System Reference
SIC_CODE	VARCHAR2	(0)	Sic Code
PAYMENT_TERM_ID	VARCHAR2	(0)	Payment Term Id
GSA_INDICATOR	VARCHAR2	(0)	Gsa Indicator
SHIP_PARTIAL	VARCHAR2	(0)	Ship Partial
SHIP_VIA	VARCHAR2	(0)	Ship Via
FOB_POINT	VARCHAR2	(0)	Fob Point
ORDER_TYPE_ID	VARCHAR2	(0)	Order Type Id
PRICE_LIST_ID	VARCHAR2	(0)	Price List Id
FREIGHT_TERM	VARCHAR2	(0)	Freight Term
WAREHOUSE_ID	VARCHAR2	(0)	Warehouse Id
TERRITORY_ID	VARCHAR2	(0)	Territory Id
ATTRIBUTE_CATEGORY	VARCHAR2	(0)	Attribute Category
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
REQUEST_ID	VARCHAR2	(0)	Concurrent Standard who column
PROGRAM_APPLICATION_ID	VARCHAR2	(0)	Concurrent Standard who column
PROGRAM_ID	VARCHAR2	(0)	Concurrent Standard who column
PROGRAM_UPDATE_DATE	VARCHAR2	(0)	Concurrent Standard who column
TAX_REFERENCE	VARCHAR2	(0)	Tax Reference
SORT_PRIORITY	VARCHAR2	(0)	Sort Priority
TAX_CODE	VARCHAR2	(0)	Tax Code
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
LAST_ACCRUE_CHARGE_DATE	VARCHAR2	(0)	Last Accrue Charge Date
SECOND_LAST_ACCRUE_CHARGE_DATE	VARCHAR2	(0)	Second Last Accrue Charge Date
LAST_UNACCRUE_CHARGE_DATE	VARCHAR2	(0)	Last Unaccrue Charge Date
SECOND_LAST_UNACCRUE_CHRG_DATE	VARCHAR2	(0)	Second Last Unaccrue Chrg Date
DEMAND_CLASS_CODE	VARCHAR2	(0)	Demand Class Code
TAX_EXEMPT	VARCHAR2	(0)	Tax Exempt
TAX_EXEMPT_NUM	VARCHAR2	(0)	Tax Exempt Num
TAX_EXEMPT_REASON_CODE	VARCHAR2	(0)	Tax Exempt Reason Code
ORG_ID	VARCHAR2	(0)	Org Id
TAX_CLASSIFICATION	VARCHAR2	(0)	Tax Classification
TAX_HEADER_LEVEL_FLAG	VARCHAR2	(0)	Tax Header Level Flag
TAX_ROUNDING_RULE	VARCHAR2	(0)	Tax Rounding Rule
WH_UPDATE_DATE	VARCHAR2	(0)	Wh Update Date
GLOBAL_ATTRIBUTE1	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE2	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE3	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE4	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE5	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE6	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE7	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE8	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE9	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE10	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE11	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE12	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE13	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE14	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE15	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE16	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE17	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE18	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE19	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE20	VARCHAR2	(0)	Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(0)	Global Attribute Category
PRIMARY_SALESREP_ID	VARCHAR2	(0)	Primary Salesrep Id
CUSTOMER_ID	VARCHAR2	(0)	Customer Id

Query Text

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


SELECT SITE_USE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      SITE_USE_CODE
,      ADDRESS_ID
,      PRIMARY_FLAG
,      STATUS
,      LOCATION
,      LAST_UPDATE_LOGIN
,      CONTACT_ID
,      BILL_TO_SITE_USE_ID
,      ORIG_SYSTEM_REFERENCE
,      SIC_CODE
,      PAYMENT_TERM_ID
,      GSA_INDICATOR
,      SHIP_PARTIAL
,      SHIP_VIA
,      FOB_POINT
,      ORDER_TYPE_ID
,      PRICE_LIST_ID
,      FREIGHT_TERM
,      WAREHOUSE_ID
,      TERRITORY_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TAX_REFERENCE
,      SORT_PRIORITY
,      TAX_CODE
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      LAST_ACCRUE_CHARGE_DATE
,      SECOND_LAST_ACCRUE_CHARGE_DATE
,      LAST_UNACCRUE_CHARGE_DATE
,      SECOND_LAST_UNACCRUE_CHRG_DATE
,      DEMAND_CLASS_CODE
,      TAX_EXEMPT
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      ORG_ID
,      TAX_CLASSIFICATION
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      WH_UPDATE_DATE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      PRIMARY_SALESREP_ID
,      CUSTOMER_ID
FROM APPS.OPM_SITE_USES_ALL;

Dependencies

[top of page]

APPS.OPM_SITE_USES_ALL references the following:

PUBLIC: DUAL

APPS.OPM_SITE_USES_ALL is not referenced by any database object