[Home] [Help] [Dependency Information]
Object Name: | OPM_SITE_USES_ALL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMF.OPM_SITE_USES_ALL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
OPM site uses view
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.OPM_SITE_USES_ALL is not referenced by any database object
|
|
|