SELECT ROWID, PROJECT_ACCOUNTING_CONTEXT, PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ITEM_DATE,
(DECODE (PROJECT_ACCOUNTING_CONTEXT,
'No', PROJECT_ACCOUNTING_CONTEXT,
'Yes', PROJECT_ACCOUNTING_CONTEXT || '.' || PROJECT_ID || '.' || TASK_ID || '.' || EXPENDITURE_TYPE || '.' || EXPENDITURE_ORGANIZATION_ID || '.' || EXPENDITURE_ITEM_DATE, NULL))
FROM PO_REQ_DISTRIBUTIONS_ALL
SELECT ROWID
, PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE
,
(DECODE (PROJECT_ACCOUNTING_CONTEXT
,
'NO'
, PROJECT_ACCOUNTING_CONTEXT
,
'YES'
, PROJECT_ACCOUNTING_CONTEXT || '.' || PROJECT_ID || '.' || TASK_ID || '.' || EXPENDITURE_TYPE || '.' || EXPENDITURE_ORGANIZATION_ID || '.' || EXPENDITURE_ITEM_DATE
, NULL))
FROM PO_REQ_DISTRIBUTIONS_ALL
|
|
|