APPS.HZ_IMP_DQM_STAGE dependencies on HZ_TRANS_ATTRIBUTES_B

Line 106: from hz_trans_attributes_b

102: from hz_match_rule_primary a
103: where match_rule_id = p_match_rule_id
104: and a.attribute_id in (
105: select attribute_id
106: from hz_trans_attributes_b
107: where entity_name = p_et_name
108: and attribute_name = p_attr_name)
109: union
110: select 'Y'

Line 115: from hz_trans_attributes_b

111: from hz_match_rule_secondary a
112: where match_rule_id = p_match_rule_id
113: and a.attribute_id in (
114: select attribute_id
115: from hz_trans_attributes_b
116: where entity_name = p_et_name
117: and attribute_name = p_attr_name);
118:
119: l_procedure_name VARCHAR2(30) := '.USING_ALLOW_CUST' ;

Line 964: from hz_trans_attributes_b

960: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
961: END IF;
962: -- FOR TX IN (select decode(attribute_name, 'PARTY_NAME', 'ORGANIZATION_NAME', attribute_name) as attribute_name
963: FOR TX IN (select attribute_name
964: from hz_trans_attributes_b
965: where entity_name = p_entity_name
966: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
967: and custom_attribute_procedure is null
968: /* and attribute_name not in

Line 1116: from hz_trans_attributes_b

1112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1113: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1114: END IF;
1115: FOR TX IN ( select attribute_id || 'E' as STAGED_ATTRIBUTE_COLUMN
1116: from hz_trans_attributes_b
1117: where attribute_id in (select attribute_id
1118: from hz_match_rule_primary
1119: where match_rule_id = p_rule_id
1120: union

Line 1243: from hz_trans_attributes_b

1239: END IF;
1240: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1241: from hz_trans_functions_b
1242: where attribute_id in (select attribute_id
1243: from hz_trans_attributes_b
1244: where attribute_name = p_attr_name
1245: and entity_name = p_entity_name)
1246: and function_id in (select function_id
1247: from hz_match_rule_primary e, hz_primary_trans d

Line 1299: from hz_trans_attributes_b

1295: and nvl(active_flag, 'Y') <> 'N'
1296: and staged_attribute_table = p_entity_name
1297: and attribute_id not in (
1298: select attribute_id
1299: from hz_trans_attributes_b
1300: where custom_attribute_procedure is not null
1301: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'
1302: /* or attribute_name in
1303: ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' ) */

Line 1438: from hz_trans_attributes_b

1434: END IF;
1435: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1436: from hz_trans_functions_b
1437: where attribute_id in (select attribute_id
1438: from hz_trans_attributes_b
1439: where attribute_name = p_attr_name
1440: and entity_name = p_entity_name)
1441: and function_id in (select function_id
1442: from hz_match_rule_primary e, hz_primary_trans d

Line 1492: from hz_trans_attributes_b

1488: and nvl(active_flag, 'Y') <> 'N'
1489: and staged_attribute_table = p_entity_name
1490: and attribute_id not in (
1491: select attribute_id
1492: from hz_trans_attributes_b
1493: where custom_attribute_procedure is not null
1494: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'
1495:
1496: ) order by STAGED_ATTRIBUTE_COLUMN

Line 1629: from hz_trans_attributes_b

1625: -- check if one really needs the below condition
1626: -- and a.attribute_id = b.attribute_id
1627: and a.attribute_id in (
1628: select attribute_id
1629: from hz_trans_attributes_b
1630: where entity_name = 'PARTY_SITES'
1631: and attribute_name = 'ADDRESS');
1632: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1633: BEGIN

Line 1662: from hz_trans_attributes_b

1658: -- check if one really needs the below condition
1659: -- and a.attribute_id = b.attribute_id
1660: and a.attribute_id in (
1661: select attribute_id
1662: from hz_trans_attributes_b
1663: where entity_name = 'CONTACT_POINTS'
1664: and attribute_name = 'RAW_PHONE_NUMBER');
1665: l_procedure_name VARCHAR2(30) := '.USING_RAW_PH_NO' ;
1666: BEGIN

Line 1695: from hz_trans_attributes_b

1691: -- check if one really needs the below condition
1692: -- and a.attribute_id = b.attribute_id
1693: and a.attribute_id in (
1694: select attribute_id
1695: from hz_trans_attributes_b
1696: where entity_name = 'CONTACTS'
1697: and attribute_name = 'CONTACT_NAME' );
1698: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1699: BEGIN

Line 1726: from hz_trans_attributes_b

1722: and a.match_rule_id = p_rule_id
1723: and a.attribute_id = b.attribute_id
1724: and a.attribute_id in (
1725: select attribute_id
1726: from hz_trans_attributes_b
1727: where entity_name = 'CONTACTS'
1728: and attribute_name = 'CONTACT_NAME' );
1729: l_procedure_name VARCHAR2(30) := '.USING_CONTACT_NAME' ;
1730: BEGIN

Line 3528: from hz_trans_attributes_b

3524: */
3525: FOR TX5 IN ( select STAGED_ATTRIBUTE_COLUMN
3526: from hz_trans_functions_b
3527: where attribute_id in (select attribute_id
3528: from hz_trans_attributes_b
3529: where attribute_name = 'CONTACT_NAME'
3530: and entity_name = 'CONTACTS')
3531: and function_id in (select function_id
3532: from hz_match_rule_primary e, hz_primary_trans d

Line 3561: from hz_trans_attributes_b

3557:
3558: FOR TX3 IN ( select STAGED_ATTRIBUTE_COLUMN
3559: from hz_trans_functions_b
3560: where attribute_id in (select attribute_id
3561: from hz_trans_attributes_b
3562: where attribute_name = 'RAW_PHONE_NUMBER'
3563: and entity_name = 'CONTACT_POINTS')
3564: and function_id in (select function_id
3565: from hz_match_rule_primary e, hz_primary_trans d

Line 3587: from hz_trans_attributes_b

3583: l(' H_P_PS_ADD CharList1000; ');
3584: FOR TX4 IN ( select STAGED_ATTRIBUTE_COLUMN
3585: from hz_trans_functions_b
3586: where attribute_id in (select attribute_id
3587: from hz_trans_attributes_b
3588: where attribute_name = 'ADDRESS'
3589: and entity_name = 'PARTY_SITES')
3590: and function_id in (select function_id
3591: from hz_match_rule_primary e, hz_primary_trans d