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

VIEW: APPS.PJM_PO_COMMITMENTS_BASIC_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


PJM_PO_COMMITMENTS_BASIC_V returns project-related purchase order distributions in Oracle Purchasing which have a destination of Inventory or Shop Floor and have not yet been received.
This view is similar to PJM_PO_COMMITMENTS_CMPRJ_V, but has been simplified by removing common project logic for better performance.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_NUMBER VARCHAR2 (20) Yes Purchase order number
PO_REVISION NUMBER

Purchase order revision
RELEASE_NUMBER NUMBER

Purchase release number
RELEASE_REVISION NUMBER

Purchase release revision
APPROVED_FLAG VARCHAR2 (1)
Flag indicating purchase order is approved
EVER_APPROVED_FLAG VARCHAR2 (1)
Flag indicating whether purchase order has ever been approved
DOCUMENT_TYPE VARCHAR2 (4000)
Procurement document type
CREATION_DATE DATE

Standard Who column
APPROVED_DATE DATE

Date purchase order is approved
PRINTED_DATE DATE

Date purchase order is printed
REQUESTOR_PERSON_ID NUMBER (9)
Requestor unique identifier
REQUESTOR_NAME VARCHAR2 (4000)
Requestor name
BUYER_PERSON_ID NUMBER (9) Yes Buyer employee unique identifier
BUYER_NAME VARCHAR2 (4000)
Buyer employee name
VENDOR_NAME VARCHAR2 (4000)
Supplier name
VENDOR_ID NUMBER

Supplier unique identifier
PO_LINE NUMBER
Yes Purchase order line
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
UNIT VARCHAR2 (4000)
Unit of measure
UNIT_PRICE NUMBER

Cost per unit of the project-related commitment distribution
DENOM_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
ACCT_CURRENCY_CODE VARCHAR2 (15) Yes Functional currency code
ACCT_RATE_DATE DATE

Functional currency exchange rate date
ACCT_RATE_TYPE VARCHAR2 (30)
Functional currency exchange rate type
ACCT_EXCHANGE_RATE NUMBER

Exchange rate to functional currency
QUANTITY_ORDERED NUMBER

Distribution quantity ordered for this purchase order commitment
AMOUNT_ORDERED NUMBER

Distribution amount ordered for this purchase order commitment
ORIGINAL_QUANTITY_ORDERED NUMBER

Distribution original quantity ordered for this purchase order commitment
ORIGINAL_AMOUNT_ORDERED NUMBER

Distribution original amount ordered for this purchase order commitment
QUANTITY_CANCELLED NUMBER

Distribution quantity cancelled on this purchase order commitment
AMOUNT_CANCELLED NUMBER

Distribution amount cancelled on this purchase order commitment
QUANTITY_DELIVERED NUMBER

Distribution quantity delivered for this purchase order commitment
DENOM_AMOUNT_DELIVERED NUMBER

Distribution amount delivered in purchase order currency for this purchase order commitment
AMOUNT_DELIVERED NUMBER

Distribution amount delivered in functional currency for this purchase order commitment
QUANTITY_INVOICED NUMBER

Distribution quantity invoiced for this purchase order commitment
AMOUNT_INVOICED NUMBER

Distribution amount invoiced for this purchase order commitment
QUANTITY_OUTSTANDING_DELIVERY NUMBER

Distribution quantity outstanding delivery for this purchase order commitment
DENOM_AMT_OUTSTANDING_DELIVERY NUMBER

Distribution amount outstanding delivery in purchase order currency for this purchase order commitment
AMOUNT_OUTSTANDING_DELIVERY NUMBER

Distribution amount outstanding delivery for this purchase order commitment
QUANTITY_OUTSTANDING_INVOICE NUMBER

Distribution quantity outstanding invoice for this purchase order commitment
DENOM_AMT_OUTSTANDING_INVOICE NUMBER

Distribution amount outstanding invoice in purchase order currency for this purchase order commitment
AMOUNT_OUTSTANDING_INVOICE NUMBER

Distribution amount outstanding invoice for this purchase order commitment
QUANTITY_OVERBILLED NUMBER

Distribution quantity overbilled for this purchase order commitment
AMOUNT_OVERBILLED NUMBER

