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_LINES_V

Object Details

Object Name:	RCV_FTE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.RCV_FTE_LINES_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	Mandatory	Comments
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment header unique identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment line unique identifier
ASN_LINE_FLAG	VARCHAR2	(1)		Indicates whether item is on an Advance Shipment Notice (ASN). Used by missing ASN Items Processor to determine whether shipped items were received.
PO_HEADER_ID	NUMBER			Purchase order header unique identifier
PO_LINE_ID	NUMBER			Purchase order line unique identifier
PO_LINE_LOCATION_ID	NUMBER			Purchase order shipment unique identifier
ITEM_ID	NUMBER			Item identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
TRUCK_NUM	VARCHAR2	(35)		Number of the truck
QUANTITY_SHIPPED	NUMBER			Number of items shipped
QUANTITY_RECEIVED	NUMBER			Number of items received
SHIP_TO_LOCATION_ID	NUMBER			Unique identifier for the ship-to location
PACKING_SLIP	VARCHAR2	(25)		Packing slip number
PO_RELEASE_ID	NUMBER			Purchase order release unique identifier
CONTAINER_NUM	VARCHAR2	(35)		Unique container identifier for the line
LINE_NUM	NUMBER		Yes	Shipment line number
SHIPMENT_UNIT_PRICE	NUMBER			Item unit price
SECONDARY_QUANTITY_SHIPPED	NUMBER			Quantity of item shipped in secondary unit of measure
SECONDARY_QUANTITY_RECEIVED	NUMBER			Quantity received in secondary unit of measure
PO_SEGMENT1	VARCHAR2	(20)	Yes	Document number
PO_SHIPMENT_NUM	NUMBER			Shipment line number
PO_SHIP_TO_LOCATION_ID	NUMBER			Unique identifier for the ship-to location
PO_LINE_NUMBER	NUMBER		Yes	Line number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORGANIZATION_ID	NUMBER			Destination organization unique identifier
UOM_CODE	VARCHAR2	(3)		Unit of measure code for quantity
SECONDARY_UOM_CODE	VARCHAR2	(3)		Unit of measure code for secondary quantity
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure for quantity
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure for secondary quantity
REVISION_NUM	NUMBER			Document revision number
ASN_LPN_ID	NUMBER			The lpn_id for ASNs only
SHIP_FROM_LOCATION_ID	NUMBER			Ship from location unique identifier

Query Text

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


SELECT SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      ASN_LINE_FLAG
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      ITEM_ID
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      TRUCK_NUM
,      QUANTITY_SHIPPED
,      QUANTITY_RECEIVED
,      SHIP_TO_LOCATION_ID
,      PACKING_SLIP
,      PO_RELEASE_ID
,      CONTAINER_NUM
,      LINE_NUM
,      SHIPMENT_UNIT_PRICE
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_QUANTITY_RECEIVED
,      PO_SEGMENT1
,      PO_SHIPMENT_NUM
,      PO_SHIP_TO_LOCATION_ID
,      PO_LINE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      ORGANIZATION_ID
,      UOM_CODE
,      SECONDARY_UOM_CODE
,      UNIT_OF_MEASURE
,      SECONDARY_UNIT_OF_MEASURE
,      REVISION_NUM
,      ASN_LPN_ID
,      SHIP_FROM_LOCATION_ID
FROM APPS.RCV_FTE_LINES_V;

Dependencies

[top of page]

APPS.RCV_FTE_LINES_V references the following:

APPS: MTL_UNITS_OF_MEASURE_VL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES_B; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES

APPS.RCV_FTE_LINES_V is referenced by following:

APPS: WSH_IB_UI_RECON_GRP - show dependent code; WSH_INBOUND_UTIL_PKG - show dependent code; WSH_PO_CMG_PVT - show dependent code