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: MRP.MRP_AD_TXN_REQUEST_LINES

Object Details

Object Name:	MRP_AD_TXN_REQUEST_LINES
Object Type:	TABLE
Owner:	MRP
Subobject Name:
Status:	VALID

This table will contain deleted material transaction request lines, and would be referred during net change ASCP colletions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Transaction source type identifier
TXN_SOURCE_ID	NUMBER		Transaction source identifier
TASK_ID	NUMBER		Task identifier
PROJECT_ID	NUMBER		Project identifier
ORGANIZATION_ID	NUMBER		Organization identifier
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
LAST_UPDATE_DATE	DATE	Yes	Standard who column
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
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
RN	NUMBER		Refresh Number
PRIMARY_QUANTITY	NUMBER		Quantity requested, in primary UOM
OWNING_ORGANIZATION_ID	NUMBER		Owning Organization identifier
OWNING_TP_TYPE	NUMBER		Owning trading partner type
PLANNING_ORGANIZATION_ID	NUMBER		Planning organization identifier
PLANNING_TP_TYPE	NUMBER		Planning trading partner type
HEADER_ID	NUMBER		Header identifier
TRANSACTION_TYPE_ID	NUMBER		Transaction type identifier

Query Text

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


SELECT TRANSACTION_SOURCE_TYPE_ID
,      TXN_SOURCE_ID
,      TASK_ID
,      PROJECT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RN
,      PRIMARY_QUANTITY
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      HEADER_ID
,      TRANSACTION_TYPE_ID
FROM MRP.MRP_AD_TXN_REQUEST_LINES;

Dependencies

[top of page]

MRP.MRP_AD_TXN_REQUEST_LINES does not reference any database object

MRP.MRP_AD_TXN_REQUEST_LINES is referenced by following:

APPS: MRP_AD_TXN_REQUEST_LINES