eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_DQM_STAGE dependencies on HZ_TRANS_FUNCTIONS_B

Line 1241: from hz_trans_functions_b

1237: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1238: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
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)

Line 1284: from hz_trans_functions_b

1280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1281: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1282: END IF;
1283: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1284: from hz_trans_functions_b
1285: where function_id in
1286: (select function_id
1287: from hz_match_rule_primary e, hz_primary_trans d
1288: where match_rule_id = p_rule_id

Line 1436: from hz_trans_functions_b

1432: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1433: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
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)

Line 1478: from hz_trans_functions_b

1474: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1475: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
1476: END IF;
1477: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1478: from hz_trans_functions_b
1479: where function_id in (select function_id
1480: from hz_match_rule_primary e, hz_primary_trans d
1481: where e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1482: and match_rule_id = p_rule_id

Line 1755: from hz_trans_functions_b b, hz_trans_attributes_vl c

1751: ) IS
1752: BEGIN
1753: OPEN x_custom_cur FOR
1754: select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME, PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1755: from hz_trans_functions_b b, hz_trans_attributes_vl c
1756: where b.attribute_id = c.attribute_id
1757: --Fix for bug 4669257. Removing the hardcoded reference below.
1758: --and userenv('LANG') = 'US'
1759: and b.function_id in (select function_id

Line 1803: from hz_trans_functions_b b, hz_trans_attributes_vl c

1799:
1800: -- VJN ADDED CODE FOR TRACKING CONDITION ATTRIBUTES AT THIS ENTITY LEVEL
1801: FOR TX IN ( ----------> CONDITIONAL REPLACEMENT CODE ENDS
1802: select STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1803: from hz_trans_functions_b b, hz_trans_attributes_vl c
1804: where b.attribute_id = c.attribute_id
1805: --Fix for bug 4669257. Removing the hardcoded reference below.
1806: --and userenv('LANG') = 'US'
1807: and b.function_id in

Line 1848: from hz_trans_functions_b b, hz_trans_attributes_vl c

1844: l_trans_list(i) := ' HZ_TRANS_PKG.set_party_type(H_P_P_TYPE(I));';
1845: i := i + 1;
1846: END IF;
1847: FOR TX IN ( select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME, PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1848: from hz_trans_functions_b b, hz_trans_attributes_vl c
1849: where b.attribute_id = c.attribute_id
1850: --Fix for bug 4669257. Removing the hardcoded reference below.
1851: --and userenv('LANG') = 'US'
1852: and b.function_id in

Line 3487: from hz_trans_functions_b

3483: l(' g_limit NUMBER := 1000;');
3484: l(' H_CT_OBJ_ID NumberList; ');
3485:
3486: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
3487: from hz_trans_functions_b
3488: where attribute_id in (select attribute_id
3489: from hz_match_rule_primary
3490: where match_rule_id = p_rule_id)
3491: union

Line 3493: from hz_trans_functions_b

3489: from hz_match_rule_primary
3490: where match_rule_id = p_rule_id)
3491: union
3492: select STAGED_ATTRIBUTE_COLUMN
3493: from hz_trans_functions_b
3494: where attribute_id in (select attribute_id
3495: from hz_match_rule_secondary
3496: where match_rule_id = p_rule_id)
3497: order by STAGED_ATTRIBUTE_COLUMN

Line 3526: from hz_trans_functions_b

3522: /* l_sql_stmt := ' select count(distinct batch_id) from ' || p_table_name || ' where batch_id <> :1';
3523: execute immediate l_sql_stmt into l_count using p_batch_id;
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')

Line 3559: from hz_trans_functions_b

3555: IF (is_using_allow_cust_attr = 'Y') THEN
3556: l(' H_P_CP_R_PH_NO CharList60; ');
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')

Line 3585: from hz_trans_functions_b

3581: is_using_allow_cust_attr := using_allow_cust(p_rule_id, 'PARTY_SITES','ADDRESS');--using_address(p_rule_id);
3582: IF (is_using_allow_cust_attr = 'Y') THEN
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')