[Home] [Help]
VIEW: APPS.AZ_FLOW_PHASES_V
Source
View Text - Preformatted
SELECT distinct azpf.item_type, azpf.process_name, azpp.phase from az_product_flows azpf, az_product_phases azpp where azpf.application_id = azpp.application_id
View Text - HTML Formatted
SELECT DISTINCT AZPF.ITEM_TYPE
, AZPF.PROCESS_NAME
, AZPP.PHASE
FROM AZ_PRODUCT_FLOWS AZPF
, AZ_PRODUCT_PHASES AZPP
WHERE AZPF.APPLICATION_ID = AZPP.APPLICATION_ID