DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.RCV_TRX_INT_LOTS_V

Object Details
Object Name: RCV_TRX_INT_LOTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.RCV_TRX_INT_LOTS_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 Mandatory Comments
LOT_NUMBER VARCHAR2 (80) Yes
EXPIRATION_DATE DATE


SHIPMENT_LINE_ID NUMBER


TO_ORGANIZATION_ID NUMBER


ITEM_ID NUMBER


ORDER_QUANTITY NUMBER


LOT_QUANTITY NUMBER


Query Text

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


SELECT LOT_NUMBER
,      EXPIRATION_DATE
,      SHIPMENT_LINE_ID
,      TO_ORGANIZATION_ID
,      ITEM_ID
,      ORDER_QUANTITY
,      LOT_QUANTITY
FROM APPS.RCV_TRX_INT_LOTS_V;

Dependencies

[top of page]

APPS.RCV_TRX_INT_LOTS_V references the following:

SchemaAPPS
SynonymRCV_LOTS_SUPPLY
SynonymRCV_SHIPMENT_LINES
ViewRCV_UNPROCESSED_LOTS_V

APPS.RCV_TRX_INT_LOTS_V is not referenced by any database object