Fast Formula Related queries

/*******Query to show context to the bind DBI*******/

SELECT UE.ROUTE_ID
,DBI.BASE_USER_NAME DBI_NAME
--,FRCU.CONTEXT_ID
,FCT.CONTEXT_NAME
FROM
FF_DATABASE_ITEMS_B DBI
,FF_USER_ENTITIES_B UE
,ff_route_context_usages FRCU
,FF_CONTEXTS_B FCB
,FF_CONTEXTS_TL FCT
WHERE 1=1
AND UE.USER_ENTITY_ID = DBI.USER_ENTITY_ID
AND DBI.BASE_USER_NAME = 'PER_ASG_ATTRIBUTE_DATE2'
/* FRCU*/
 AND FRCU.ROUTE_ID=UE.ROUTE_ID
 /*FCB*/
 AND FCB.CONTEXT_ID =FRCU.CONTEXT_ID
AND FCB.CONTEXT_ID =FCT.CONTEXT_ID
AND FCT.LANGUAGE = 'US'




Comments