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_MSL_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE_TYPE	VARCHAR2	(9)	Needed to identify the source type (internal or asn) at the line level
ROW_ID	ROWID	(10)
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE		Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure definition 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
CHARGE_ACCOUNT_ID	NUMBER
COMMENTS	VARCHAR2	(4000)
DELIVER_TO_LOCATION_ID	NUMBER
DELIVER_TO_PERSON_ID	NUMBER	(9)
DESTINATION_CONTEXT	VARCHAR2	(30)
DESTINATION_TYPE_CODE	VARCHAR2	(25)
DESTINATION_TYPE	VARCHAR2	(80)
EMPLOYEE_ID	NUMBER	(9)
FROM_ORGANIZATION_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
HAZARD_CLASS	VARCHAR2	(40)
UN_NUMBER	VARCHAR2	(25)
LINE_NUM	NUMBER
ITEM_CATEGORY_ID	NUMBER
LOCATOR_ID	NUMBER
NEED_BY_DATE	DATE
PACKING_SLIP	VARCHAR2	(25)
QUANTITY_RECEIVED	NUMBER
QUANTITY_SHIPPED	NUMBER
REQUISITION_LINE_ID	NUMBER
REQUISITION_HEADER_ID	NUMBER
ORDER_NUM	VARCHAR2	(50)
ORDER_LINE_NUM	VARCHAR2	(240)
REQ_DISTRIBUTION_ID	NUMBER
SHIPMENT_HEADER_ID	NUMBER
SHIPMENT_LINE_ID	NUMBER
SHIPMENT_LINE_STATUS_CODE	VARCHAR2	(25)
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)
SOURCE_DOCUMENT_TYPE	VARCHAR2	(80)
TO_ORGANIZATION_ID	NUMBER
TO_SUBINVENTORY	VARCHAR2	(10)
TRANSFER_COST	NUMBER
TRANSPORTATION_ACCOUNT_ID	NUMBER
TRANSPORTATION_COST	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
UOM_CONVERSION_RATE	NUMBER
ROUTING_HEADER_ID	NUMBER
ROUTING_NAME	VARCHAR2	(80)
REASON_ID	NUMBER
REASON_NAME	VARCHAR2	(30)
LOCATION_CODE	VARCHAR2	(60)
DELIVER_TO_PERSON	VARCHAR2	(240)
PO_HEADER_ID	NUMBER		Needed for maintain shipments
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
PO_RELEASE_ID	NUMBER
RELEASE_NUM	NUMBER
VENDOR_NAME	VARCHAR2	(240)
VENDOR_SITE_CODE	VARCHAR2	(15)
SHIP_TO_LOCATION_ID	NUMBER
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
VENDOR_ID	NUMBER
BAR_CODE_LABEL	VARCHAR2	(35)
TRUCK_NUM	VARCHAR2	(35)
CONTAINER_NUM	VARCHAR2	(35)
VENDOR_LOT_NUM	VARCHAR2	(30)
SECONDARY_QUANTITY_RECEIVED	NUMBER
SECONDARY_QUANTITY_SHIPPED	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)	Secondary Unit Of Measure of the Item
QC_GRADE	VARCHAR2	(150)	Quality Grade of the Item
ORG_ID	NUMBER		Organization identifier
ASN_LPN_ID	NUMBER		ASN LPN Identifier
ASN_LPN	VARCHAR2	(30)	ASN LPN
OUTER_LPN_ID	NUMBER		Outermost LPN Identifier
OUTER_LPN	VARCHAR2	(30)	Outermost LPN

Query Text

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


SELECT SOURCE_TYPE
,      ROW_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CHARGE_ACCOUNT_ID
,      COMMENTS
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      DESTINATION_CONTEXT
,      DESTINATION_TYPE_CODE
,      DESTINATION_TYPE
,      EMPLOYEE_ID
,      FROM_ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      ITEM_ID
,      ITEM_REVISION
,      HAZARD_CLASS
,      UN_NUMBER
,      LINE_NUM
,      ITEM_CATEGORY_ID
,      LOCATOR_ID
,      NEED_BY_DATE
,      PACKING_SLIP
,      QUANTITY_RECEIVED
,      QUANTITY_SHIPPED
,      REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      ORDER_NUM
,      ORDER_LINE_NUM
,      REQ_DISTRIBUTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SHIPMENT_LINE_STATUS_CODE
,      SOURCE_DOCUMENT_CODE
,      SOURCE_DOCUMENT_TYPE
,      TO_ORGANIZATION_ID
,      TO_SUBINVENTORY
,      TRANSFER_COST
,      TRANSPORTATION_ACCOUNT_ID
,      TRANSPORTATION_COST
,      UNIT_OF_MEASURE
,      UOM_CONVERSION_RATE
,      ROUTING_HEADER_ID
,      ROUTING_NAME
,      REASON_ID
,      REASON_NAME
,      LOCATION_CODE
,      DELIVER_TO_PERSON
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_RELEASE_ID
,      RELEASE_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      SHIP_TO_LOCATION_ID
,      PRIMARY_UNIT_OF_MEASURE
,      VENDOR_ID
,      BAR_CODE_LABEL
,      TRUCK_NUM
,      CONTAINER_NUM
,      VENDOR_LOT_NUM
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      ORG_ID
,      ASN_LPN_ID
,      ASN_LPN
,      OUTER_LPN_ID
,      OUTER_LPN
FROM APPS.RCV_MSL_V;

Dependencies

[top of page]

APPS.RCV_MSL_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS; MTL_TRANSACTION_REASONS; PER_ALL_PEOPLE_F; PO_CLM_INTG_GRP - show dependent code; PO_HAZARD_CLASSES; PO_HEADERS_TRX_V; PO_LINES_TRX_V; PO_LINE_LOCATIONS_TRX_V; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_REQ_HEADERS_TRX_V; PO_REQ_LINES_TRX_V; PO_UN_NUMBERS; PO_VENDORS; PO_VENDOR_SITES; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS_INTERFACE; WMS_LICENSE_PLATE_NUMBERS

APPS.RCV_MSL_V is not referenced by any database object