[Home] [Help] [Dependency Information]
Object Name: | OKC_RULE_DEF_SOURCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_RULE_DEF_SOURCES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Contains object id number to identify which source is for which object id
in order to provide semantic meaning
use the descriptive flex field registration
to describe a prompt/label/usage for the object name and column
this can be thought of as a further subtype of the rule subtype
the rule subtype being equivalent to the flex context
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
JTOT_OBJECT_CODE | VARCHAR2 | (30) | Yes | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. |
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 | Buy or Sell indicator. |
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. | ||
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. |
OBJECT_ID_NUMBER | NUMBER | (1) | Yes | Object ID number. |
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. | |
ACCESS_LEVEL | VARCHAR2 | (1) | Indicates the Protection level of the record. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, JTOT_OBJECT_CODE
, RGR_RGD_CODE
, RGR_RDF_CODE
, BUY_OR_SELL
, START_DATE
, END_DATE
, OBJECT_VERSION_NUMBER
, OBJECT_ID_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCESS_LEVEL
FROM APPS.OKC_RULE_DEF_SOURCES_V;
|
|
|