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_INTERFACE

Object Details

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

This is an interface table in which users will populate Site data for Site Import Interface Process.
Import Interface concurrent program will process rows in this table and import the primary Site information in Oracle Site Hub.
This table is used to populate data before executing Site Import Interface concurrent program.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS SITES INTERFACE
Category: OPEN_INTERFACE RRS_SITES_INTERFACE 1
Category: BUSINESS_ENTITY RRS_SITE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RRS_SITES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID PROCESS_STATUS TRANSACTION_TYPE

Columns

Name	Datatype	Length	Comments
SITE_ID	NUMBER		Used for Internal Processing. Please do not update. Internal ID of the Site generated using a sequence.
SITE_IDENTIFICATION_NUMBER	VARCHAR2	(30)	This is the Site Number of Site entered by the user. In case of Auto Defaulting Site number feature set to Yes , this column will be populated using a sequence.
SITE_NAME	VARCHAR2	(150)	This is the name of the Site entered by the user
SITE_TYPE_CODE	VARCHAR2	(30)	Type of Site. User should pass either I ( Internal ) or E ( External ).
SITE_STATUS_CODE	VARCHAR2	(30)	Status of Site. User should pass either A (Active) or I (Inactive).
SITE_USE_TYPE_CODE	VARCHAR2	(30)	Purpose of this Site. User can populate only the primary purpose for a site
IS_PRIMARY_FLAG	VARCHAR2	(1)	If Purpose populated in Site_Use_Type_Code , then this value must be Y
BRANDNAME_CODE	VARCHAR2	(30)	Brandname code for this Site entered by the user
CALENDAR_CODE	VARCHAR2	(30)	Calendar code for this Site entered by the user
LOCATION_STATUS	VARCHAR2	(1)	Status of Location attached to this Site E ( Existing ) or N ( New )
LOCATION_ID	NUMBER		Location ID of the Address linked to this Site. In case of Existing Location_Status , user should enter the Location ID. For an existing address, location_id can be queried from HZ_LOCATIONS table.
SITE_PARTY_ID	NUMBER		Party ID of the External Party linked to this Site. In case of Internal Site user should not update this field. Party_id can be queried from HZ_PARTIES table.
PARTY_SITE_ID	NUMBER		Used for Internal Processing. Please do not update. Party Site ID of the internal party linked to this Site. It will be generated internally if Site_Type is Internal and a Legal Entity Party is attached to this Site.
LE_PARTY_ID	NUMBER		Only for Internal type of Sites , user should provide the Legal Entity Party ID of the Party linked to this Site
CREATED_BY	NUMBER		Standard WHO column
CREATION_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER		Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column
ADDRESS1	VARCHAR2	(240)	Address1 value for this address entered by user. If user leaves Address1 column as blank , we will update the Address1 with Site Name.
ADDRESS2	VARCHAR2	(240)	Address2 value for this address entered by user.
ADDRESS3	VARCHAR2	(240)	Address3 value for this address entered by user.
ADDRESS4	VARCHAR2	(240)	Address4 value for this address entered by user
ADDRESS_LINES_PHONETIC	VARCHAR2	(560)	Address Lines Phonetic for this address entered by user
CITY	VARCHAR2	(60)	City for this address entered by user.
POSTAL_CODE	VARCHAR2	(60)	Postal code for this address entered by user
STATE	VARCHAR2	(60)	State for this address entered by user
PROVINCE	VARCHAR2	(60)	Province for this address entered by user
COUNTY	VARCHAR2	(60)	County for this address entered by user
COUNTRY	VARCHAR2	(60)	Country for this address entered by user
GEOMETRY_SOURCE	VARCHAR2	(30)	Geometry Source for this address entered by user. User should enter either RRS_GOOGLE or RRS_USER_ENTERED.
LONGITUDE	NUMBER		Longitude for ths address entered by user. Valid values are between -180 and 180.
LATITUDE	NUMBER		Latitude for this address entered by user. Valid values are between -90 and 90.
REQUEST_ID	NUMBER		Used for Internal Processing. Please do not update. The concurrent program request ID is populated in this column by the processing logic.
PROGRAM_APPLICATION_ID	NUMBER		Used for Internal Processing. Please do not update. The program application ID is populated in this column by the processing logic.
PROGRAM_ID	NUMBER		Used for Internal Processing. Please do not update. The concurrent program identifier is populated in this column by the processing logic.
PROGRAM_UPDATE_DATE	DATE		Used for Internal Processing. Please do not update. The program update date is populated in this column by the processing logic.
PROCESS_STATUS	VARCHAR2	(1)	Various stages of this record while undergoing validations and processing. This column can have 4 possible values. For a record to be processed, user has to set this value to 1 (Awaiting Validation). Once the processing starts , Import Interface will update value of this column to 2 (Validation Started). If the record passes the validations , value is updated to 4 (Validation Succeeeded ) and in case of error this value would be updated to 3 (Validation Failed).
TRANSACTION_TYPE	VARCHAR2	(6)	Transaction Type for this record. User should enter either CREATE or UPDATE.
BATCH_ID	NUMBER		BATCH ID to which this record is attached. Batch ID is provided by end user to process multiple site records in the Interface in one batch
BATCH_PROCESSING	VARCHAR2	(1)	Used for Internal Processing. Please do not update. It will indicate whether this record is processed as a batch ( Yes ) or not ( No )

Query Text

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


SELECT SITE_ID
,      SITE_IDENTIFICATION_NUMBER
,      SITE_NAME
,      SITE_TYPE_CODE
,      SITE_STATUS_CODE
,      SITE_USE_TYPE_CODE
,      IS_PRIMARY_FLAG
,      BRANDNAME_CODE
,      CALENDAR_CODE
,      LOCATION_STATUS
,      LOCATION_ID
,      SITE_PARTY_ID
,      PARTY_SITE_ID
,      LE_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      GEOMETRY_SOURCE
,      LONGITUDE
,      LATITUDE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      BATCH_ID
,      BATCH_PROCESSING
FROM RRS.RRS_SITES_INTERFACE;

Dependencies

[top of page]

RRS.RRS_SITES_INTERFACE does not reference any database object

RRS.RRS_SITES_INTERFACE is referenced by following:

RRS: RRS_SITES_INTERFACE#