/*******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'
,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
Post a Comment