VIEW: APPS.PO_REQ_DISTRIBUTIONS_ALL_DFV

Source

View Text - Preformatted

SELECT ROWID, PROJECT_ACCOUNTING_CONTEXT, (DECODE (PROJECT_ACCOUNTING_CONTEXT, 'Yes', PROJECT_ID, NULL)), (DECODE (PROJECT_ACCOUNTING_CONTEXT, 'Yes', TASK_ID, NULL)), (DECODE (PROJECT_ACCOUNTING_CONTEXT, 'Yes', EXPENDITURE_TYPE, NULL)), (DECODE (PROJECT_ACCOUNTING_CONTEXT, 'Yes', EXPENDITURE_ORGANIZATION_ID, NULL)), (DECODE (PROJECT_ACCOUNTING_CONTEXT, 'Yes', EXPENDITURE_ITEM_DATE, NULL)),  
 (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

View Text - HTML Formatted

SELECT ROWID
, PROJECT_ACCOUNTING_CONTEXT
, (DECODE (PROJECT_ACCOUNTING_CONTEXT
, 'YES'
, PROJECT_ID
, NULL))
, (DECODE (PROJECT_ACCOUNTING_CONTEXT
, 'YES'
, TASK_ID
, NULL))
, (DECODE (PROJECT_ACCOUNTING_CONTEXT
, 'YES'
, EXPENDITURE_TYPE
, NULL))
, (DECODE (PROJECT_ACCOUNTING_CONTEXT
, 'YES'
, EXPENDITURE_ORGANIZATION_ID
, NULL))
, (DECODE (PROJECT_ACCOUNTING_CONTEXT
, 'YES'
, EXPENDITURE_ITEM_DATE
, NULL))
, (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