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


VIEW: APPS.PJM_PROJECT_PO_V

Object Details
Object Name: PJM_PROJECT_PO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_PROJECT_PO_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


PJM_PROJECT_PO_V returns project-related purchase order information.
This view corresponds to the Purchase Order Summary web inquiry region.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

System-generated number that uniquely identifies a project or seiban
TASK_ID NUMBER

System-generated number that uniquely identifies a task
PO_HEADER_ID NUMBER
Yes Purchase order header unique identifier
PO_NUMBER VARCHAR2 (20) Yes Purchase order number
LINE_NUMBER NUMBER
Yes Purchase order line number
SHIPMENT_NUMBER NUMBER

Purchase order shipment number
DISTRIBUTION_NUMBER NUMBER
Yes Purchase order distribution number
DOCUMENT_TYPE VARCHAR2 (4000)
Procurement document type
REVISION_NUMBER NUMBER

Purchase order revision number
REVISED_DATE DATE

Latest revision date
ORDER_DATE DATE

Purchase order date
STATUS VARCHAR2 (4000)
Order status
SUPPLIER_ID NUMBER

Supplier unique identifier
SUPPLIER_NAME VARCHAR2 (4000)
Supplier name
SUPPLIER_SITE_ID NUMBER

Supplier site unique identifier
SUPPLIER_SITE_NAME VARCHAR2 (4000)
Supplier site
SHIP_TO_LOCATION_ID NUMBER

Ship-to location unique identifier
SHIP_TO_LOCATION_NAME VARCHAR2 (4000)
Ship-to location
SHIP_VIA VARCHAR2 (25)
Type of carrier
FREIGHT_TERM VARCHAR2 (4000)
Type of freight terms for the document
FOB VARCHAR2 (4000)
Free-on-board terms
BUYER_ID NUMBER (9) Yes Buyer employee unique identifier
BUYER_NAME VARCHAR2 (4000)
Buyer employee name
BILL_TO_LOCATION_ID NUMBER

Bill-to location unique identifier
BILL_TO_LOCATION_NAME VARCHAR2 (4000)
Bill-to location
TERM_ID NUMBER

Payment terms unique identifier
PAYMENT_TERM VARCHAR2 (4000)
Payment terms
CURRENCY VARCHAR2 (15)
Purchase order currency
AMOUNT VARCHAR2 (4000)
Purchase order amount
ITEM_NUMBER VARCHAR2 (4000)
Item number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item model/unit number
ORG_ID NUMBER

Operating unit unique identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      LINE_NUMBER
,      SHIPMENT_NUMBER
,      DISTRIBUTION_NUMBER
,      DOCUMENT_TYPE
,      REVISION_NUMBER
,      REVISED_DATE
,      ORDER_DATE
,      STATUS
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_NAME
,      SHIP_VIA
,      FREIGHT_TERM
,      FOB
,      BUYER_ID
,      BUYER_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_NAME
,      TERM_ID
,      PAYMENT_TERM
,      CURRENCY
,      AMOUNT
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      END_ITEM_UNIT_NUMBER
,      ORG_ID
FROM APPS.PJM_PROJECT_PO_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_PO_V references the following:

SchemaAPPS
PL/SQL PackageFND_CURRENCY_CACHE - show dependent code
PL/SQL PackagePJM_INQUIRY - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.PJM_PROJECT_PO_V is not referenced by any database object