FND Design Data [Home] [Help]

View: PJM_REQ_COMMITMENTS_STUB_V

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

SELECT RPAD('*'
, 20
, ' ')
, RPAD('*'
, 80
, ' ')
, RPAD('*'
, 1
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, TO_DATE(NULL)
, TO_DATE(NULL)
, RPAD('*'
, 80
, ' ')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RPAD('*'
, 240
, ' ')
, RPAD('*'
, 15
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 15
, ' ')
, TO_DATE(NULL)
, RPAD('*'
, 30
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 25
, ' ')
, 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)
, RPAD('*'
, 240
, ' ')
, TO_NUMBER(NULL)
, RPAD('*'
, 340
, ' ')
, RPAD('*'
, 3
, ' ')
, RPAD('*'
, 25
, ' ')
FROM PA_IMPLEMENTATIONS_ALL
WHERE 1 = 2

Columns

Name
REQ_NUMBER
DOCUMENT_TYPE
APPROVED_FLAG
REQ_LINE
ITEM_DESCRIPTION
NEED_BY_DATE
CREATION_DATE
VENDOR_NAME
VENDOR_ID
REQUESTOR_PERSON_ID
REQUESTOR_NAME
DENOM_CURRENCY_CODE
DENOM_AMOUNT
ACCT_CURRENCY_CODE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
UNIT
UNIT_PRICE
QUANTITY
AMOUNT
PROJECT_NUMBER
PROJECT_NAME
TASK_NUMBER
TASK_NAME
EXPENDITURE_TYPE
EXPENDITURE_CATEGORY
REVENUE_CATEGORY
EXPENDITURE_ITEM_DATE
EXPENDITURE_ORGANIZATION
REQUISITION_HEADER_ID
REQUISITION_LINE_ID
REQ_DISTRIBUTION_ID
PROJECT_ID
TASK_ID
EXPENDITURE_ORGANIZATION_ID
INVENTORY_ITEM_ID
INVENTORY_ITEM_NAME
WIP_RESOURCE_ID
WIP_RESOURCE_NAME
UOM_CODE
UNIT_OF_MEASURE