This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | This table stores the Trade Area Group and radii information of Radii/ Donut shapeTrade Areas. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_GROUP_TRADE_AREAS.GROUP_ID | RRS_TRADE_AREA_GROUPS_B |
This table stores the Trade Area Group and radii information of Radii/ Donut shapeTrade Areas.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_GROUP_TRADE_AREAS_U1 | UNIQUE | APPS_TS_TX_IDX |
GROUP_ID
TRADE_AREA_NUMBER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRADE_AREA_NUMBER_CODE | VARCHAR2 | (30) | Y | The Trade Area Number. |
GROUP_ID | NUMBER | Y | The identifier for the Trade Area Group | |
INNER_BOUND | NUMBER | Y | The inner bound (radius/time) for the Trade Area geometry | |
OUTER_BOUND | NUMBER | Y | The outer bound (radius/time) for the Trade Area geometry | |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
RRS.RRS_GROUP_TRADE_AREAS does not reference any database object
RRS.RRS_GROUP_TRADE_AREAS is referenced by following:
Description: | This table stores the User Defined Attributes values associated with Hierarchy. |
---|
This table stores the User Defined Attributes values associated with Hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_HIERARCHIES_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
RRS_HIERARCHIES_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_VERSION_ID
ATTR_GROUP_ID |
RRS_HIERARCHIES_EXT_B_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
HIERARCHY_PURPOSE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
SITE_GROUP_VERSION_ID | NUMBER | Y | Identifies the specific version of the Cluster / Hierarchy. | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Site Entity for User Defined Attributes | |
HIERARCHY_PURPOSE_CODE | VARCHAR2 | (30) | Y | Use/Purpose for the Hierarchy. |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
C_EXT_ATTR1 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR1 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR2 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR3 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR4 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR5 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR6 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR7 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR8 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR9 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR10 | NUMBER | Numeric Column for Attribute Value | ||
D_EXT_ATTR1 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR2 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR3 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR4 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR5 | DATE | Date Column for Attribute Value | ||
C_EXT_ATTR21 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR31 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR32 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR33 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR34 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR35 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR36 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR37 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR38 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR39 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR40 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR11 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR12 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR13 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR14 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR15 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR16 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR17 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR18 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR19 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR20 | NUMBER | Numeric Column for Attribute Value | ||
UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM Column for Attributes | |
D_EXT_ATTR6 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR7 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR8 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR9 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR10 | DATE | Date Column for Attribute Value | ||
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. |
RRS.RRS_HIERARCHIES_EXT_B does not reference any database object
RRS.RRS_HIERARCHIES_EXT_B is referenced by following:
Description: | This table stores the translated User Defined Attributes values associated with Hierarchies in multiple languages |
---|
This table stores the translated User Defined Attributes values associated with Hierarchies in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_HIERARCHIES_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
EXTENSION_ID
LANGUAGE |
RRS_HIERARCHIES_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_VERSION_ID
ATTR_GROUP_ID LANGUAGE |
RRS_HIERARCHIES_EXT_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
HIERARCHY_PURPOSE_CODE
ATTR_GROUP_ID LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Site Entity for User Defined Attributes | |
SITE_GROUP_VERSION_ID | NUMBER | Y | Site Group version ID for which Attribute Values are assigned | |
HIERARCHY_PURPOSE_CODE | VARCHAR2 | (30) | Y | Use/Purpose for the Hierarchy |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installed base Language |
LANGUAGE | VARCHAR2 | (4) | Y | The language of translation |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
CREATION_DATE | DATE | Standard WHO column | ||
TL_EXT_ATTR1 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR2 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR3 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR4 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR5 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR6 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR7 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR8 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR9 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR10 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR11 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR12 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR13 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR14 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR15 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR16 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR17 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR18 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR19 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR20 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR21 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR22 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR23 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR24 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR25 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR26 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR27 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR28 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR29 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR30 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR31 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR32 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR33 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR34 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR35 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR36 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR37 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR38 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR39 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR40 | VARCHAR2 | (1000) | Character Column for translated Attribute Value |
RRS.RRS_HIERARCHIES_EXT_TL does not reference any database object
RRS.RRS_HIERARCHIES_EXT_TL is referenced by following:
Description: | This table will store the Errored rows found during the Import Interface process |
---|
This table stores all the errors found during the validation of rows during Site Import Interface process. User should never update the data in this table. This table should be used only as a reference to identify the errors.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS INTERFACE ERRORS
Category: OPEN_INTERFACE RRS_INTERFACE_ERRORS 1
Category: BUSINESS_ENTITY RRS_SITE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_ID | NUMBER | Internal identifier of the Site for which error occured. | ||
SITE_IDENTIFICATION_NUMBER | VARCHAR2 | (30) | Site Identification Number of the Site for which error occurred. | |
COLUMN_NAME | VARCHAR2 | (30) | Name of the column on which validation failed. | |
MESSAGE_NAME | VARCHAR2 | (30) | Internal Name of Error Message. | |
MESSAGE_TYPE | VARCHAR2 | (1) | Type of Error Message. Valid Values are C ( Critical ) or W ( Warning ) | |
MESSAGE_TEXT | VARCHAR2 | (1000) | Complete text of Error Message | |
SOURCE_TABLE_NAME | VARCHAR2 | (30) | Name of the source table on which this validation failed. | |
DESTINATION_TABLE_NAME | VARCHAR2 | (30) | Name of the destination table where the column value will be populated in Oracle Site Hub. | |
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 | ||
REQUEST_ID | NUMBER | The concurrent program request ID is populated in this column by the processing logic. | ||
PROGRAM_APPLICATION_ID | NUMBER | The program application ID is populated in this column by the processing logic. | ||
PROGRAM_ID | NUMBER | The concurrent program identifier is populated in this column by the processing logic. | ||
PROGRAM_UPDATE_DATE | DATE | The program update date is populated in this column by the processing logic. | ||
PROCESS_STATUS | VARCHAR2 | (1) | This value will be 3 (Validation Failed) in most of the cases. | |
TRANSACTION_TYPE | VARCHAR2 | (6) | Transaction Type for this record. The CREATE or UPDATE values are copied from the source table, identifying the mode of processing for the errored record. | |
BATCH_ID | NUMBER | BATCH ID is copied from the source table to which this errored record is attached. |
RRS.RRS_INTERFACE_ERRORS does not reference any database object
RRS.RRS_INTERFACE_ERRORS is referenced by following:
Description: | This table stores the User Defined Attributes values associated with Locations. |
---|
This table stores the User Defined Attributes values associated with Locations.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_LOCATIONS_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
RRS_LOCATIONS_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
ATTR_GROUP_ID |
RRS_LOCATIONS_EXT_B_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
COUNTRY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Location Entity for User Defined Attributes | |
LOCATION_ID | NUMBER | Y | Location Identification number for which Attribute Values are assigned | |
COUNTRY | VARCHAR2 | (60) | Y | Country of Location |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
C_EXT_ATTR1 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR1 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR2 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR3 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR4 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR5 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR6 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR7 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR8 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR9 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR10 | NUMBER | Numeric Column for Attribute Value | ||
D_EXT_ATTR1 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR2 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR3 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR4 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR5 | DATE | Date Column for Attribute Value | ||
C_EXT_ATTR21 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR31 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR32 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR33 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR34 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR35 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR36 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR37 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR38 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR39 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR40 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR11 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR12 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR13 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR14 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR15 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR16 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR17 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR18 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR19 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR20 | NUMBER | Numeric Column for Attribute Value | ||
UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM Column for Attributes | |
D_EXT_ATTR6 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR7 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR8 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR9 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR10 | DATE | Date Column for Attribute Value | ||
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. |
RRS.RRS_LOCATIONS_EXT_B does not reference any database object
RRS.RRS_LOCATIONS_EXT_B is referenced by following:
Description: | This table stores the translated User Defined Attributes values associated with Locations in multiple languages |
---|
This table stores the translated User Defined Attributes values associated with Locations in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_LOCATIONS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
EXTENSION_ID
LANGUAGE |
RRS_LOCATIONS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
LANGUAGE |
RRS_LOCATIONS_EXT_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
COUNTRY LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Location Entity for User Defined Attributes | |
LOCATION_ID | NUMBER | Y | Location Identification number for which Attribute Values are assigned | |
COUNTRY | VARCHAR2 | (60) | Y | Country of Location |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installed base Language |
LANGUAGE | VARCHAR2 | (4) | Y | The language of translation |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
CREATION_DATE | DATE | Standard WHO column | ||
TL_EXT_ATTR1 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR2 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR3 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR4 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR5 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR6 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR7 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR8 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR9 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR10 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR11 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR12 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR13 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR14 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR15 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR16 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR17 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR18 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR19 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR20 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR21 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR22 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR23 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR24 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR25 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR26 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR27 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR28 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR29 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR30 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR31 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR32 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR33 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR34 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR35 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR36 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR37 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR38 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR39 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR40 | VARCHAR2 | (1000) | Character Column for translated Attribute Value |
RRS.RRS_LOCATIONS_EXT_TL does not reference any database object
RRS.RRS_LOCATIONS_EXT_TL is referenced by following:
Description: | This table is for internal use and it is used for webADI integration. |
---|
This is an interface table used to import Location specific User Defined Attribute data. The interface is commonly used by Excel import and import using PL/SQL import interface. For Excel Import process, user should not update this table. The data only needs to be populated for the PL/SQL based import process.
For PL/SQL based import method, Site Import Interface Program will process rows in this table and import the data in Oracle Site Hub. It is expected that users would populate the data before submitting the import process.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS LOCATION UA INTF
Category: OPEN_INTERFACE RRS_LOCATION_UA_INTF 1
Category: BUSINESS_ENTITY RRS_SITE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Uniquely identifies each record in this table. | ||
DATA_LEVEL_ID | NUMBER | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 71801 during data processing. | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'LOCATION_LEVEL' during data processing. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | Used for Internal Processing. Please do not update. | |
PROCESS_STATUS | VARCHAR2 | (15) | 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). | |
DATA_SET_ID | NUMBER | Used for Internal Processing. Please do not update. An identifier for the collection of rows to be processed together. | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. This column should be populated very carefully. For all attributes of a Single Row Attribute Group, a common and unique value should be used. For all attributes of a Multi-Row Attribute Group row, a common and unique value should be used. The value used, should not be repeated for any other Single Row or Multi-Row Attribute Group row in a batch. | ||
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Internal name of the User Defined Attribute Group to which attributes are attached. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Internal name of the attribute. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group and it's attributes. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | User Defined Attribute value of type VARCHAR. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_NUM and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | |
ATTR_VALUE_NUM | NUMBER | User Defined Attribute value of type NUMBER. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_VALUE_DATE | DATE | User Defined Attribute value of type DATE. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_NUM should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Display Value of the Attributes. For Value Set based attributes, display value can be different from the value actually stored in the database. Enter the Display Value, sometimes also known as the Meaning of the Value Set, in this field. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type for this record. Valid values are CREATE or UPDATE. | |
LOCATION_ID | VARCHAR2 | (150) | Internal identifier of the Location for which User Defined Attribute data is to be uploaded. User can query the Location_id from RRS_SITES_VL. Ensure that this value is correctly populated for successful processing. | |
ATTR_GROUP_ID | NUMBER | Internal identifier of User Defined Attribute Group to which attributes are attached. User can query this from ego_obj_ag_assocs_b. | ||
COUNTRY | VARCHAR2 | (150) | This is the Country of Primary Address. Eg. United States, Norway | |
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. | ||
CREATED_BY | NUMBER | Standard who columns. | ||
CREATION_DATE | DATE | Standard who columns. | ||
LAST_UPDATED_BY | NUMBER | Standard who columns. | ||
LAST_UPDATE_DATE | DATE | Standard who columns. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who columns. | ||
ATTR_GROUP_TYPE | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'RRS_LOCATION_GROUP' during data processing. | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with an attribute of data type NUMBER. User can query this value from UNIT_OF_MEASURE column of MTL_UNITS_OF_MEASURE table. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with the attribute of data type NUMBER. User can query this value from UOM_CODE column of MTL_UNITS_OF_MEASURE table. | |
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 table in one batch |
RRS.RRS_LOCATION_UA_INTF does not reference any database object
RRS.RRS_LOCATION_UA_INTF is referenced by following:
Description: | This table stores the association between Trade Area Groups and Locations |
---|
This table stores the association between Trade Area Groups and Locations
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_LOC_TRADE_AREA_GRPS_U1 | UNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
GROUP_ID |
RRS_LOC_TRADE_AREA_GRPS_N1 | NONUNIQUE | APPS_TS_TX_IDX | GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Y | The identifier for the Trade Area Group | |
LOCATION_ID | NUMBER | Y | The identifier for the Location entity | |
IS_PRIMARY_FLAG | VARCHAR2 | (1) | Y | Indicates if the Trade Area Group is the Primary Trade Area Group for the Location (Y/N) |
STATUS_CODE | VARCHAR2 | (30) | Y | Status of Trade Area Group associated with the Location. Possible Values could be A - Active , I - Inactive. |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
RRS.RRS_LOC_TRADE_AREA_GRPS does not reference any database object
RRS.RRS_LOC_TRADE_AREA_GRPS is referenced by following:
Description: | This table stores preferences for Icons set by site Administrator. |
---|
This table stores preferences for Icons set by site Administrator.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_MAP_ICON_SETTINGS_U1 | UNIQUE | APPS_TS_TX_IDX |
SITE_USE_TYPE_CODE
SITE_TYPE_CODE |
SYS_IL0000458010C00004$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_TYPE_CODE | VARCHAR2 | (30) | Y | Site Purpose |
SITE_USE_TYPE_CODE | VARCHAR2 | (30) | Y | Site Type |
ICON_FILENAME | VARCHAR2 | (240) | Icon File Name | |
ICON_FILE | BLOB | (4000) | Icon File | |
DISPLAY | NUMBER | Displayed | ||
LAST_UPDATE_DATE | DATE | Y | Standard WHO Columns | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Columns | |
CREATION_DATE | DATE | Y | Standard WHO Columns | |
CREATED_BY | NUMBER | Y | Standard WHO Columns | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Columns |
RRS.RRS_MAP_ICON_SETTINGS does not reference any database object
RRS.RRS_MAP_ICON_SETTINGS is referenced by following:
Description: | This table stores preferences for locations set by site Administrator. |
---|
This table stores preferences for locations set by site Administrator.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_MAP_LOCATION_SETTINGS_U1 | UNIQUE | APPS_TS_TX_IDX | COUNTRY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTRY_CODE | VARCHAR2 | (30) | Y | Country Code |
ATTRIBUTE_PAGE_ID | NUMBER | Attribute Page Identifier | ||
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Column | |
CREATION_DATE | DATE | Y | Standard WHO Column | |
CREATED_BY | NUMBER | Y | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column |
RRS.RRS_MAP_LOCATION_SETTINGS does not reference any database object
RRS.RRS_MAP_LOCATION_SETTINGS is referenced by following:
Description: | This table stores preferences for site types set by site Administrator. |
---|
This table stores preferences for site types set by site Administrator.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_MAP_SITE_SETTINGS_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_USE_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_USE_TYPE_CODE | VARCHAR2 | (30) | Y | Site Purpose |
ATTRIBUTE_PAGE_ID | NUMBER | Attribute Page Identifier | ||
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Column | |
CREATION_DATE | DATE | Y | Standard WHO Column | |
CREATED_BY | NUMBER | Y | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column |
RRS.RRS_MAP_SITE_SETTINGS does not reference any database object
RRS.RRS_MAP_SITE_SETTINGS is referenced by following:
Description: | This table stores preferences for Trade Area Group set by site Administrator. |
---|
This table stores preferences for Trade Area Group set by site Administrator.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_MAP_TRADE_AREA_SETTINGS_U1 | UNIQUE | APPS_TS_TX_IDX | GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Y | Trade Area Group Identifier | |
ATTRIBUTE_PAGE_ID | NUMBER | Attribute Page Identifier | ||
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Column | |
CREATION_DATE | DATE | Y | Standard WHO Column | |
CREATED_BY | NUMBER | Y | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column |
RRS.RRS_MAP_TRADE_AREA_SETTINGS does not reference any database object
RRS.RRS_MAP_TRADE_AREA_SETTINGS is referenced by following:
Description: | This table is used to store the basic information about sites. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_USES.SITE_ID | RRS_SITES_B |
RRS_SITES_TL.SITE_ID | RRS_SITES_B |
This table is used to store the basic information about sites.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_B_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_ID |
RRS_SITES_B_U2 | UNIQUE | APPS_TS_TX_IDX | SITE_IDENTIFICATION_NUMBER |
RRS_SITES_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | LE_PARTY_ID |
RRS_SITES_B_N2 | NONUNIQUE | APPS_TS_TX_IDX | SITE_PARTY_ID |
RRS_SITES_B_N3 | NONUNIQUE | APPS_TS_TX_IDX | SITE_STATUS_CODE |
RRS_SITES_B_N4 | NONUNIQUE | APPS_TS_TX_IDX | IS_TEMPLATE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_ID | NUMBER | Y | System generated number which uniquely identifies the site. | |
SITE_IDENTIFICATION_NUMBER | VARCHAR2 | (30) | Y | User entered unique identification number for site. |
SITE_TYPE_CODE | VARCHAR2 | (30) | Y | Indicates type of Site. Possible values I for Internal and E for External. |
SITE_STATUS_CODE | VARCHAR2 | (30) | Y | 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 | Y | One of the five standard "WHO" columns | |
CREATION_DATE | DATE | Y | One of the five standard "WHO" columns | |
LAST_UPDATED_BY | NUMBER | Y | One of the five standard "WHO" columns | |
LAST_UPDATE_DATE | DATE | Y | 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 |
RRS.RRS_SITES_B does not reference any database object
RRS.RRS_SITES_B is referenced by following:
Description: | This table stores the User Defined Attributes values associated with Sites. |
---|
This table stores the User Defined Attributes values associated with Sites.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
RRS_SITES_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SITE_ID
ATTR_GROUP_ID |
RRS_SITES_EXT_B_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
SITE_USE_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
SITE_ID | NUMBER | Y | Site Identification number for which Attribute Values are assigned | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Site Entity for User Defined Attributes | |
SITE_USE_TYPE_CODE | VARCHAR2 | (30) | Y | Use/Purpose for the Site |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
C_EXT_ATTR1 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR1 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR2 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR3 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR4 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR5 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR6 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR7 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR8 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR9 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR10 | NUMBER | Numeric Column for Attribute Value | ||
D_EXT_ATTR1 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR2 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR3 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR4 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR5 | DATE | Date Column for Attribute Value | ||
C_EXT_ATTR21 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR31 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR32 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR33 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR34 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR35 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR36 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR37 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR38 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR39 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR40 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR11 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR12 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR13 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR14 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR15 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR16 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR17 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR18 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR19 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR20 | NUMBER | Numeric Column for Attribute Value | ||
UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM Column for Attributes | |
D_EXT_ATTR6 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR7 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR8 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR9 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR10 | DATE | Date Column for Attribute Value | ||
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. |
RRS.RRS_SITES_EXT_B does not reference any database object
RRS.RRS_SITES_EXT_B is referenced by following:
Description: | This table stores the translated User Defined Attributes values associated with Sites in multiple languages |
---|
This table stores the translated User Defined Attributes values associated with Sites in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
EXTENSION_ID
LANGUAGE |
RRS_SITES_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SITE_ID
LANGUAGE |
RRS_SITES_EXT_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
SITE_USE_TYPE_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Site Entity for User Defined Attributes | |
SITE_ID | NUMBER | Y | Site Identification number for which Attribute Values are assigned | |
SITE_USE_TYPE_CODE | VARCHAR2 | (30) | Y | Use/Purpose for the Site |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installed base Language |
LANGUAGE | VARCHAR2 | (4) | Y | The language of translation |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
CREATION_DATE | DATE | Standard WHO column | ||
TL_EXT_ATTR1 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR2 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR3 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR4 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR5 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR6 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR7 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR8 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR9 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR10 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR11 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR12 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR13 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR14 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR15 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR16 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR17 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR18 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR19 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR20 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR21 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR22 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR23 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR24 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR25 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR26 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR27 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR28 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR29 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR30 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR31 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR32 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR33 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR34 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR35 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR36 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR37 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR38 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR39 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR40 | VARCHAR2 | (1000) | Character Column for translated Attribute Value |
RRS.RRS_SITES_EXT_TL does not reference any database object
RRS.RRS_SITES_EXT_TL is referenced by following:
Description: | This is an interface table which will be used to populate data for Import Interface Process |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_INTERFACE_N1 | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
PROCESS_STATUS TRANSACTION_TYPE |
Name | Datatype | Length | Mandatory | 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 ) |
RRS.RRS_SITES_INTERFACE does not reference any database object
RRS.RRS_SITES_INTERFACE is referenced by following:
Description: | This table stores the Site information during Asset Creation process. |
---|
This table stores the Site information during Asset Creation process.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_INTF_N1 | NONUNIQUE | APPS_TS_TX_IDX | SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | VARCHAR2 | (30) | Y | Session Identifier of process creating the information |
SITE_ID | NUMBER | Site Identifier | ||
ERROR_CODE | VARCHAR2 | (30) | Reserved for Error Handling | |
ERROR_MESSAGE | VARCHAR2 | (2000) | Reserved for Error Handling | |
CREATED_BY | NUMBER | Y | Standard WHO Column | |
CREATION_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column |
RRS.RRS_SITES_INTF does not reference any database object
RRS.RRS_SITES_INTF is referenced by following:
Description: | This table stores all the translatable information about sites. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITES_TL.SITE_ID | RRS_SITES_B |
This table stores all the translatable information about sites.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SITE_ID
LANGUAGE |
RRS_SITES_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SYS_NC00011$
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_ID | NUMBER | Y | System generated number which uniquely identifies the site. Foreign Key to RRS_SITES_B | |
NAME | VARCHAR2 | (150) | Y | Site Name |
LANGUAGE | VARCHAR2 | (4) | Y | The language of translation |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Source lang |
CREATED_BY | NUMBER | Y | One of the five standard "WHO" columns | |
CREATION_DATE | DATE | Y | One of the five standard "WHO" columns | |
LAST_UPDATED_BY | NUMBER | Y | One of the five standard "WHO" columns | |
LAST_UPDATE_DATE | DATE | Y | One of the five standard "WHO" columns | |
LAST_UPDATE_LOGIN | NUMBER | One of the five standard "WHO" columns | ||
DESCRIPTION | VARCHAR2 | (2000) | Description for the Site |
RRS.RRS_SITES_TL does not reference any database object
RRS.RRS_SITES_TL is referenced by following:
Description: | This table primarily stores the Site Group information, eg. Cluster and Hierarchy |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUPS_TL.SITE_GROUP_ID | RRS_SITE_GROUPS_B |
RRS_SITE_GROUP_VERSIONS.SITE_GROUP_ID | RRS_SITE_GROUPS_B |
This table primarily stores the Site Group information, eg. Cluster and Hierarchy
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUPS_B_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_GROUP_ID |
RRS_SITE_GROUPS_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | CREATED_BY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_ID | NUMBER | Y | Unique identifier for Site - Group | |
SITE_GROUP_TYPE_CODE | VARCHAR2 | (1) | Y | Internal variable which is used to store the Type of the Group. H : Hierarchy , C : Cluster |
START_DATE | DATE | Date from which the structure is to be considered Active | ||
END_DATE | DATE | Date from which the structure becomes Inactive | ||
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
GROUP_PURPOSE_CODE | VARCHAR2 | (30) | Purpose for this Hierarchy or Cluster based on user-defined lookups. |
RRS.RRS_SITE_GROUPS_B does not reference any database object
RRS.RRS_SITE_GROUPS_B is referenced by following:
Description: | This table primarily stores the translatable attributes of hierarchy and clusters |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUPS_TL.SITE_GROUP_ID | RRS_SITE_GROUPS_B |
This table primarily stores the translatable attributes of hierarchy and clusters
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUPS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_ID
LANGUAGE |
RRS_SITE_GROUPS_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SYS_NC00011$
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_ID | NUMBER | Y | Unique identifier for Site - Group | |
LANGUAGE | VARCHAR2 | (4) | Y | Standard name for a language. Stores Multiple languages. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installation base language |
NAME | VARCHAR2 | (150) | Y | Name of the structure |
DESCRIPTION | VARCHAR2 | (2000) | Description of the structure | |
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
RRS.RRS_SITE_GROUPS_TL does not reference any database object
RRS.RRS_SITE_GROUPS_TL is referenced by following:
Description: | This table contains the members of Cluste or Hierarchy. Member can be a site or a Node. |
---|
This table contains the members of Cluste or Hierarchy. Member can be a site or a Node.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUP_MEMBERS_U1 | UNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_ID
SITE_GROUP_VERSION_ID PARENT_MEMBER_ID CHILD_MEMBER_ID |
RRS_SITE_GROUP_MEMBERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
CHILD_MEMBER_ID
SITE_GROUP_ID SITE_GROUP_VERSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_VERSION_ID | NUMBER | Y | Identifies the specific version of the Cluster / Hierarchy. | |
SITE_GROUP_ID | NUMBER | Y | Group Identifier | |
PARENT_MEMBER_ID | NUMBER | Y | Identifies the Parent Node | |
CHILD_MEMBER_ID | NUMBER | Y | This field represents either a Node of a Hierarchy or a Site. | |
DELETED_FLAG | VARCHAR2 | (1) | Y | This Flag indicates whether the Site is deleted from the group or not. Y - Deleted , N - Not deleted |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
SEQUENCE_NUMBER | NUMBER | Sequence number of child member relative to its parent |
RRS.RRS_SITE_GROUP_MEMBERS does not reference any database object
RRS.RRS_SITE_GROUP_MEMBERS is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_TYPE | VARCHAR2 | (30) | ||
PARENT_ID | NUMBER | |||
PARENT_NUMBER | VARCHAR2 | (30) | ||
PARENT_PURPOSE_CODE | VARCHAR2 | (30) | ||
CHILD_TYPE | VARCHAR2 | (30) | ||
CHILD_ID | NUMBER | |||
CHILD_NUMBER | VARCHAR2 | (30) | ||
CHILD_PURPOSE_CODE | VARCHAR2 | (30) | ||
SEQUENCE_NUMBER | NUMBER | |||
CHILD_NODE_NAME | VARCHAR2 | (150) | ||
CHILD_NODE_DESCRIPTION | VARCHAR2 | (2000) |
RRS.RRS_SITE_GROUP_MEMBERS_TEMP does not reference any database object
RRS.RRS_SITE_GROUP_MEMBERS_TEMP is referenced by following:
Description: | This table contains the basic information of nodes |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUP_NODES_TL.SITE_GROUP_NODE_ID | RRS_SITE_GROUP_NODES_B |
This table contains the basic information of nodes
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUP_NODES_B_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_GROUP_NODE_ID |
RRS_SITE_GROUP_NODES_B_U2 | UNIQUE | APPS_TS_TX_IDX | NODE_IDENTIFICATION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_NODE_ID | NUMBER | Y | Unique identifier of Group Node | |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
NODE_IDENTIFICATION_NUMBER | VARCHAR2 | (30) | Y | Node identification number |
NODE_PURPOSE_CODE | VARCHAR2 | (30) | Node purpose |
RRS.RRS_SITE_GROUP_NODES_B does not reference any database object
RRS.RRS_SITE_GROUP_NODES_B is referenced by following:
Description: | This table contains the tranlatable attributes of Nodes. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUP_NODES_TL.SITE_GROUP_NODE_ID | RRS_SITE_GROUP_NODES_B |
This table contains the tranlatable attributes of Nodes.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUP_NODES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_NODE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_NODE_ID | NUMBER | Y | Group Node identifier | |
LANGUAGE | VARCHAR2 | (4) | Y | Standard name for a language. Stores Multiple languages. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installation base language |
NAME | VARCHAR2 | (150) | Y | Name of the Hierarchy Node |
DESCRIPTION | VARCHAR2 | (2000) | Description of the Hierarchy Node | |
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
RRS.RRS_SITE_GROUP_NODES_TL does not reference any database object
RRS.RRS_SITE_GROUP_NODES_TL is referenced by following:
Description: | This table contains the versioned information of cluster or hierarchy. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUP_VERSIONS.SITE_GROUP_ID | RRS_SITE_GROUPS_B |
This table contains the versioned information of cluster or hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_GROUP_VERSIONS_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_GROUP_VERSION_ID |
RRS_SITE_GROUP_VERSIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SITE_GROUP_ID
SITE_GROUP_VERSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_VERSION_ID | NUMBER | Y | Identifier of the specific version of the Cluster / Hierarchy. | |
SITE_GROUP_ID | NUMBER | Y | Group Identifier | |
VERSION_NUMBER | NUMBER | Y | Version of the Cluster / Hierarchy | |
SOURCE_VERSION_ID | NUMBER | Y | For now , this is same SITE_GROUP_VERSION_ID but will be used for versioning in the future. | |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
RRS.RRS_SITE_GROUP_VERSIONS does not reference any database object
RRS.RRS_SITE_GROUP_VERSIONS is referenced by following:
Description: | This table is reserved for integration with Oracle Spatial. Not supported in this release. |
---|
This table is reserved for integration with Oracle Spatial. Not supported in this release.
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000457983C00010$$ | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000457983C00011$$ | UNIQUE | APPS_TS_TX_DATA | |
RRS_SITE_TMP_N1 | NONUNIQUE | GEOMETRY | |
RRS_SITE_TMP_N2 | NONUNIQUE | APPS_TS_TX_IDX | SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | VARCHAR2 | (30) | Y | Session Identifier of process creating rows |
THEME_ID | VARCHAR2 | (30) | Theme ID of the Site used in Oracle Spatial | |
SITE_ID | NUMBER | Site Identifier | ||
GEOMETRY | SDO_GEOMETRY | (1) |
Description: | This table is for internal use and it is used for webADI integration. |
---|
This is an interface table used to import Site User Defined Attribute data. The interface is commonly used by Excel import and import using PL/SQL import interface. For Excel Import process, user should not update this table. The data only needs to be populated for the PL/SQL based import process.
For PL/SQL based import method, Site Import Interface Program will process rows in this table and import the data in Oracle Site Hub. It is expected that users would populate the data before submitting the import process.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS SITE UA INTF
Category: OPEN_INTERFACE RRS_SITE_UA_INTF 1
Category: BUSINESS_ENTITY RRS_SITE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Used for Internal Processing. Please do not update. | ||
DATA_LEVEL_ID | NUMBER | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 71802 during data processing. | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'SITE_LEVEL' during data processing. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | Used for Internal Processing. Please do not update. | |
PROCESS_STATUS | VARCHAR2 | (15) | 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). | |
DATA_SET_ID | NUMBER | Used for Internal Processing. Please do not update. An identifier for the collection of rows to be processed together. | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. This column should be populated very carefully. For all attributes of a Single Row Attribute Group, a common and unique value should be used. For all attributes of a Multi-Row Attribute Group row, a common and unique value should be used. The value used, should not be repeated for any other Single Row or Multi-Row Attribute Group row in a batch. | ||
SITE_NUMBER | VARCHAR2 | (30) | Site Identification Number of the Site for which user is uploading the User Defined Attributes. | |
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Internal name of the User Defined Attribute Group to which attributes are attached. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Internal name of the attribute. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group and it's attributes. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | User Defined Attribute value of type VARCHAR. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_NUM and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | |
ATTR_VALUE_NUM | NUMBER | User Defined Attribute value of type NUMBER. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_VALUE_DATE | DATE | User Defined Attribute value of type DATE. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_NUM should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Display Value of the Attributes. For Value Set based attributes, display value can be different from the value actually stored in the database. Enter the Display Value, sometimes also known as the Meaning of the Value Set, in this field. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type for this record. Valid values are CREATE or UPDATE. | |
SITE_ID | VARCHAR2 | (150) | Internal identifier of the Site for which User Defined Attribute data is to be uploaded. User can query the Site_id from RRS_SITES_VL. Ensure that this value is correctly populated for successful processing. | |
ATTR_GROUP_ID | NUMBER | Internal identifier of User Defined Attribute Group to which attributes are attached. User can query this from ego_obj_ag_assocs_b. | ||
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. | ||
CREATED_BY | NUMBER | Standard who columns. | ||
CREATION_DATE | DATE | Standard who columns. | ||
LAST_UPDATED_BY | NUMBER | Standard who columns. | ||
LAST_UPDATE_DATE | DATE | Standard who columns. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who columns. | ||
SITE_USE_TYPE_CODE | VARCHAR2 | (150) | This is the Site Purpose. Eg. Store, Mail Box | |
ATTR_GROUP_TYPE | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'RRS_SITEMGMT_GROUP' during data processing. | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with an attribute of data type NUMBER. User can query this value from UNIT_OF_MEASURE column of MTL_UNITS_OF_MEASURE table. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with the attribute of data type NUMBER. User can query this value from UOM_CODE column of MTL_UNITS_OF_MEASURE table. | |
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 table in one batch |
RRS.RRS_SITE_UA_INTF does not reference any database object
RRS.RRS_SITE_UA_INTF is referenced by following:
Description: | This table stores information about how a site is used. Site can have multiple uses, for example Store , Distribution Centre , Mail Box etc. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_USES.SITE_ID | RRS_SITES_B |
This table stores information about how a site is used. Site can have multiple uses, for example Store , Distribution Centre , Mail Box etc.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_SITE_USES_U1 | UNIQUE | APPS_TS_TX_IDX | SITE_USE_ID |
RRS_SITE_USES_U2 | UNIQUE | APPS_TS_TX_IDX |
SITE_ID
SITE_USE_TYPE_CODE |
RRS_SITE_USES_N1 | NONUNIQUE | APPS_TS_TX_IDX | IS_PRIMARY_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_USE_ID | NUMBER | Y | Site use identifier | |
SITE_ID | NUMBER | Y | Foreign key to RRS_SITES_B | |
SITE_USE_TYPE_CODE | VARCHAR2 | (30) | Y | Use/Purpose for the Site |
STATUS_CODE | VARCHAR2 | (30) | Y | Site Status, A =>Active , I => Inactive |
IS_PRIMARY_FLAG | VARCHAR2 | (1) | Indicates if this is the primary use for this site. Y for the primary site, N for all other sites | |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column |
RRS.RRS_SITE_USES does not reference any database object
RRS.RRS_SITE_USES is referenced by following:
Description: | This table stores the information of templates associated with Attribute Groups |
---|
This table stores the information of templates associated with Attribute Groups
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TEMPLATE_ATTRIBUTE_GROUPS_ | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
ASSOCIATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | Y | Template Identifier | |
ASSOCIATION_ID | NUMBER | Y | System Generated Association ID between Template and Attribute Groups | |
ATTRIBUTE_GROUP_ID | NUMBER | Y | Attribute Group ID attached to this template | |
ATTR_GROUP_NAME | VARCHAR2 | (30) | Y | Internal name of Attribute Group attached to this template |
ATTR_GROUP_DISP_NAME | VARCHAR2 | (80) | Y | Display name of Attribute Group attached to this template |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column |
RRS.RRS_TEMPLATE_ATTRIBUTE_GROUPS does not reference any database object
RRS.RRS_TEMPLATE_ATTRIBUTE_GROUPS is referenced by following:
Description: | This table is for internal use and it is used for webADI integration. |
---|
This is an interface table used to import Trade Area specific User Defined Attribute data. The interface is commonly used by Excel import and import using PL/SQL import interface. For Excel Import process, user should not update this table. The data only needs to be populated for the PL/SQL based import process.
For PL/SQL based import method, Site Import Interface Program will process rows in this table and import the data in Oracle Site Hub. It is expected that users would populate the data before submitting the import process.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS TRADE AREA UA INTF
Category: OPEN_INTERFACE RRS_TRADEAREA_UA_INTF 1
Category: BUSINESS_ENTITY RRS_SITE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Used for Internal Processing. Please do not update | ||
DATA_LEVEL_ID | NUMBER | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 71803 during data processing. | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'TRADE_AREA_LEVEL' during data processing. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | Used for Internal Processing. Please do not update. | |
PROCESS_STATUS | VARCHAR2 | (15) | 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). | |
DATA_SET_ID | NUMBER | Used for Internal Processing. Please do not update. An identifier for the collection of rows to be processed together. | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. This column should be populated very carefully. For all attributes of a Single Row Attribute Group, a common and unique value should be used. For all attributes of a Multi-Row Attribute Group row, a common and unique value should be used. The value used, should not be repeated for any other Single Row or Multi-Row Attribute Group row in a batch. | ||
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Internal name of the User Defined Attribute Group to which attributes are attached. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Internal name of the attribute. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group and it's attributes. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | User Defined Attribute value of type VARCHAR. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_NUM and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | |
ATTR_VALUE_NUM | NUMBER | User Defined Attribute value of type NUMBER. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_VALUE_DATE | DATE | User Defined Attribute value of type DATE. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_NUM should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Display Value of the Attributes. For Value Set based attributes, display value can be different from the value actually stored in the database. Enter the Display Value, sometimes also known as the Meaning of the Value Set, in this field. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type for this record. Valid values are CREATE or UPDATE. | |
TRADE_AREA_ID | VARCHAR2 | (150) | Internal identifier of the Trade Area for which User Defined Attribute data is to be uploaded. User can query the Trade_Area_ID from RRS_TRADE_AREAS. Ensure that this value is correctly populated for successful processing. | |
ATTR_GROUP_ID | NUMBER | Internal identifier of User Defined Attribute Group to which attributes are attached. User can query this from ego_obj_ag_assocs_b. | ||
GROUP_ID | VARCHAR2 | (150) | Internal identifier which was generated when user created the Trade Area Group. User can query the GROUP_ID from RRS_TRADE_AREA_GROUPS_VL. | |
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. | ||
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 | ||
ATTR_GROUP_TYPE | VARCHAR2 | (30) | Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'RRS_TRADE_AREA_GROUP' during data processing. | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with an attribute of data type NUMBER. User can query this value from UNIT_OF_MEASURE column of MTL_UNITS_OF_MEASURE table. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with the attribute of data type NUMBER. User can query this value from UOM_CODE column of MTL_UNITS_OF_MEASURE table. | |
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 table in one batch |
RRS.RRS_TRADEAREA_UA_INTF does not reference any database object
RRS.RRS_TRADEAREA_UA_INTF is referenced by following:
Description: | This table stores the information related to Trade Areas. |
---|
This table stores the information related to Trade Areas.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREAS_U1 | UNIQUE | APPS_TS_TX_IDX | TRADE_AREA_ID |
RRS_TRADE_AREAS_U2 | UNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
GROUP_ID TRADE_AREA_NUMBER_CODE |
SYS_IL0000457929C00017$$ | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000457929C00018$$ | UNIQUE | APPS_TS_TX_DATA | |
RRS_TRADE_AREAS_N1 | NONUNIQUE | GEOMETRY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRADE_AREA_ID | NUMBER | Y | The unique identifier for the Trade Area | |
TRADE_AREA_NUMBER_CODE | VARCHAR2 | (30) | Y | The Trade Area Number |
GROUP_ID | NUMBER | Y | The identifier for the Trade Area Group | |
LOCATION_ID | NUMBER | Y | The identifier for the Location entity | |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
GEOMETRY | SDO_GEOMETRY | (1) |
Description: | This table stores the User Defined Attributes values associated with Trade Areas. |
---|
This table stores the User Defined Attributes values associated with Trade Areas.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREAS_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
RRS_TRADE_AREAS_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
TRADE_AREA_ID
ATTR_GROUP_ID |
RRS_TRADE_AREAS_EXT_B_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Trade Area Entity for User Defined Attributes | |
TRADE_AREA_ID | NUMBER | Y | Trade Area Identification number for which Attribute Values are assigned | |
GROUP_ID | NUMBER | Y | Group ID of Trade Area | |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
C_EXT_ATTR1 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR1 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR2 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR3 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR4 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR5 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR6 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR7 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR8 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR9 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR10 | NUMBER | Numeric Column for Attribute Value | ||
D_EXT_ATTR1 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR2 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR3 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR4 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR5 | DATE | Date Column for Attribute Value | ||
C_EXT_ATTR21 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR31 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR32 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR33 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR34 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR35 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR36 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR37 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR38 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR39 | VARCHAR2 | (150) | Character Column for Attribute Value | |
C_EXT_ATTR40 | VARCHAR2 | (150) | Character Column for Attribute Value | |
N_EXT_ATTR11 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR12 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR13 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR14 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR15 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR16 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR17 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR18 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR19 | NUMBER | Numeric Column for Attribute Value | ||
N_EXT_ATTR20 | NUMBER | Numeric Column for Attribute Value | ||
UOM_EXT_ATTR1 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR2 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR3 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR4 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR5 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR6 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR7 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR8 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR9 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR10 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR11 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR12 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR13 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR14 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR15 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR16 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR17 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR18 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR19 | VARCHAR2 | (3) | UOM Column for Attributes | |
UOM_EXT_ATTR20 | VARCHAR2 | (3) | UOM Column for Attributes | |
D_EXT_ATTR6 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR7 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR8 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR9 | DATE | Date Column for Attribute Value | ||
D_EXT_ATTR10 | DATE | Date Column for Attribute Value | ||
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. |
RRS.RRS_TRADE_AREAS_EXT_B does not reference any database object
RRS.RRS_TRADE_AREAS_EXT_B is referenced by following:
Description: | This table stores the translated User Defined Attributes values associated with Trade Areas in multiple languages |
---|
This table stores the translated User Defined Attributes values associated with Trade Areas in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREAS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
EXTENSION_ID
LANGUAGE |
RRS_TRADE_AREAS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
TRADE_AREA_ID
LANGUAGE |
RRS_TRADE_AREAS_EXT_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTR_GROUP_ID
GROUP_ID LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System Generated Unique Identifier | |
DATA_LEVEL_ID | NUMBER | Y | Internal representation of Trade Areas Entity for User Defined Attributes | |
TRADE_AREA_ID | NUMBER | Y | Trade Area Identification number for which Attribute Values are assigned | |
GROUP_ID | NUMBER | Y | Group ID of Trade Area | |
ATTR_GROUP_ID | NUMBER | Y | Internal Identification ID of Attribute Group | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Installed base Language |
LANGUAGE | VARCHAR2 | (4) | Y | The language of translation |
CREATED_BY | NUMBER | Y | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
TL_EXT_ATTR1 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR2 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR3 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR4 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR5 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR6 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR7 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR8 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR9 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR10 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR11 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR12 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR13 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR14 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR15 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR16 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR17 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR18 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR19 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR20 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR21 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR22 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR23 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR24 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR25 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR26 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR27 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR28 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR29 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR30 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR31 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR32 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR33 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR34 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR35 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR36 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR37 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR38 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR39 | VARCHAR2 | (1000) | Character Column for translated Attribute Value | |
TL_EXT_ATTR40 | VARCHAR2 | (1000) | Character Column for translated Attribute Value |
RRS.RRS_TRADE_AREAS_EXT_TL does not reference any database object
RRS.RRS_TRADE_AREAS_EXT_TL is referenced by following:
Description: | This table stores the information related to Trade Area Groups |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_GROUP_TRADE_AREAS.GROUP_ID | RRS_TRADE_AREA_GROUPS_B |
RRS_TRADE_AREA_GROUPS_TL.GROUP_ID | RRS_TRADE_AREA_GROUPS_B |
This table stores the information related to Trade Area Groups
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREA_GROUPS_B_U1 | UNIQUE | APPS_TS_TX_IDX | GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Y | The unique identifier for the Trade Area Group | |
GROUP_TYPE_CODE | VARCHAR2 | (30) | Y | The geometry type of the Trade Area Group. |
NUM_OF_TRADE_AREAS | NUMBER | Y | The number of Trade Areas in this Trade Area Group. | |
STATUS_CODE | VARCHAR2 | (30) | Y | Trade Area Group Status , A =>Active , I => Inactive |
UNIT_OF_MEASURE_CODE | VARCHAR2 | (30) | Y | The Unit Of Measure used while specifying the Trade Area radii |
OBJECT_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
RRS.RRS_TRADE_AREA_GROUPS_B does not reference any database object
RRS.RRS_TRADE_AREA_GROUPS_B is referenced by following:
Description: | This table stores all the translatable information related to Trade Area Groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_TRADE_AREA_GROUPS_TL.GROUP_ID | RRS_TRADE_AREA_GROUPS_B |
This table stores all the translatable information related to Trade Area Groups.
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREA_GROUPS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
GROUP_ID
LANGUAGE |
RRS_TRADE_AREA_GROUPS_TL_U2 | UNIQUE | APPS_TS_TX_IDX |
NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Y | System generated number which uniquely identifies the Trade Area Group. Foreign key to RRS_TRADE_AREA_GROUPS_B.GROUP_ID. | |
NAME | VARCHAR2 | (150) | Y | User defined name of the Trade Area Group. |
DESCRIPTION | VARCHAR2 | (2000) | User entered description for Trade Area Group. | |
LANGUAGE | VARCHAR2 | (4) | Y | For Transalation. |
SOURCE_LANG | VARCHAR2 | (4) | Y | For Translation. |
CREATED_BY | NUMBER | Y | Standard "WHO" columns. | |
CREATION_DATE | DATE | Y | Standard "WHO" columns. | |
LAST_UPDATED_BY | NUMBER | Y | Standard "WHO" columns. | |
LAST_UPDATE_DATE | DATE | Y | Standard "WHO" columns. | |
LAST_UPDATE_LOGIN | NUMBER | Standard "WHO" columns. |
RRS.RRS_TRADE_AREA_GROUPS_TL does not reference any database object
RRS.RRS_TRADE_AREA_GROUPS_TL is referenced by following:
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |