[Home] [Help] [Dependency Information]
Object Name: | FV_RECEIPT_MASTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_RECEIPT_MASTER_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | Organization identifier | ||
SHIPMENT_HEADER_ID | NUMBER | Yes | Shipment header unique identifier | |
SHIPMENT_LINE_ID | NUMBER | Yes | Shipment line unique identifier | |
LINE_LOCATION_ID | NUMBER | Yes | ||
VENDOR_ID | NUMBER | Source supplier unique identifier | ||
VENDOR_SITE_ID | NUMBER | Source supplier site unique identifier | ||
RECEIPT_NUM | VARCHAR2 | (30) | Receipt number | |
RECEIPT_DATE | DATE | Yes | Receipt Date | |
QUANTITY_RECEIVED | NUMBER | Number of items received | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure of the shipment | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | (25) | Receipt status of the shipment line | |
PACKING_SLIP | VARCHAR2 | (25) | Packing slip number | |
SHIPMENT_NUM | VARCHAR2 | (30) | Shipment number assigned by the shipment's source | |
SHIP_DATE | DATE | Shipping date |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, LINE_LOCATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, RECEIPT_NUM
, RECEIPT_DATE
, QUANTITY_RECEIVED
, UNIT_OF_MEASURE
, ITEM_DESCRIPTION
, SHIPMENT_LINE_STATUS_CODE
, PACKING_SLIP
, SHIPMENT_NUM
, SHIP_DATE
FROM APPS.FV_RECEIPT_MASTER_V;
|
|
|