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

VIEW: APPS.FV_PO_MASTER_V

Object Details
Object Name: FV_PO_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_PO_MASTER_V
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 Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.FV_PO_MASTER_V references the following:

SchemaAPPS
SynonymPO_HEADERS
PL/SQL PackagePO_HEADERS_SV3 - show dependent code
SynonymPO_LINES
SynonymPO_LINE_LOCATIONS
SynonymPO_RELEASES

APPS.FV_PO_MASTER_V is not referenced by any database object