Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_ATTRIB_PRIMARY_SEC_V |
SELECT ATTRIBUTE_NAME
, ENTITY_NAME
, USER_DEFINED_ATTRIBUTE_NAME
, PRIM.PRIMARY_ATTRIBUTE_ID
, TO_NUMBER(-9999) SECONDARY_ATTRIBUTE_ID
, PRIM.MATCH_RULE_ID
, PRIM.ATTRIBUTE_ID
, PRIM.ACTIVE_FLAG
, TO_NUMBER(NULL) SCORE
, PRIM.CREATED_BY
, PRIM.CREATION_DATE
, PRIM.LAST_UPDATE_LOGIN
, PRIM.LAST_UPDATE_DATE
, PRIM.LAST_UPDATED_BY
, PRIM.FILTER_FLAG
, PRIM.OBJECT_VERSION_NUMBER
, PRIM.DISPLAY_ORDER
FROM HZ_MATCH_RULE_PRIMARY PRIM
, HZ_TRANS_ATTRIBUTES_VL
WHERE HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_ID = PRIM.ATTRIBUTE_ID UNION SELECT ATTRIBUTE_NAME
, ENTITY_NAME
, USER_DEFINED_ATTRIBUTE_NAME
, TO_NUMBER(-9999) PRIMARY_ATTRIBUTE_ID
, SEC.SECONDARY_ATTRIBUTE_ID
, SEC.MATCH_RULE_ID
, SEC.ATTRIBUTE_ID
, SEC.ACTIVE_FLAG
, SEC.SCORE
, SEC.CREATED_BY
, SEC.CREATION_DATE
, SEC.LAST_UPDATE_LOGIN
, SEC.LAST_UPDATE_DATE
, SEC.LAST_UPDATED_BY
, NULL FILTER_FLAG
, SEC.OBJECT_VERSION_NUMBER
, SEC.DISPLAY_ORDER
FROM HZ_MATCH_RULE_SECONDARY SEC
, HZ_TRANS_ATTRIBUTES_VL
WHERE HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_ID = SEC.ATTRIBUTE_ID