[Home] [Help]
VIEW: APPS.GCS_FINANCIAL_ITEMS_HIER_V
Source
View Text - Preformatted
SELECT 1000000000+ghb.hierarchy_id, ghb.hierarchy_id, 1, null from gcs_hierarchies_b ghb WHERE ghb.certification_flag = 'Y'
View Text - HTML Formatted
SELECT 1000000000+GHB.HIERARCHY_ID
, GHB.HIERARCHY_ID
, 1
, NULL
FROM GCS_HIERARCHIES_B GHB
WHERE GHB.CERTIFICATION_FLAG = 'Y'