View: PSB_WORKFLOW_PROCESSES_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_WORKFLOW_PROCESSES_V

View Text

SELECT WP.ROWID
, WP.ITEM_KEY
, WP.WORKSHEET_ID
, WP.DOCUMENT_TYPE
, WP.PROCESS_TYPE
, WP.PROCESS_DATE
, WS.NAME
, LKUP.MEANING
FROM PSB_WORKFLOW_PROCESSES WP
, PSB_WORKSHEETS WS
, FND_LOOKUPS LKUP
WHERE WP.WORKSHEET_ID = WS.WORKSHEET_ID
AND ( WP.DOCUMENT_TYPE = 'BP' OR WP.DOCUMENT_TYPE IS NULL )
AND LKUP.LOOKUP_TYPE = 'PSB_WORKFLOW_PROCESS_TYPES'
AND LKUP.LOOKUP_CODE = WP.PROCESS_TYPE UNION SELECT WP.ROWID
, WP.ITEM_KEY
, WP.WORKSHEET_ID
, WP.DOCUMENT_TYPE
, WP.PROCESS_TYPE
, WP.PROCESS_DATE
, BR.JUSTIFICATION
, LKUP.MEANING
FROM PSB_WORKFLOW_PROCESSES WP
, PSB_BUDGET_REVISIONS BR
, FND_LOOKUPS LKUP
WHERE WP.DOCUMENT_TYPE = 'BR'
AND BR.BUDGET_REVISION_ID = WP.WORKSHEET_ID
AND LKUP.LOOKUP_TYPE = 'PSB_WORKFLOW_PROCESS_TYPES'
AND LKUP.LOOKUP_CODE = WP.PROCESS_TYPE

Columns