VIEW: APPS.PSB_WORKFLOW_PROCESSES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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