DBA Data[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