DBA Data[Home] [Help]

VIEW: APPS.AZ_PROCESSES_V

Source

View Text - Preformatted

SELECT ap.item_type, ap.process_name, ap.context_id, ap.parent_id, ap.display_order, ap.status_code, ap.process_type, ap.context_type, ap.context_name, ap.comments from az_processes ap where ap.process_type = nvl(FND_PROFILE.VALUE_WNPS('AZ_CURRENT_MODE'), 'IMP')
View Text - HTML Formatted

SELECT AP.ITEM_TYPE
, AP.PROCESS_NAME
, AP.CONTEXT_ID
, AP.PARENT_ID
, AP.DISPLAY_ORDER
, AP.STATUS_CODE
, AP.PROCESS_TYPE
, AP.CONTEXT_TYPE
, AP.CONTEXT_NAME
, AP.COMMENTS
FROM AZ_PROCESSES AP
WHERE AP.PROCESS_TYPE = NVL(FND_PROFILE.VALUE_WNPS('AZ_CURRENT_MODE')
, 'IMP')