[Home] [Help] [Dependency Information]
Object Name: | OKC_RULE_DEF_SOURCES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_RULE_DEF_SOURCES |
Subobject Name: | |
Status: | VALID |
Defines the valid data sources for RULE when it is used in a RULE GROUP.
A rule may have up to three data sources (foreign keys). The data sources may change based upon the rule group in which the rule is used and if the contract is a buy or sell contract.
For example, the source for a payment term rule used in a billing rule group for a sell contract would be AP Payment Terms. It is defined from the vendor's perspective, he will bill. The same rule for a buy contract would source from AR Payment Terms, as the buyer will be the one being billed.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_RULE_DEF_SOURCES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
RGR_RDF_CODE
RGR_RGD_CODE BUY_OR_SELL START_DATE OBJECT_ID_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RGR_RGD_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
RGR_RDF_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
BUY_OR_SELL | VARCHAR2 | (3) | Yes | Denotes if rule is for Buy or for Sell. |
START_DATE | DATE | Yes | The beginning of the active period, one second after midnight on the date indicated. | |
END_DATE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
JTOT_OBJECT_CODE | VARCHAR2 | (30) | Yes | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. |
OBJECT_ID_NUMBER | NUMBER | (1) | Yes | Object ID number. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ACCESS_LEVEL | VARCHAR2 | (1) | Indicates the protection level for the record. |
Cut, paste (and edit) the following text to query this object:
SELECT RGR_RGD_CODE
, RGR_RDF_CODE
, BUY_OR_SELL
, START_DATE
, END_DATE
, JTOT_OBJECT_CODE
, OBJECT_ID_NUMBER
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ACCESS_LEVEL
FROM OKC.OKC_RULE_DEF_SOURCES;
OKC.OKC_RULE_DEF_SOURCES does not reference any database object
OKC.OKC_RULE_DEF_SOURCES is referenced by following:
|
|
|