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]

TABLE: AR.RA_SITE_USES_ALL

Object Details

Object Name:	RA_SITE_USES_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.RA_SITE_USES_ALL
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_SITE_USES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SITE_USE_ID
RA_SITE_USES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID SITE_USE_CODE PRIMARY_FLAG
RA_SITE_USES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SITE_USE_ID	NUMBER	(15)	Yes	Site use identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SITE_USE_CODE	VARCHAR2	(30)	Yes	Business Purpose
ADDRESS_ID	NUMBER	(15)	Yes	Address identifier
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether site is primary
STATUS	VARCHAR2	(1)	Yes	Site use status flag; lookup code for 'CODE_STATUS'
LOCATION	VARCHAR2	(40)	Yes	Site use identifier
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CONTACT_ID	NUMBER	(15)		Contact identifier
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill to site use identifier
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Site use identifier from foreign system
SIC_CODE	VARCHAR2	(30)		Standard Industry Classification code
PAYMENT_TERM_ID	NUMBER	(15)		Payment term identifier
GSA_INDICATOR	VARCHAR2	(1)		Flag to indicate whether this site is a public sector (Gov.) Service Agency
SHIP_PARTIAL	VARCHAR2	(1)		Flag to indicate whether partial shipments are sent to this site
SHIP_VIA	VARCHAR2	(25)		Name of shipping firm
FOB_POINT	VARCHAR2	(30)		Group responsible for the freight
ORDER_TYPE_ID	NUMBER	(15)		Order type identifier
PRICE_LIST_ID	NUMBER	(15)		Price List identifier
FREIGHT_TERM	VARCHAR2	(30)		Order Entry lookup code for FREIGHT_TERMS
WAREHOUSE_ID	NUMBER	(15)		Warehouse identifier
TERRITORY_ID	NUMBER	(15)		Territory identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
TAX_REFERENCE	VARCHAR2	(50)		Taxpayer identification number
SORT_PRIORITY	NUMBER	(5)		Sort priority
TAX_CODE	VARCHAR2	(50)		Tax code associated with this site
TAX_CLASSIFICATION	VARCHAR2	(30)		Controls the classification of the bill to site. Using this field you can control which codes are used out of a tax group. Foreign key into ar_lookups (AR_TAX_CLASSIFICATION) used in ar_vat_tax (TAX_CLASSIFICATION).
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column
LAST_ACCRUE_CHARGE_DATE	DATE			This is the last date for which accrued finance charges were calculated for this site.
SECOND_LAST_ACCRUE_CHARGE_DATE	DATE			This is the second to the last date for which accrued finance charges were calculated for this site.
LAST_UNACCRUE_CHARGE_DATE	DATE			This is the last date for which unaccrued finance charges were calculated for this site.
SECOND_LAST_UNACCRUE_CHRG_DATE	DATE			This is the second to the last date for which unaccrued finance charges were calculated for this site.
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class (user-defined Lookup used by Oracle Manufacturing)
TAX_EXEMPT	VARCHAR2	(1)		No longer used
TAX_EXEMPT_NUM	VARCHAR2	(30)		No longer used
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		No longer used
ORG_ID	NUMBER	(15)		Organization identifier
TAX_HEADER_LEVEL_FLAG	VARCHAR2	(1)		Used By Oracle Sales Compensation
TAX_ROUNDING_RULE	VARCHAR2	(30)		Tax Rounding Rule: Override System and Customer Tax Rounding Rule
WH_UPDATE_DATE	DATE			Date Sent to Data Warehouse
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved For Globalization Functionality
PRIMARY_SALESREP_ID	NUMBER	(15)		Identifies a salesperson associated with a business site; this would also be used to default salesrep in the Transactions window. The hierarchy of defaulting would follow from Bill To - Ship To - Customer (if not a multi-org setup).
FINCHRG_RECEIVABLES_TRX_ID	NUMBER	(15)		Foreign key to AR_RECEIVABLES_TRX. Indicates the Receivables Activity to use to account for tax on finance charges.
GL_ID_REC	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_REV	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_TAX	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_FREIGHT	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_CLEARING	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_UNBILLED	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_UNEARNED	NUMBER	(15)		Code combination ID for the Receivable Account
DATES_NEGATIVE_TOLERANCE	NUMBER			Negative tolerance for acceptable dates
DATES_POSITIVE_TOLERANCE	NUMBER			Positive tolerance for acceptable dates
DATE_TYPE_PREFERENCE	VARCHAR2	(20)		Preference for ship or arrival dates
OVER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for over shipment
UNDER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for under shipment
ITEM_CROSS_REF_PREF	VARCHAR2	(30)		Lookup for item cross reference preference for placing orders
OVER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for over return
UNDER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for under return
SHIP_SETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Y if lines should automatically be included in ship sets
ARRIVALSETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Y if lines should automatically be included in arrival sets
SCHED_DATE_PUSH_FLAG	VARCHAR2	(1)		Y if group schedule date should automatically be pushed
INVOICE_QUANTITY_RULE	VARCHAR2	(30)		Rule to indicate whether to invoice for ordered quantity or fulfilled quantity
PRICING_EVENT	VARCHAR2	(30)		Event at which to price orders. For example, at entry, at shipping, or at invoicing.

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
,      TAX_CLASSIFICATION
,      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_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
,      FINCHRG_RECEIVABLES_TRX_ID
,      GL_ID_REC
,      GL_ID_REV
,      GL_ID_TAX
,      GL_ID_FREIGHT
,      GL_ID_CLEARING
,      GL_ID_UNBILLED
,      GL_ID_UNEARNED
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      ITEM_CROSS_REF_PREF
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      SHIP_SETS_INCLUDE_LINES_FLAG
,      ARRIVALSETS_INCLUDE_LINES_FLAG
,      SCHED_DATE_PUSH_FLAG
,      INVOICE_QUANTITY_RULE
,      PRICING_EVENT
FROM AR.RA_SITE_USES_ALL;

Dependencies

[top of page]

AR.RA_SITE_USES_ALL does not reference any database object

AR.RA_SITE_USES_ALL is referenced by following:

APPS: RA_SITE_USES_ALL