VIEW: APPS.RCI_BP_ORG_CERT_RESULT_V

Source

View Text - Preformatted

SELECT b.OPINION_VALUE_CODE id, tl.OPINION_VALUE_NAME value from AMW_OPINION_VALUES_B b, AMW_OPINION_VALUES_TL tl, amw_opinion_types_b aotb, amw_opinion_componts_b aocb, amw_object_opinion_types aoot, fnd_objects fo WHERE b.OPINION_VALUE_ID = tl.OPINION_VALUE_ID and tl.LANGUAGE = userenv('LANG') and (b.END_DATE is null or b.END_DATE >= sysdate) and b.OPINION_COMPONENT_ID=aocb.OPINION_COMPONENT_ID and aocb.OBJECT_OPINION_TYPE_ID = aoot.object_opinion_type_id and aoot.object_id=fo.object_id and aotb.OPINION_TYPE_ID=aoot.OPINION_TYPE_ID and aotb.OPINION_TYPE_CODE='CERTIFICATION' and fo.obj_name='AMW_ORGANIZATION' union all select al.LOOKUP_CODE id, al.MEANING value from amw_lookups al where al.LOOKUP_TYPE='RCI_CERT_EVAL_STATUS' and al.LOOKUP_CODE='NOT_CERTIFIED'

View Text - HTML Formatted

SELECT B.OPINION_VALUE_CODE ID
, TL.OPINION_VALUE_NAME VALUE
FROM AMW_OPINION_VALUES_B B
, AMW_OPINION_VALUES_TL TL
, AMW_OPINION_TYPES_B AOTB
, AMW_OPINION_COMPONTS_B AOCB
, AMW_OBJECT_OPINION_TYPES AOOT
, FND_OBJECTS FO
WHERE B.OPINION_VALUE_ID = TL.OPINION_VALUE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.END_DATE IS NULL OR B.END_DATE >= SYSDATE)
AND B.OPINION_COMPONENT_ID=AOCB.OPINION_COMPONENT_ID
AND AOCB.OBJECT_OPINION_TYPE_ID = AOOT.OBJECT_OPINION_TYPE_ID
AND AOOT.OBJECT_ID=FO.OBJECT_ID
AND AOTB.OPINION_TYPE_ID=AOOT.OPINION_TYPE_ID
AND AOTB.OPINION_TYPE_CODE='CERTIFICATION'
AND FO.OBJ_NAME='AMW_ORGANIZATION' UNION ALL SELECT AL.LOOKUP_CODE ID
, AL.MEANING VALUE
FROM AMW_LOOKUPS AL
WHERE AL.LOOKUP_TYPE='RCI_CERT_EVAL_STATUS'
AND AL.LOOKUP_CODE='NOT_CERTIFIED'