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')
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')
|
|
|