[Home] [Help] [Dependency Information]
Object Name: | FV_PO_MASTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_PO_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 | ||
PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
PO_LINE_ID | NUMBER | Yes | Document line unique identifier | |
LINE_LOCATION_ID | NUMBER | Document shipment schedule unique identifier | ||
VENDOR_ID | NUMBER | Supplier unique identifier | ||
VENDOR_SITE_ID | NUMBER | Supplier site unique Identifier | ||
PO_RELEASE_ID | NUMBER | Release unique identifier | ||
PO_NUM | VARCHAR2 | (20) | Yes | Document number |
PO_DATE | DATE | Document CREATION DATE | ||
RELEASE_NUM | NUMBER | Document release number | ||
AGENT_ID | NUMBER | (9) | Yes | Buyer unique identifier |
APPROVED_FLAG | VARCHAR2 | (4000) | Indicates whether the purchase order is approved or not | |
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is cancelled or not | |
LINE_NUM | NUMBER | Yes | Document Line number | |
SHIPMENT_NUM | NUMBER | Document Shipment Number | ||
QUANTITY | NUMBER | Quantity ordered on the line | ||
QUANTITY_RECEIVED | NUMBER | Quanity Received | ||
QUANTITY_BILLED | NUMBER | Quantity Billed | ||
ITEM_ID | NUMBER | Item unique identifier | ||
CATEGORY_ID | NUMBER | Item category unique identifier | ||
UNIT_PRICE | NUMBER | Unit price for the line | ||
UOM | VARCHAR2 | (25) | Stores the base unit of measure (UOM) for the item ordered | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, PO_RELEASE_ID
, PO_NUM
, PO_DATE
, RELEASE_NUM
, AGENT_ID
, APPROVED_FLAG
, CANCEL_FLAG
, LINE_NUM
, SHIPMENT_NUM
, QUANTITY
, QUANTITY_RECEIVED
, QUANTITY_BILLED
, ITEM_ID
, CATEGORY_ID
, UNIT_PRICE
, UOM
, ITEM_DESCRIPTION
FROM APPS.FV_PO_MASTER_V;
APPS.FV_PO_MASTER_V is not referenced by any database object
|
|
|