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: MSC.MSC_ST_OPEN_PAYBACKS

Object Details

Object Name:	MSC_ST_OPEN_PAYBACKS
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

Stg Table for Open Paybacks

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Source side Inventory item id
SR_INSTANCE_ID	NUMBER		Source application instance identifier
ORGANIZATION_ID	NUMBER		Source side Organization Identifier
SCHEDULED_PAYBACK_DATE	DATE		Scheduled Payback date
QUANTITY	NUMBER		Quantity
LENDING_PROJECT_ID	NUMBER		Lending Project Identifier
LENDING_TASK_ID	NUMBER		Lending Task Identifier
BORROW_PROJECT_ID	NUMBER		Borrowing Project Identifier
BORROW_TASK_ID	NUMBER		Borrowing Task Identifier
PLANNING_GROUP	VARCHAR2	(30)	Borrowing Project planning group
LENDING_PROJ_PLANNING_GROUP	VARCHAR2	(30)	Lending Project planning group
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	End Item Unit Number
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column
REFRESH_ID	NUMBER		Standard Who column
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
SR_INSTANCE_CODE	VARCHAR2	(3)	Identifier of the source application instance
MESSAGE_ID	NUMBER		This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML.
PROCESS_FLAG	NUMBER		Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
BATCH_ID	NUMBER		Batch identifier generated during pre-processing
DATA_SOURCE_TYPE	VARCHAR2	(15)	Source Type indicating the source of data, Batch/XML
ST_TRANSACTION_ID	NUMBER		Transaction ID generated during pre-processing to uniquely identify a record in the staging table
ERROR_TEXT	VARCHAR2	(2000)	If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
COMMENTS	VARCHAR2	(1000)	Comments

Query Text

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


SELECT INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      SCHEDULED_PAYBACK_DATE
,      QUANTITY
,      LENDING_PROJECT_ID
,      LENDING_TASK_ID
,      BORROW_PROJECT_ID
,      BORROW_TASK_ID
,      PLANNING_GROUP
,      LENDING_PROJ_PLANNING_GROUP
,      END_ITEM_UNIT_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REFRESH_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      BATCH_ID
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      COMMENTS
FROM MSC.MSC_ST_OPEN_PAYBACKS;

Dependencies

[top of page]

MSC.MSC_ST_OPEN_PAYBACKS does not reference any database object

MSC.MSC_ST_OPEN_PAYBACKS is referenced by following:

APPS: MSC_ST_OPEN_PAYBACKS