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: TableRRS.RRS_SITES_B
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RRS_SITES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_ID
RRS_SITES_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_IDENTIFICATION_NUMBER
RRS_SITES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLE_PARTY_ID
RRS_SITES_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_PARTY_ID
RRS_SITES_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_STATUS_CODE
RRS_SITES_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnIS_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:

SchemaAPPS
SynonymRRS_SITES_B