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: |
---|
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 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 |
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
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_LOCATIONS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
RRS_LOCATIONS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LANGUAGE
LOCATION_ID |
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 table is for internal use and it is used for webADI integration.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Uniquely identifies each record in this table. | |
DATA_LEVEL_ID | NUMBER | Refers to data level identifier of the association. Column in ego_data_level_b | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Refers to data_level_name of the association. References data_level_name from ego_data_level_b. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | User Name for Data Level to be displayed to the end user. | |
PROCESS_STATUS | VARCHAR2 | (15) | Identifies the status of the concurrent request used by webADI integration. | |
DATA_SET_ID | NUMBER | An identifier for the collection of rows to be processed together | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. | ||
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Attribute Group Internal Name. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Attribute Internal Name. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | Attribute Value. Hold values of type VARCHAR. | |
ATTR_VALUE_NUM | NUMBER | Attribute Value. Hold values of type NUMBER. | ||
ATTR_VALUE_DATE | DATE | Attribute Name. Hold values of type DATE. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Attribute Display Value. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type. Possible values CREATE,UPDFATE,DELETE. | |
LOCATION_ID | VARCHAR2 | (150) | Unique Identifier of the Location. | |
ATTR_GROUP_ID | NUMBER | Unique identfier for trade areas group id. | ||
COUNTRY | VARCHAR2 | (150) | Indicates the COUNTRY | |
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. | ||
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) | Attribute Group Type of the attribute | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with attribute. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with attribute. |
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
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 is used to store the basic information about sites. |
---|
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.
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 |
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
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 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 | % |
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
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). |
RRS.RRS_SITE_GROUPS_B does not reference any database object
RRS.RRS_SITE_GROUPS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUPS_TL.SITE_GROUP_ID | % |
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.
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_GROUP_VERSION_ID | NUMBER | Y | Identifies the specific version of the Cluster / Hierarchy. Currently not supported | |
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 |
RRS.RRS_SITE_GROUP_MEMBERS does not reference any database object
RRS.RRS_SITE_GROUP_MEMBERS is referenced by following:
Description: |
---|
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 |
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 |
RRS.RRS_SITE_GROUP_NODES_B does not reference any database object
RRS.RRS_SITE_GROUP_NODES_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUP_NODES_TL.SITE_GROUP_NODE_ID | % |
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: |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_GROUP_VERSIONS.SITE_GROUP_ID | % |
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 |
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.
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 table is for internal use and it is used for webADI integration.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Uniquely identifies each record in this table. | |
DATA_LEVEL_ID | NUMBER | Refers to data level identifier of the association. Column in ego_data_level_b | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Refers to data_level_name of the association. References data_level_name from ego_data_level_b. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | User Name for Data Level to be displayed to the end user. | |
PROCESS_STATUS | VARCHAR2 | (15) | Identifies the status of the concurrent request used by webADI integration. | |
DATA_SET_ID | NUMBER | An identifier for the collection of rows to be processed together. | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. | ||
SITE_NUMBER | VARCHAR2 | (30) | Site Identification Number. | |
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Group Internal Name. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Attribute Internal Name. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | Attribute Value. Hold values of type VARCHAR | |
ATTR_VALUE_NUM | NUMBER | Attribute Value. Hold values of type NUMBER. | ||
ATTR_VALUE_DATE | DATE | Attribute Value. Hold values of type DATE. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Attribute Display Value. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type. Possible values CREATE,UPDFATE,DELETE. | |
SITE_ID | VARCHAR2 | (150) | Unique identfier for Site Id. | |
ATTR_GROUP_ID | NUMBER | Unique identfier for Atrribute Group Id. | ||
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. | ||
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) | Site Use Type Code. Displayed as Purpose. Possible values comes from AR LOOKUP | |
ATTR_GROUP_TYPE | VARCHAR2 | (30) | Attribute Group Type of the attribute | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with attribute. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with attribute. |
RRS.RRS_SITE_UA_INTF does not reference any database object
RRS.RRS_SITE_UA_INTF is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_SITE_USES.SITE_ID | % |
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
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 table is for internal use and it is used for webADI integration.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Uniquely identifies each record in this table. | |
DATA_LEVEL_ID | NUMBER | Refers to data level identifier of the association. Column in ego_data_level_b | ||
DATA_LEVEL_NAME | VARCHAR2 | (30) | Refers to data_level_name of the association. References data_level_name from ego_data_level_b. | |
USER_DATA_LEVEL_NAME | VARCHAR2 | (240) | User Name for Data Level to be displayed to the end user. | |
PROCESS_STATUS | VARCHAR2 | (15) | Identifies the status of the concurrent request used by webADI integration. | |
DATA_SET_ID | NUMBER | An identifier for the collection of rows to be processed together. | ||
ROW_IDENTIFIER | NUMBER | Identifier column for the record. | ||
ATTR_GROUP_INT_NAME | VARCHAR2 | (30) | Group Internal Name. | |
ATTR_INT_NAME | VARCHAR2 | (30) | Attribute Internal Name. | |
ATTR_VALUE_STR | VARCHAR2 | (1000) | Attribute Value. Hold values of type VARCHAR | |
ATTR_VALUE_NUM | NUMBER | Attribute Value. Hold values of type NUMBER. | ||
ATTR_VALUE_DATE | DATE | Attribute Value. Hold values of type DATE. | ||
ATTR_DISP_VALUE | VARCHAR2 | (1000) | Attribute Display Value. | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction Type. Possible values CREATE,UPDFATE,DELETE. | |
TRADE_AREA_ID | VARCHAR2 | (150) | Trade Area Identification Number. | |
ATTR_GROUP_ID | NUMBER | Unique identfier for Atrribute Group Id. | ||
GROUP_ID | VARCHAR2 | (150) | Unique identfier for Trade Area | |
REQUEST_ID | NUMBER | Concurrent Requst id. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Programs Application Id. | ||
PROGRAM_ID | NUMBER | Concurrent Program Id. | ||
PROGRAM_UPDATE_DATE | DATE | Standard columns. | ||
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) | Attribute Group Type of the attribute | |
ATTR_UOM_DISP_VALUE | VARCHAR2 | (25) | Display value of Unit Of Measure associated with attribute. | |
ATTR_VALUE_UOM | VARCHAR2 | (3) | Internal value of Unit Of Measure associated with attribute. |
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.
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.
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 |
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
Index | Type | Tablespace | Column |
---|---|---|---|
RRS_TRADE_AREAS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
RRS_TRADE_AREAS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LANGUAGE
TRADE_AREA_ID |
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: |
---|
Foreign Key Column | Foreign Table |
---|---|
RRS_GROUP_TRADE_AREAS.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 | % |
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 |