VIEW: APPS.OE_NOTES_RULES_V

Source

View Text - Preformatted

SELECT oar.rule_id ,oar.document_id ,oar.data_object_code ,fde.application_id ,fde.table_name data_object_table_name ,fde.pk1_column data_object_pk1_column ,fde.pk2_column data_object_pk2_column ,fde.pk3_column data_object_pk3_column ,fde.pk4_column data_object_pk4_column ,fde.pk5_column data_object_pk5_column ,oare.rule_element_id ,oare.group_number ,oare.object_ref_id ,oref.object_ref_type ,oref.column_name object_ref_column_name ,oref.column_datatype object_ref_column_datatype ,oare.object_ref_value FROM oe_notes_rules oar, oe_notes_rule_elements oare, fnd_document_entities fde, oe_notes_object_refs oref WHERE oar.data_object_code = fde.data_object_code AND oar.rule_id = oare.rule_id AND oare.object_ref_id = oref.object_ref_id

View Text - HTML Formatted

SELECT OAR.RULE_ID
, OAR.DOCUMENT_ID
, OAR.DATA_OBJECT_CODE
, FDE.APPLICATION_ID
, FDE.TABLE_NAME DATA_OBJECT_TABLE_NAME
, FDE.PK1_COLUMN DATA_OBJECT_PK1_COLUMN
, FDE.PK2_COLUMN DATA_OBJECT_PK2_COLUMN
, FDE.PK3_COLUMN DATA_OBJECT_PK3_COLUMN
, FDE.PK4_COLUMN DATA_OBJECT_PK4_COLUMN
, FDE.PK5_COLUMN DATA_OBJECT_PK5_COLUMN
, OARE.RULE_ELEMENT_ID
, OARE.GROUP_NUMBER
, OARE.OBJECT_REF_ID
, OREF.OBJECT_REF_TYPE
, OREF.COLUMN_NAME OBJECT_REF_COLUMN_NAME
, OREF.COLUMN_DATATYPE OBJECT_REF_COLUMN_DATATYPE
, OARE.OBJECT_REF_VALUE
FROM OE_NOTES_RULES OAR
, OE_NOTES_RULE_ELEMENTS OARE
, FND_DOCUMENT_ENTITIES FDE
, OE_NOTES_OBJECT_REFS OREF
WHERE OAR.DATA_OBJECT_CODE = FDE.DATA_OBJECT_CODE
AND OAR.RULE_ID = OARE.RULE_ID
AND OARE.OBJECT_REF_ID = OREF.OBJECT_REF_ID