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

VIEW: APPS.RCV_LN_RCV_ERV

Object Details
Object Name: RCV_LN_RCV_ERV
Object Type: VIEW
Owner: APPS
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
GROUP_ID NUMBER

Interface processing group identifier
INTERFACE_TRANSACTION_ID NUMBER
Yes Interface transaction unique identifier
RECEIPT_NUM VARCHAR2 (30)
Receipt number
LINE_NUM VARCHAR2 (0)

ITEM_NO VARCHAR2 (40)

ITEM_DESCRIPTION VARCHAR2 (240)

TRANSACTION_DATE DATE
Yes
VENDOR_NAME VARCHAR2 (240)

VENDOR_ID NUMBER


VENDOR_NO VARCHAR2 (30)

SUBINVENTORY VARCHAR2 (10)

LOCATOR VARCHAR2 (50)

LOCATOR_ID NUMBER


QUANTITY NUMBER


UOM VARCHAR2 (25)

SECONDARY_QUANTITY NUMBER


SECONDARY_UOM VARCHAR2 (25)

ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240) Yes
VENDOR_LOT_NUM VARCHAR2 (30)

Query Text

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


SELECT GROUP_ID
,      INTERFACE_TRANSACTION_ID
,      RECEIPT_NUM
,      LINE_NUM
,      ITEM_NO
,      ITEM_DESCRIPTION
,      TRANSACTION_DATE
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_NO
,      SUBINVENTORY
,      LOCATOR
,      LOCATOR_ID
,      QUANTITY
,      UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      VENDOR_LOT_NUM
FROM APPS.RCV_LN_RCV_ERV;

Dependencies

[top of page]

APPS.RCV_LN_RCV_ERV references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_LOT_ERES_GTMP
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewPO_VENDORS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_TRANSACTIONS_INTERFACE

APPS.RCV_LN_RCV_ERV is not referenced by any database object