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

VIEW: APPS.PJM_PROJECT_BLANKET_PO_V

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

View Type

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


PJM_PROJECT_BLANKET_PO_V returns project-related blanket purchase releases.
This view corresponds to the Blanket PO 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
DOCUMENT_TYPE VARCHAR2 (4000)
Procurement document type
PO_RELEASE_ID NUMBER
Yes Blanket purchase release unique identifier
RELEASE_NUMBER NUMBER
Yes Blanket release number
LINE_NUMBER NUMBER
Yes Blanket release line number
SHIPMENT_NUMBER NUMBER

Blanket release shipment number
DISTRIBUTION_NUMBER NUMBER
Yes Blanket release distribution number
REVISION_NUMBER NUMBER

Blanket release revision number
REVISED_DATE DATE

Last revision date
ORDER_DATE DATE
Yes Date ordered
PRINTED_DATE DATE

Date printed
STATUS VARCHAR2 (4000)
Document status
CLOSURE_STATUS VARCHAR2 (4000)
Document closure status
SUPPLIER_ID NUMBER

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

Supplier contact unique identifier
SUPPLIER_CONTACT_NAME VARCHAR2 (4000)
Supplier contact 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_NAME VARCHAR2 (4000)
Ship-to location
SHIP_VIA VARCHAR2 (25)
Type of carrier
FREIGHT_TERMS VARCHAR2 (4000)
Freight terms
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_NAME VARCHAR2 (4000)
Bill-to location
PAYMENT_TERM_ID NUMBER

Payment terms unique identifier
PAYMENT_TERMS VARCHAR2 (4000)
Payment terms
CURRENCY VARCHAR2 (15)
Currency used on blanket release
AMOUNT VARCHAR2 (4000)
Blanket release 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

Org Id
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      DOCUMENT_TYPE
,      PO_RELEASE_ID
,      RELEASE_NUMBER
,      LINE_NUMBER
,      SHIPMENT_NUMBER
,      DISTRIBUTION_NUMBER
,      REVISION_NUMBER
,      REVISED_DATE
,      ORDER_DATE
,      PRINTED_DATE
,      STATUS
,      CLOSURE_STATUS
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_NAME
,      SHIP_VIA
,      FREIGHT_TERMS
,      FOB
,      BUYER_ID
,      BUYER_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_NAME
,      PAYMENT_TERM_ID
,      PAYMENT_TERMS
,      CURRENCY
,      AMOUNT
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      END_ITEM_UNIT_NUMBER
,      ORG_ID
FROM APPS.PJM_PROJECT_BLANKET_PO_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_BLANKET_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
PL/SQL PackagePO_INQ_SV - show dependent code
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL

APPS.PJM_PROJECT_BLANKET_PO_V is not referenced by any database object