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]

VIEW: APPS.RCV_FTE_TRANSACTIONS_V

Object Details

Object Name:	RCV_FTE_TRANSACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.RCV_FTE_TRANSACTIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TRANSACTION_ID	NUMBER		Unique transaction identifier
PARENT_TRANSACTION_ID	NUMBER		Transaction identifier of parent transaction
PARENT_TRANSACTION_TYPE	VARCHAR2	(25)	Type of parent transaction
TRANSACTION_TYPE	VARCHAR2	(25)	Type of transaction
TRANSACTION_DATE	DATE		Date of transaction
SHIPMENT_LINE_ID	NUMBER		Shipment line identifier
PO_UNIT_PRICE	NUMBER		Unit price indicated on purchase order
CURRENCY_CODE	VARCHAR2	(15)	Currency code for unit price
QC_GRADE	VARCHAR2	(150)	Quality grade of the Item received
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)	Country code from where the item originated
LPN_ID	NUMBER		License plate number identifier
LOCATOR_ID	NUMBER		Subinventory Locator Identifier
SUBINVENTORY	VARCHAR2	(10)	Subinventory
QUANTITY	NUMBER		Quantity
UOM_CODE	VARCHAR2	(3)	Unit of measure code for quantity
PRIMARY_QUANTITY	NUMBER		Primary quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)	Unit of measure code for primary quantity
SECONDARY_QUANTITY	NUMBER		Secondary quantity
SECONDARY_UOM_CODE	VARCHAR2	(3)	Unit of measure code for secondary quantity
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		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 TRANSACTION_ID
,      PARENT_TRANSACTION_ID
,      PARENT_TRANSACTION_TYPE
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      SHIPMENT_LINE_ID
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      QC_GRADE
,      COUNTRY_OF_ORIGIN_CODE
,      LPN_ID
,      LOCATOR_ID
,      SUBINVENTORY
,      QUANTITY
,      UOM_CODE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      SECONDARY_QUANTITY
,      SECONDARY_UOM_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.RCV_FTE_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.RCV_FTE_TRANSACTIONS_V references the following:

APPS: MTL_UNITS_OF_MEASURE; RCV_TRANSACTIONS

APPS.RCV_FTE_TRANSACTIONS_V is referenced by following:

APPS: WSH_IB_UI_RECON_GRP - show dependent code