DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_IRF_TIMEOF_PURCHASE

Object Details
Object Name: IBY_IRF_TIMEOF_PURCHASE
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_IRF_TIMEOF_PURCHASE
Subobject Name:
Status: VALID


IBY_IRF_TIMEOF_PURCHASE stores information pertaining to the time of purchase risk factor. The merchant can set up different time ranges and associate a risk score of low risk, medium low risk, medium risk, medium high risk, and high risk.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DURATION_FROM VARCHAR2 (8) Yes Stores the beginning time HH:MM of the duration range
SEQ NUMBER (15) Yes Sequence
DURATION_TO VARCHAR2 (8) Yes Stores the end time HH:MM of the duration range
SCORE VARCHAR2 (30) Yes LOV of ranges of possible risk scores
PAYEEID VARCHAR2 (80)
Payee identification passed by electronic commerce application
LAST_UPDATE_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT DURATION_FROM
,      SEQ
,      DURATION_TO
,      SCORE
,      PAYEEID
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IBY.IBY_IRF_TIMEOF_PURCHASE;

Dependencies

[top of page]

IBY.IBY_IRF_TIMEOF_PURCHASE does not reference any database object

IBY.IBY_IRF_TIMEOF_PURCHASE is referenced by following:

SchemaAPPS
SynonymIBY_IRF_TIMEOF_PURCHASE