:$FLEX$.XX_ORG_NAME
useful queries for the same this type of value set-
(SELECT DISTINCT forecast_designator,ORGANIZATION_ID,forecast_set,ROW_NUMBER () OVER (PARTITION BY forecast_designator ORDER BY forecast_designator) rn FROM mrp_forecast_designators_v)
WHERE organization_id = NVL(:$FLEX$.XX_ORG_NAME, organization_id) AND forecast_set = 'KANBAN' AND rn =1
Friday, December 19, 2008
Subscribe to:
Posts (Atom)
