ZCQ_MT_ATT_MAPPING_V

Details

• Schema: FUSION

• Object owner: ZCQ

• Object type: VIEW

Columns

Name
ZCQ_MT_ATT_MAPPING_ID ATTR_NAME ENTITY_TYPE VLACCESSOR_FLAG OBJECT_DEF RELATION IDENTIFIER_FLAG DISPLAY_FLAG OBJECT_NAME VIEW_LINK_NAME PAR_OBJ_NAME TOP_FLAG ATTR_DISPLAY_NAME TABLE_NAME COLUMN_NAME

Query

SQL_Statement

SELECT ZCQ_MT_ATT_MAPPING_ID, ATTR_NAME, ENTITY_TYPE, VLACCESSOR_FLAG, OBJECT_DEF, RELATION, IDENTIFIER_FLAG, DISPLAY_FLAG, OBJECT_NAME, VIEW_LINK_NAME, PAR_OBJ_NAME, TOP_FLAG, ATTR_DISPLAY_NAME, TABLE_NAME, COLUMN_NAME FROM ZCQ_MT_ATT_MAPPING UNION SELECT a.object_attr_id zcq_mt_att_id, replace(a.attr_name, 'OrganizationDEO_') ATTR_NAME, 'ORGANIZATION' ENTITY_TYPE, NULL VLACCESSOR_FLAG, 'oracle.apps.cdm.foundation.parties.organizationService.view.OrganizationDVO' OBJECT_DEF, NULL RELATION, NULL IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, 'OrganizationDVO' OBJECT_NAME, NULL VIEW_LINK_NAME, NULL PAR_OBJ_NAME, 'Y' TOP_FLAG, concat(concat(o.lang_independent_code, '.'), replace(a.attr_name, 'OrganizationDEO_')) ATTR_DISPLAY_NAME, a.attr_TABLE TABLE_NAME, a.attr_COLUMN COLUMN_NAME FROM fusion.zca_objects o, fusion.zca_object_attributes a where a.object_id = o.object_id AND o.lang_independent_code ='Account' and a.attr_table = 'HZ_ORGANIZATION_PROFILES' and a.custom_flag = 'Y' /*SELECT oa.object_attr_id zcq_mt_att_id, txn_vo_attr_name attr_name, DECODE(txn_vo_name,'oracle.apps.cdm.foundation.parties.organizationService.view.OrganizationDVO','ORGANIZATION', 'oracle.apps.cdm.foundation.parties.personService.view.PersonDVO','PERSON') ENTITY_NAME, NULL VLACCESSOR_FLAG, txn_vo_name object_def, NULL RELATION, NULL IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, DECODE(txn_vo_name,'oracle.apps.cdm.foundation.parties.organizationService.view.OrganizationDVO','OrganizationDVO', 'oracle.apps.cdm.foundation.parties.personService.view.PersonDVO','PersonDVO') object_name, NULL VIEW_LINK_NAME, NULL PAR_OBJ_NAME, 'Y' TOP_FLAG, concat(concat(DECODE(txn_vo_name,'oracle.apps.cdm.foundation.parties.organizationService.view.OrganizationDVO','Account', 'oracle.apps.cdm.foundation.parties.personService.view.PersonDVO','Contact'), '.'), txn_vo_attr_name) ATTR_DISPLAY_NAME, txn_vo_attr_table TABLE_NAME, txn_vo_attr_col COLUMN_NAME FROM fusion.mkt_imp_object_attrs oa, fusion.MKT_IMP_OBJECT_details o WHERE oa.txn_vo_attr_name LIKE '%_c' AND oa.object_attr_col LIKE 'EXTN%' AND o.object_detail_id = oa.object_detail_id AND o.import_object_id IN (SELECT import_object_id FROM fusion.MKT_IMP_OBJECTs WHERE object_code = 'CUSTOMER' ) AND txn_vo_name IN ( 'oracle.apps.cdm.foundation.parties.organizationService.view.OrganizationDVO', 'oracle.apps.cdm.foundation.parties.personService.view.PersonDVO')*/ UNION SELECT a.object_attr_id zcq_mt_att_id, replace(a.attr_name, 'PersonDEO_') ATTR_NAME, 'PERSON' ENTITY_TYPE, NULL VLACCESSOR_FLAG, 'oracle.apps.cdm.foundation.parties.personService.view.PersonDVO' OBJECT_DEF, NULL RELATION, NULL IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, 'PersonDVO' OBJECT_NAME, NULL VIEW_LINK_NAME, NULL PAR_OBJ_NAME, 'Y' TOP_FLAG, concat(concat(o.lang_independent_code, '.'), replace(a.attr_name, 'PersonDEO_')) ATTR_DISPLAY_NAME, a.attr_TABLE TABLE_NAME, a.attr_COLUMN COLUMN_NAME FROM fusion.zca_objects o, fusion.zca_object_attributes a where a.object_id = o.object_id AND o.lang_independent_code ='Contact' and a.attr_table = 'HZ_PERSON_PROFILES' and a.custom_flag = 'Y' /*SELECT oa.object_attr_id zcq_mt_att_id, txn_vo_attr_name attr_name,'ORGANIZATION' ENTITY_NAME, null VLACCESSOR_FLAG, txn_vo_name object_def, 'oracle.apps.cdm.foundation.parties.organizationService.view.link.OrganizationDVOToPartySiteVO' RELATION, null IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, 'PartySiteVO' object_name, 'PartySite' VIEW_LINK_NAME, 'OrganizationDVO' PAR_OBJ_NAME, 'N' TOP_FLAG, concat(concat('Address','.'), txn_vo_attr_name) ATTR_DISPLAY_NAME, txn_vo_attr_table TABLE_NAME, txn_vo_attr_col COLUMN_NAME FROM fusion.mkt_imp_object_attrs oa, fusion.MKT_IMP_OBJECT_details o WHERE oa.txn_vo_attr_name like '%_c' AND oa.object_attr_col like 'EXTN%' and o.object_detail_id = oa.object_detail_id and o.import_object_id IN (SELECT import_object_id FROM fusion.MKT_IMP_OBJECTs WHERE object_code = 'CUSTOMER') and txn_vo_name in ( 'oracle.apps.cdm.foundation.parties.partyService.view.PartySiteVO') */ UNION SELECT a.object_attr_id zcq_mt_att_id, replace(a.attr_name, 'PartySiteEO_') txn_vo_attr_name, 'ORGANIZATION' ENTITY_TYPE, NULL VLACCESSOR_FLAG, 'oracle.apps.cdm.foundation.parties.partyService.view.PartySiteVO' OBJECT_DEF, 'oracle.apps.cdm.foundation.parties.organizationService.view.link.OrganizationDVOToPartySiteVO' RELATION, NULL IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, 'PartySiteVO' OBJECT_NAME, 'PartySite' VIEW_LINK_NAME, 'OrganizationDVO' PAR_OBJ_NAME, 'N' TOP_FLAG, concat(concat(o.lang_independent_code, '.'), replace(a.attr_name, 'PartySiteEO_')) ATTR_DISPLAY_NAME, a.attr_TABLE TABLE_NAME, a.attr_COLUMN COLUMN_NAME FROM fusion.zca_objects o, fusion.zca_object_attributes a where a.object_id = o.object_id AND o.lang_independent_code ='Address' and a.attr_table = 'HZ_PARTY_SITES' and a.custom_flag = 'Y' UNION SELECT a.object_attr_id zcq_mt_att_id, replace(a.attr_name, 'PartySiteEO_') ATTR_NAME, 'PERSON' ENTITY_TYPE, NULL VLACCESSOR_FLAG, 'oracle.apps.cdm.foundation.parties.partyService.view.PartySiteVO' OBJECT_DEF, 'oracle.apps.cdm.foundation.parties.personService.view.link.PersonDVOToPartySiteVO' RELATION, NULL IDENTIFIER_FLAG, 'Y' DISPLAY_FLAG, 'PartySiteVO' OBJECT_NAME, 'PartySite' VIEW_LINK_NAME, 'PersonDVO' PAR_OBJ_NAME, 'N' TOP_FLAG, concat(concat(o.lang_independent_code, '.'), replace(a.attr_name, 'PartySiteEO_')) ATTR_DISPLAY_NAME, a.attr_TABLE TABLE_NAME, a.attr_COLUMN COLUMN_NAME FROM fusion.zca_objects o, fusion.zca_object_attributes a where a.object_id = o.object_id AND o.lang_independent_code ='Address' and a.attr_table = 'HZ_PARTY_SITES' and a.custom_flag = 'Y'