Product: | ONT - Order Management |
---|---|
Description: | No longer used |
Implementation/DBA Data: | APPS.OE_NOTES_RULES_V |
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