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_PARTY_STAGE_SHADOW dependencies on HZ_TRANS_ATTRIBUTES_VL

Line 291: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

287:
288: PROCEDURE generate_uds_proc(p_entity varchar2, p_proc_name varchar2) IS
289: CURSOR c_trns(cp_entity VARCHAR2) IS
290: SELECT staged_attribute_column
291: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
292: WHERE ENTITY_NAME = cp_entity
293: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
294: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
295: --AND nvl(f.PRIMARY_FLAG,'Y') = 'Y' --5044716

Line 484: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

480:
481: -- Cursor to get number of active acquistion enabled transformations
482: CURSOR c_num_trns(cp_entity VARCHAR2) IS
483: SELECT COUNT(1)
484: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
485: WHERE ENTITY_NAME = cp_entity
486: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
487: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
488: --AND nvl(f.PRIMARY_FLAG,'Y') = 'Y' --5044716

Line 494: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

490:
491: -- Cursor to get active acquistion enabled transformations
492: CURSOR c_trns(cp_entity VARCHAR2) IS
493: SELECT staged_attribute_column
494: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
495: WHERE ENTITY_NAME = cp_entity
496: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
497: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
498: --AND nvl(f.PRIMARY_FLAG,'Y') = 'Y' --5044716

Line 697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f

693: log('Dropping Btree Indexes on Base Staging tables');
694: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
695: FOR IDX in (
696: SELECT OWNER||'.'||INDEX_NAME idx_name
697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
698: WHERE f.attribute_id = a.attribute_id
699: AND i.owner = l_owner1
700: AND f.index_required_flag in ('Y','T')
701: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',

Line 779: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

775: l_end_flag VARCHAR2(1);
776:
777: CURSOR c_primary(cp_entity_name VARCHAR2) IS
778: SELECT f.TRANSFORMATION_NAME, f.STAGED_ATTRIBUTE_COLUMN
779: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
780: WHERE PRIMARY_FLAG = 'Y'
781: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
782: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
783: AND a.ENTITY_NAME = cp_entity_name;

Line 1668: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

1664:
1665: CURSOR c_num_attrs (p_entity VARCHAR2) IS
1666: SELECT count(1) FROM
1667: (SELECT distinct f.staged_attribute_column
1668: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
1669: WHERE
1670: -- PRIMARY_FLAG = 'Y' --5044716
1671: nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1672: and f.ATTRIBUTE_ID = a.ATTRIBUTE_ID

Line 2147: FROM HZ_TRANS_ATTRIBUTES_VL

2143: FIRST := TRUE;
2144: l_update_str := null;
2145:
2146: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
2147: FROM HZ_TRANS_ATTRIBUTES_VL
2148: WHERE ENTITY_NAME = p_entity)
2149:
2150: LOOP
2151: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN

Line 2196: FROM HZ_TRANS_ATTRIBUTES_VL

2192:
2193: ELSE
2194:
2195: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
2196: FROM HZ_TRANS_ATTRIBUTES_VL
2197: WHERE ENTITY_NAME = p_entity)
2198: LOOP
2199: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
2200: FROM HZ_TRANS_FUNCTIONS_VL

Line 2564: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

2560: f.PROCEDURE_NAME,
2561: f.STAGED_ATTRIBUTE_COLUMN,
2562: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
2563: nvl(TAG,'C') column_data_type --Bug No: 4954701
2564: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
2565: WHERE ENTITY_NAME = 'PARTY'
2566: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
2567: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
2568: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4954701

Line 2588: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

2584: END IF;
2585: l_mincol_list(ATTRS.COLNUM) := 'N';
2586:
2587: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
2588: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
2589: WHERE ENTITY_NAME = 'PARTY'
2590: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
2591: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
2592: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 3141: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3137: f.PROCEDURE_NAME,
3138: f.STAGED_ATTRIBUTE_COLUMN,
3139: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3140: nvl(lkp.tag,'C') column_data_type
3141: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3142: WHERE ENTITY_NAME = 'PARTY_SITES'
3143: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3144: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3145: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 3163: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

3159: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
3160: END IF;
3161:
3162: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
3163: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
3164: WHERE ENTITY_NAME = 'PARTY_SITES'
3165: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3166: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3167: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 3551: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3547: f.PROCEDURE_NAME,
3548: f.STAGED_ATTRIBUTE_COLUMN,
3549: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3550: nvl(lkp.tag,'C') column_data_type
3551: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3552: WHERE ENTITY_NAME = 'CONTACTS'
3553: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3554: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3555: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 3573: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

3569: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
3570: END IF;
3571:
3572: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
3573: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
3574: WHERE ENTITY_NAME = 'CONTACTS'
3575: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3576: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3577: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 3970: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3966: f.PROCEDURE_NAME,
3967: f.STAGED_ATTRIBUTE_COLUMN,
3968: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3969: nvl(lkp.tag,'C') column_data_type
3970: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3971: WHERE ENTITY_NAME = 'CONTACT_POINTS'
3972: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3973: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3974: AND lkp.LOOKUP_TYPE = 'CONTACT_PT_LOGICAL_ATTRIB_LIST'

Line 3991: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

3987: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
3988: END IF;
3989:
3990: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
3991: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
3992: WHERE ENTITY_NAME = 'CONTACT_POINTS'
3993: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3994: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3995: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 4366: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f

4362: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
4363: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',
4364: 'CONTACT_POINTS','HZ_SRCH_CPTS') srch_table_name,
4365: f.staged_attribute_column column_name
4366: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f
4367: WHERE f.attribute_id = a.attribute_id
4368: AND f.index_required_flag = 'Y'
4369: AND a.entity_name = p_entity;
4370:

Line 4500: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

4496: BEGIN
4497: log('---------------------------------------------------');
4498: log('Calling verify_all_procs');
4499: FOR FUNCS IN (SELECT PROCEDURE_NAME, a.ENTITY_NAME, a.ATTRIBUTE_NAME, f.TRANSFORMATION_NAME
4500: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
4501: WHERE a.ATTRIBUTE_ID = f.ATTRIBUTE_ID
4502: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y' )
4503: LOOP
4504: BEGIN

Line 4525: FROM HZ_TRANS_ATTRIBUTES_VL a

4521: FND_MSG_PUB.ADD;
4522: END;
4523: END LOOP;
4524: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
4525: FROM HZ_TRANS_ATTRIBUTES_VL a
4526: WHERE source_table = 'CUSTOM' OR
4527: custom_attribute_procedure is NOT NULL
4528: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f
4529: WHERE f.attribute_id = a.attribute_id