[Home] [Help] [Dependency Information]
Object Name: | GML_LN_RCV_ERV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GML.GML_LN_RCV_ERV |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View of Line level information of a receipt for ERES
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Group Id uniquely identifying a Receipt Group Transaction. | ||
INTERFACE_TRANSACTION_ID | NUMBER | Yes | Interface Transaction Id uniquely identifying a Receipt Line Transaction. | |
RECEIPT_NUM | VARCHAR2 | (30) | Receipt Number of the Receipt created. | |
LINE_NUM | VARCHAR2 | (0) | ||
ITEM_NO | VARCHAR2 | (40) | Item Number of the receipt line. | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description of the receipt line. | |
TRANSACTION_DATE | DATE | Yes | Receipt Transaction Date. | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name form which goods received. | |
VENDOR_ID | NUMBER | Vendor Id form which goods received. | ||
VENDOR_NO | VARCHAR2 | (30) | Vendor Number form which goods received. | |
SUBINVENTORY | VARCHAR2 | (10) | Subinventory in which goods are received. | |
LOCATOR_DESC | VARCHAR2 | (50) | Locator Description in which goods are received. | |
LOCATOR_ID | NUMBER | Locator Id in which goods are received. | ||
QUANTITY | NUMBER | Secondary Quantity received. | ||
UOM | VARCHAR2 | (25) | Secondary Unit of Measure in which Item is received. | |
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UOM | VARCHAR2 | (25) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code in which Receipt is created. | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization Name in which Receipt is created. |
VENDOR_LOT_NUM | VARCHAR2 | (30) | Vendor Lot Number on the Receipt. |
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_DESC
, LOCATOR_ID
, QUANTITY
, UOM
, SECONDARY_QUANTITY
, SECONDARY_UOM
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, VENDOR_LOT_NUM
FROM APPS.GML_LN_RCV_ERV;
APPS.GML_LN_RCV_ERV is not referenced by any database object
|
|
|