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: RRS.RRS_SITES_B

Object Details

Object Name:	RRS_SITES_B
Object Type:	TABLE
Owner:	RRS
FND Design Data:	RRS.RRS_SITES_B
Subobject Name:
Status:	VALID

This table is used to store the basic information about sites.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RRS_SITES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SITE_ID
RRS_SITES_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SITE_IDENTIFICATION_NUMBER
RRS_SITES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LE_PARTY_ID
RRS_SITES_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SITE_PARTY_ID
RRS_SITES_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SITE_STATUS_CODE
RRS_SITES_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IS_TEMPLATE_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
SITE_ID	NUMBER		Yes	System generated number which uniquely identifies the site.
SITE_IDENTIFICATION_NUMBER	VARCHAR2	(30)	Yes	User entered unique identification number for site.
SITE_TYPE_CODE	VARCHAR2	(30)	Yes	Indicates type of Site. Possible values I for Internal and E for External.
SITE_STATUS_CODE	VARCHAR2	(30)	Yes	Indicates Site Status. Possible values A for Active and I for Inactive.
BRANDNAME_CODE	VARCHAR2	(30)		Brandname associated to the site.
CALENDAR_CODE	VARCHAR2	(30)		Calendar assigned to the site.
LOCATION_ID	NUMBER			System generated number which identifies primary address of the site. Foreign key to HZ_LOCATIONS
SITE_PARTY_ID	NUMBER			System generated number indicates the establishment associated with the site. Foreign key to HZ_PARTIES.
PARTY_SITE_ID	NUMBER			System generated number which identifies the party site created for the site. Foreign key to HZ_PARTY_SITES.
LE_PARTY_ID	NUMBER			Indicates the party id of the legal entity associated to the site. Foreign key to HZ_PARTIES
PROPERTY_LOCATION_ID	NUMBER			System generated number which identifies the location created in Oracle propert Management. Foreign key PN_LOCATIONS_ALL.
TEMPLATE_COUNTRY	VARCHAR2	(30)		Identifies the template owning country associated with Site Template.
START_DATE	DATE			Active start date of site template
END_DATE	DATE			Date after which site template is inactive.
IS_TEMPLATE_FLAG	VARCHAR2	(1)		Flag to identify whether the its a site or site template.
OBJECT_VERSION_NUMBER	NUMBER			Sequence number for lock strategy in self-service applications
CREATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns
ORGANIZATION_ID	NUMBER			Organization assigned to Site

Query Text

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


SELECT SITE_ID
,      SITE_IDENTIFICATION_NUMBER
,      SITE_TYPE_CODE
,      SITE_STATUS_CODE
,      BRANDNAME_CODE
,      CALENDAR_CODE
,      LOCATION_ID
,      SITE_PARTY_ID
,      PARTY_SITE_ID
,      LE_PARTY_ID
,      PROPERTY_LOCATION_ID
,      TEMPLATE_COUNTRY
,      START_DATE
,      END_DATE
,      IS_TEMPLATE_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
FROM RRS.RRS_SITES_B;

Dependencies

[top of page]

RRS.RRS_SITES_B does not reference any database object

RRS.RRS_SITES_B is referenced by following:

RRS: RRS_SITES_B#