FND Design Data [Home] [Help]

View: PJM_PO_COMMITMENTS_STUB_V

Product: PJM - Project Manufacturing
Description: Project-related unreceived purchase order distributions view for non-project manufacturing customers
Implementation/DBA Data: ViewAPPS.PJM_PO_COMMITMENTS_STUB_V
View Text

SELECT RPAD('*'
, 20
, ' ')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 1
, ' ')
, RPAD('*'
, 1
, ' ')
, RPAD('*'
, 80
, ' ')
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, RPAD('*'
, 80
, ' ')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, RPAD('*'
, 25
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 15
, ' ')
, RPAD('*'
, 15
, ' ')
, TO_DATE(NULL)
, RPAD('*'
, 30
, ' ')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 25
, ' ')
, RPAD('*'
, 30
, ' ')
, RPAD('*'
, 25
, ' ')
, RPAD('*'
, 20
, ' ')
, RPAD('*'
, 30
, ' ')
, RPAD('*'
, 30
, ' ')
, RPAD('*'
, 30
, ' ')
, TO_DATE(NULL)
, RPAD('*'
, 60
, ' ')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, RPAD('*'
, 3
, ' ')
, RPAD('*'
, 25
, ' ')
FROM PA_IMPLEMENTATIONS_ALL
WHERE 1 = 2

Columns

Name
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