Distribution amount overbilled for this purchase order commitment
PROJECT_NUMBER VARCHAR2 (25) Yes User-entered number that uniquely identifies a project or seiban
PROJECT_NAME VARCHAR2 (30) Yes User-entered project / seiban name
TASK_NUMBER VARCHAR2 (25) Yes User-entered string that uniquely identifies a task within a project
TASK_NAME VARCHAR2 (20) Yes User-entered task name
EXPENDITURE_TYPE VARCHAR2 (30) Yes Commitment expenditure type
EXPENDITURE_CATEGORY VARCHAR2 (30) Yes Expenditure category of the commitment
REVENUE_CATEGORY VARCHAR2 (30) Yes Revenue category of the commitment
EXPENDITURE_ITEM_DATE DATE

Date on which you expect to incur the commitment costs
EXPENDITURE_ORGANIZATION VARCHAR2 (240) Yes Expenditure organization incurring the commitment
PO_HEADER_ID NUMBER
Yes Purchase order header unique identifier
PO_RELEASE_ID NUMBER

Blanket purchase release unique identifier
PO_LINE_ID NUMBER
Yes Purchase order line unique identifier
PO_LINE_LOCATION_ID NUMBER
Yes Purchase order line shipment unique identifier
PO_DISTRIBUTION_ID NUMBER
Yes Purchase order distribution unique identifier
PROJECT_ID NUMBER (15) Yes System-generated number that uniquely identifies a project or seiban
TASK_ID NUMBER (15) Yes Task unique identifier
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes Unique identifier of the expenditure organization incurring the commitment
PROMISED_DATE DATE

Purchase order promised date
NEED_BY_DATE DATE

Purchase order need-by date
INVENTORY_ITEM_ID NUMBER

Inventory item unique identifier
INVENTORY_ITEM_NAME VARCHAR2 (4000)
Item Name
WIP_RESOURCE_ID NUMBER

Resource unique identifier
WIP_RESOURCE_NAME VARCHAR2 (4000)
Resource name
UOM_CODE VARCHAR2 (4000)
Code for Unit of Measure
UNIT_OF_MEASURE VARCHAR2 (4000)
Unit of Measure
Query Text

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


SELECT PO_NUMBER
,      PO_REVISION
,      RELEASE_NUMBER
,      RELEASE_REVISION
,      APPROVED_FLAG
,      EVER_APPROVED_FLAG
,      DOCUMENT_TYPE
,      CREATION_DATE
,      APPROVED_DATE
,      PRINTED_DATE
,      REQUESTOR_PERSON_ID
,      REQUESTOR_NAME
,      BUYER_PERSON_ID
,      BUYER_NAME
,      VENDOR_NAME
,      VENDOR_ID
,      PO_LINE
,      ITEM_DESCRIPTION
,      UNIT
,      UNIT_PRICE
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      QUANTITY_ORDERED
,      AMOUNT_ORDERED
,      ORIGINAL_QUANTITY_ORDERED
,      ORIGINAL_AMOUNT_ORDERED
,      QUANTITY_CANCELLED
,      AMOUNT_CANCELLED
,      QUANTITY_DELIVERED
,      DENOM_AMOUNT_DELIVERED
,      AMOUNT_DELIVERED
,      QUANTITY_INVOICED
,      AMOUNT_INVOICED
,      QUANTITY_OUTSTANDING_DELIVERY
,      DENOM_AMT_OUTSTANDING_DELIVERY
,      AMOUNT_OUTSTANDING_DELIVERY
,      QUANTITY_OUTSTANDING_INVOICE
,      DENOM_AMT_OUTSTANDING_INVOICE
,      AMOUNT_OUTSTANDING_INVOICE
,      QUANTITY_OVERBILLED
,      AMOUNT_OVERBILLED
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      PROMISED_DATE
,      NEED_BY_DATE
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      WIP_RESOURCE_ID
,      WIP_RESOURCE_NAME
,      UOM_CODE
,      UNIT_OF_MEASURE
FROM APPS.PJM_PO_COMMITMENTS_BASIC_V;

Dependencies

[top of page]

APPS.PJM_PO_COMMITMENTS_BASIC_V references the following:

SchemaAPPS
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPA_EXPENDITURE_TYPES
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
PL/SQL PackagePJM_COMMITMENT_UTILS - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL

APPS.PJM_PO_COMMITMENTS_BASIC_V is not referenced by any database object