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

TABLE: BNE.BNE_ASYNC_UPLOAD_JOBS

Object Details
Object Name: BNE_ASYNC_UPLOAD_JOBS
Object Type: TABLE
Owner: BNE
FND Design Data: TableBNE.BNE_ASYNC_UPLOAD_JOBS
Subobject Name:
Status: VALID


Bne_ASYNC_UPLOAD_JOBS provides storage of upload Jobs. There will be 1 row per Job.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BNE_ASYNC_UPLOAD_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
BNE_ASYNC_UPLOAD_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_CREATION_DATE
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER
Yes Asynchronous Job identifier.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Yes Application Id of the integrator this job is for.
INTEGRATOR_CODE VARCHAR2 (30) Yes Integrator code of the integrator this job is for.
UPLOAD_STATE VARCHAR2 (30) Yes Current upload state of the upload job.
TRANSLATED_UPLOAD_STATE VARCHAR2 (2000)
Current translated upload state of the upload job.
JOB_CREATION_DATE DATE

Job Creation Date
JOB_START_DATE DATE

Job start date. The date the Job moved out of the SCHEDULED state.
JOB_END_DATE DATE

Job End Date. The date the job went into DONE or, CANCEL state.
CANCEL_UPLOAD_FLAG VARCHAR2 (1) Yes Is the Job being asket to cancel (Y/N)?
TRANSACTION_REFERENCE1 VARCHAR2 (30)
Transaction reference to a transaction for failure support.
TRANSACTION_REFERENCE2 VARCHAR2 (30)
Transaction start date for a transaction for failure support.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Unique code identifying this entity for the given APPLICATION_ID.
ATTRIBUTE1 VARCHAR2 (240)
Attribute 1
ATTRIBUTE2 VARCHAR2 (240)
Attribute 2
ATTRIBUTE3 VARCHAR2 (240)
Attribute 3
ATTRIBUTE4 VARCHAR2 (240)
Attribute 4
ATTRIBUTE5 VARCHAR2 (240)
Attribute 5
ATTRIBUTE6 VARCHAR2 (240)
Attribute 6
ATTRIBUTE7 VARCHAR2 (240)
Attribute 7
ATTRIBUTE8 VARCHAR2 (240)
Attribute 8
ATTRIBUTE9 VARCHAR2 (240)
Attribute 9
ATTRIBUTE10 VARCHAR2 (240)
Attribute 110
ATTRIBUTE11 VARCHAR2 (240)
Attribute 11
ATTRIBUTE12 VARCHAR2 (240)
Attribute 12
ATTRIBUTE13 VARCHAR2 (240)
Attribute 13
ATTRIBUTE14 VARCHAR2 (240)
Attribute 14
ATTRIBUTE15 VARCHAR2 (240)
Attribute 15
ATTRIBUTE16 VARCHAR2 (240)
Attribute 16
ATTRIBUTE17 VARCHAR2 (240)
Attribute 17
ATTRIBUTE18 VARCHAR2 (240)
Attribute 18
ATTRIBUTE19 VARCHAR2 (240)
Attribute 19
ATTRIBUTE20 VARCHAR2 (240)
Attribute 20
ATTRIBUTE21 VARCHAR2 (240)
Attribute 21
ATTRIBUTE22 VARCHAR2 (240)
Attribute 22
ATTRIBUTE23 VARCHAR2 (240)
Attribute 23
ATTRIBUTE24 VARCHAR2 (240)
Attribute 24
ATTRIBUTE25 VARCHAR2 (240)
Attribute 25
ATTRIBUTE26 VARCHAR2 (240)
Attribute 26
ATTRIBUTE27 VARCHAR2 (240)
Attribute 27
ATTRIBUTE28 VARCHAR2 (240)
Attribute 28
ATTRIBUTE29 VARCHAR2 (240)
Attribute 29
ATTRIBUTE30 VARCHAR2 (240)
Attribute 30
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT JOB_ID
,      OBJECT_VERSION_NUMBER
,      INTEGRATOR_APP_ID
,      INTEGRATOR_CODE
,      UPLOAD_STATE
,      TRANSLATED_UPLOAD_STATE
,      JOB_CREATION_DATE
,      JOB_START_DATE
,      JOB_END_DATE
,      CANCEL_UPLOAD_FLAG
,      TRANSACTION_REFERENCE1
,      TRANSACTION_REFERENCE2
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM BNE.BNE_ASYNC_UPLOAD_JOBS;

Dependencies

[top of page]

BNE.BNE_ASYNC_UPLOAD_JOBS does not reference any database object

BNE.BNE_ASYNC_UPLOAD_JOBS is referenced by following:

SchemaBNE
ViewBNE_ASYNC_UPLOAD_JOBS#