eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OPI.OPI_IDS_PUSH_DATE_LOG

Object Details

Object Name:	OPI_IDS_PUSH_DATE_LOG
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_IDS_PUSH_DATE_LOG
Subobject Name:
Status:	VALID

Log table to track inventory daily status extraction bounds. Keeps track of when the last time data was pushed to the fact table successfully. Also tracks the last inventory and WIP transaction extracted for every organization in the most recent run.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_IDS_PUSH_DATE_LOG_PK	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID LAST_PUSH_DATE

Columns

Name	Datatype	Mandatory	Comments
ORGANIZATION_ID	NUMBER	Yes	Organization ID
LAST_PUSH_DATE	DATE	Yes	Last Date on which data was pushed successfully to the fact table
LAST_PUSH_INV_TXN_ID	NUMBER		ID of last Inventory transaction (from MTL_MATERIAL_TRANSACTIONS) that was pushed to the fact table
LAST_PUSH_INV_TXN_DATE	DATE		Date of last Inventory transaction (from MTL_MATERIAL_TRANSACTIONS) that was pushed to the fact table
LAST_PUSH_WIP_TXN_ID	NUMBER		ID of last WIP transaction (from WIP_TRANSACTIONS) that was pushed to the fact table
LAST_PUSH_WIP_TXN_DATE	DATE		Date of last WIP transaction (from WIP_TRANSACTIONS) that was pushed to the fact table
CREATION_DATE	DATE		WHO column
CREATED_BY	NUMBER		WHO column
LAST_UPDATE_DATE	DATE		WHO column
LAST_UPDATED_BY	NUMBER		WHO column
REQUEST_ID	NUMBER		WHO column
PROGRAM_APPLICATION_ID	NUMBER		WHO column
PROGRAM_ID	NUMBER		WHO column
PROGRAM_UPDATE_DATE	NUMBER		WHO column

Query Text

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


SELECT ORGANIZATION_ID
,      LAST_PUSH_DATE
,      LAST_PUSH_INV_TXN_ID
,      LAST_PUSH_INV_TXN_DATE
,      LAST_PUSH_WIP_TXN_ID
,      LAST_PUSH_WIP_TXN_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM OPI.OPI_IDS_PUSH_DATE_LOG;

Dependencies

[top of page]

OPI.OPI_IDS_PUSH_DATE_LOG does not reference any database object

OPI.OPI_IDS_PUSH_DATE_LOG is referenced by following:

APPS: OPI_IDS_PUSH_DATE_LOG