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

Line 123: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

119: (
120: -- will get all staged attribute columns corresponding to active transformations
121: -- that are defined on party site denorm attributes
122: SELECT b.staged_attribute_column as attrib_column
123: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
124: where a.entity_name = 'PARTY_SITES'
125: and nvl(a.denorm_flag,'N') = 'Y'
126: and a.attribute_id = b.attribute_id
127: and nvl( b.active_flag, 'Y') = 'Y'

Line 151: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

147: (
148: -- will get all staged attribute columns corresponding to active transformations
149: -- that are defined on contact denorm attributes
150: SELECT b.staged_attribute_column as attrib_column
151: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
152: where a.entity_name = 'CONTACTS'
153: and nvl(a.denorm_flag,'N') = 'Y'
154: and a.attribute_id = b.attribute_id
155: and nvl( b.active_flag, 'Y') = 'Y'

Line 180: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

176: (
177: -- will get all staged attribute columns corresponding to active transformations
178: -- that are defined on contact point denorm attributes
179: SELECT b.staged_attribute_column as attrib_column
180: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
181: where a.entity_name = 'CONTACT_POINTS'
182: and nvl(a.denorm_flag,'N') = 'Y'
183: and a.attribute_id = b.attribute_id
184: and nvl( b.active_flag, 'Y') = 'Y'

Line 229: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

225:
226: FOR col_cur in
227: (
228: SELECT b.staged_attribute_column as attrib_column
229: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
230: where a.entity_name = 'PARTY_SITES'
231: and nvl(a.denorm_flag,'N') = 'Y'
232: and a.attribute_id = b.attribute_id
233: and nvl( b.active_flag, 'Y') = 'Y'

Line 269: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

265:
266: FOR col_cur in
267: (
268: SELECT b.staged_attribute_column as attrib_column
269: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
270: where a.entity_name = 'CONTACTS'
271: and nvl(a.denorm_flag,'N') = 'Y'
272: and a.attribute_id = b.attribute_id
273: and nvl( b.active_flag, 'Y') = 'Y'

Line 310: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

306:
307: FOR col_cur in
308: (
309: SELECT b.staged_attribute_column as attrib_column
310: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
311: where a.entity_name = 'CONTACT_POINTS'
312: and nvl(a.denorm_flag,'N') = 'Y'
313: and a.attribute_id = b.attribute_id
314: and nvl( b.active_flag, 'Y') = 'Y'

Line 344: from hz_trans_attributes_vl a

340: l_count NUMBER := 0;
341: BEGIN
342: log ('--------------------------------------');
343: SELECT count(1) into l_count
344: from hz_trans_attributes_vl a
345: where a.entity_name = p_entity
346: and exists (
347: SELECT 1 from hz_trans_functions_vl f
348: where a.attribute_id = f.attribute_id

Line 493: FROM HZ_TRANS_ATTRIBUTES_VL a

489:
490: prefcols := '';
491: FOR ATTRS IN (
492: SELECT ATTRIBUTE_ID
493: FROM HZ_TRANS_ATTRIBUTES_VL a
494: WHERE ENTITY_NAME = entity
495: AND TEMP_SECTION IS NULL
496: ORDER BY ATTRIBUTE_ID) LOOP
497:

Line 562: FROM HZ_TRANS_ATTRIBUTES_VL a

558: END IF;
559:
560: FOR ATTRS IN (
561: SELECT ATTRIBUTE_ID, TEMP_SECTION
562: FROM HZ_TRANS_ATTRIBUTES_VL a
563: WHERE ENTITY_NAME = entity
564: ORDER BY ATTRIBUTE_ID) LOOP
565: prefattrs := '';
566: FUNCSF:=FALSE;

Line 682: from hz_trans_attributes_vl a

678: BEGIN
679: BEGIN
680: SELECT max(to_number(substrb(temp_section,2)))
681: INTO l_next_misc
682: from hz_trans_attributes_vl a
683: where a.entity_name = p_entity
684: and a.temp_section IS NOT NULL;
685: IF l_next_misc is null THEN
686: l_next_misc := 0;

Line 695: from hz_trans_attributes_vl a

691: END;
692:
693: FOR ATTRS IN (
694: SELECT ATTRIBUTE_ID
695: from hz_trans_attributes_vl a
696: where a.entity_name = p_entity
697: and exists (
698: SELECT 1 from hz_trans_functions_vl f
699: where a.attribute_id = f.attribute_id

Line 771: FROM HZ_TRANS_ATTRIBUTES_VL a

767:
768: PROCEDURE generate_datastore_prefs(p_entity VARCHAR2) IS
769: CURSOR c_num_attrs(cp_entity VARCHAR2) IS
770: SELECT COUNT(1)
771: FROM HZ_TRANS_ATTRIBUTES_VL a
772: WHERE ENTITY_NAME = cp_entity
773: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
774: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
775: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'

Line 780: FROM HZ_TRANS_ATTRIBUTES_VL a

776: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
777:
778: CURSOR c_attrs(cp_entity VARCHAR2) IS
779: SELECT 'A'||ATTRIBUTE_ID
780: FROM HZ_TRANS_ATTRIBUTES_VL a
781: WHERE ENTITY_NAME = cp_entity
782: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
783: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
784: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'

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

1043: BEGIN
1044: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1045: FOR IDX in (
1046: SELECT OWNER||'.'||INDEX_NAME idx_name
1047: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1048: WHERE f.attribute_id = a.attribute_id
1049: AND i.owner = l_owner1
1050: AND f.index_required_flag in ('Y','T')
1051: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

Line 1137: from hz_trans_attributes_vl a

1133: -- this cursor will return the number of active transformations
1134: -- that have not been staged, corresponding to the passed in entity
1135: CURSOR check_any_acq IS
1136: SELECT count(1)
1137: from hz_trans_attributes_vl a
1138: where a.entity_name = p_entity
1139: and exists (
1140: SELECT 1 from hz_trans_functions_vl f
1141: where a.attribute_id = f.attribute_id

Line 1211: from hz_trans_attributes_vl a

1207: -- and offset it by how many ever unstaged active transformations are found
1208: BEGIN
1209: SELECT max(to_number(substrb(temp_section,2)))+l_num_primary
1210: INTO l_next_misc_section
1211: from hz_trans_attributes_vl a
1212: where a.entity_name = p_entity
1213: and a.temp_section IS NOT NULL;
1214: IF l_next_misc_section IS NULL THEN
1215: l_next_misc_section := l_num_primary;

Line 1277: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

1273: message VARCHAR2(32000);
1274:
1275: CURSOR c_primary(cp_entity_name VARCHAR2) IS
1276: SELECT f.TRANSFORMATION_NAME, f.STAGED_ATTRIBUTE_COLUMN
1277: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
1278: WHERE PRIMARY_FLAG = 'Y'
1279: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1280: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1281: AND a.ENTITY_NAME = cp_entity_name;

Line 2971: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

2967:
2968: CURSOR c_num_attrs (p_entity VARCHAR2) IS
2969: SELECT count(1) FROM
2970: (SELECT distinct f.staged_attribute_column
2971: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
2972: WHERE PRIMARY_FLAG = 'Y'
2973: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
2974: and f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
2975: AND a.entity_name = p_entity

Line 3366: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');

3362: UPDATE HZ_TRANS_FUNCTIONS_B
3363: SET STAGED_FLAG='Y'
3364: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3365: and attribute_id in (
3366: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');
3367: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY entity transformations after staging');
3368: -- SYNC DENORM PARTY SITE TEXT INDEX
3369: ELSIF SYNC_PS_TEXT_INDEX THEN
3370: create_btree_indexes ('PARTY_SITES');

Line 3412: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');

3408: UPDATE HZ_TRANS_FUNCTIONS_B
3409: SET STAGED_FLAG='Y'
3410: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3411: and attribute_id in (
3412: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');
3413: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY_SITES ENTITY after staging');
3414: create_denorm_attribute_pref ('PARTY_SITES');
3415:
3416: -- SYNC DENORM CONTACT TEXT INDEX

Line 3461: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');

3457: UPDATE HZ_TRANS_FUNCTIONS_B
3458: SET STAGED_FLAG='Y'
3459: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3460: and attribute_id in (
3461: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');
3462: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACTS ENTITY after staging');
3463: create_denorm_attribute_pref ('CONTACTS');
3464: -- SYNC DENORM CONTACT POINT TEXT INDEX
3465: ELSIF SYNC_CPT_TEXT_INDEX THEN

Line 3510: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');

3506: UPDATE HZ_TRANS_FUNCTIONS_B
3507: SET STAGED_FLAG='Y'
3508: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3509: and attribute_id in (
3510: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');
3511: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACT_POINTS ENTITY after staging');
3512: create_denorm_attribute_pref ('CONTACT_POINTS');
3513: END IF;
3514: -- CREATE FLOW

Line 4024: FROM HZ_TRANS_ATTRIBUTES_VL

4020: FIRST := TRUE;
4021: l_update_str := null;
4022:
4023: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
4024: FROM HZ_TRANS_ATTRIBUTES_VL
4025: WHERE ENTITY_NAME = p_entity)
4026:
4027: LOOP
4028: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN

Line 4073: FROM HZ_TRANS_ATTRIBUTES_VL

4069:
4070: ELSE
4071:
4072: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
4073: FROM HZ_TRANS_ATTRIBUTES_VL
4074: WHERE ENTITY_NAME = p_entity)
4075: LOOP
4076: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
4077: FROM HZ_TRANS_FUNCTIONS_VL

Line 4407: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4403: pref_cols VARCHAR2(1000);
4404: proc_cols VARCHAR2(2000);
4405: fetch_cols VARCHAR2(2000);
4406: CURSOR l_ent_cur(l_ent_name VARCHAR2) IS (SELECT STAGED_ATTRIBUTE_COLUMN
4407: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4408: WHERE ENTITY_NAME = l_ent_name
4409: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4410: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y'
4411: AND nvl(a.DENORM_FLAG,'N') = 'Y'

Line 4715: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4711: a.CUSTOM_ATTRIBUTE_PROCEDURE,
4712: f.PROCEDURE_NAME,
4713: f.STAGED_ATTRIBUTE_COLUMN,
4714: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
4715: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4716: WHERE ENTITY_NAME = 'PARTY'
4717: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4718: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4719: ORDER BY COLNUM) LOOP

Line 4737: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4733: END IF;
4734: l_mincol_list(ATTRS.COLNUM) := 'N';
4735:
4736: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
4737: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4738: WHERE ENTITY_NAME = 'PARTY'
4739: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4740: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4741: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 4941: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4937: a.CUSTOM_ATTRIBUTE_PROCEDURE,
4938: f.PROCEDURE_NAME,
4939: f.STAGED_ATTRIBUTE_COLUMN,
4940: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
4941: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4942: WHERE ENTITY_NAME = 'PARTY'
4943: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4944: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4945: ORDER BY COLNUM) LOOP

Line 4963: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4959: END IF;
4960: l_mincol_list(ATTRS.COLNUM) := 'N';
4961:
4962: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
4963: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4964: WHERE ENTITY_NAME = 'PARTY'
4965: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4966: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4967: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 5417: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

5413: f.PROCEDURE_NAME,
5414: f.STAGED_ATTRIBUTE_COLUMN,
5415: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
5416: nvl(TAG,'C') column_data_type --Bug No: 4279469
5417: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
5418: WHERE ENTITY_NAME = 'PARTY'
5419: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5420: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5421: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4279469

Line 5441: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5437: END IF;
5438: l_mincol_list(ATTRS.COLNUM) := 'N';
5439:
5440: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
5441: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5442: WHERE ENTITY_NAME = 'PARTY'
5443: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5444: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5445: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6237: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6233: a.CUSTOM_ATTRIBUTE_PROCEDURE,
6234: f.PROCEDURE_NAME,
6235: f.STAGED_ATTRIBUTE_COLUMN,
6236: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
6237: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6238: WHERE ENTITY_NAME = 'PARTY_SITES'
6239: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6240: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6241: ORDER BY COLNUM) LOOP

Line 6257: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6253: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6254: END IF;
6255:
6256: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6257: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6258: WHERE ENTITY_NAME = 'PARTY_SITES'
6259: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6260: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6261: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6392: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6388: a.CUSTOM_ATTRIBUTE_PROCEDURE,
6389: f.PROCEDURE_NAME,
6390: f.STAGED_ATTRIBUTE_COLUMN,
6391: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
6392: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6393: WHERE ENTITY_NAME = 'PARTY_SITES'
6394: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6395: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6396: ORDER BY COLNUM) LOOP

Line 6412: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6408: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6409: END IF;
6410:
6411: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6412: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6413: WHERE ENTITY_NAME = 'PARTY_SITES'
6414: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6415: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6416: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6822: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

6818: f.PROCEDURE_NAME,
6819: f.STAGED_ATTRIBUTE_COLUMN,
6820: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
6821: nvl(lkp.tag,'C') column_data_type
6822: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
6823: WHERE ENTITY_NAME = 'PARTY_SITES'
6824: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6825: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6826: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 6844: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6840: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6841: END IF;
6842:
6843: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6844: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6845: WHERE ENTITY_NAME = 'PARTY_SITES'
6846: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6847: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6848: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7011: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7007: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7008: f.PROCEDURE_NAME,
7009: f.STAGED_ATTRIBUTE_COLUMN,
7010: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7011: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7012: WHERE ENTITY_NAME = 'PARTY_SITES'
7013: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7014: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7015: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 7493: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7489: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7490: f.PROCEDURE_NAME,
7491: f.STAGED_ATTRIBUTE_COLUMN,
7492: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7493: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7494: WHERE ENTITY_NAME = 'CONTACTS'
7495: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7496: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7497: ORDER BY COLNUM) LOOP

Line 7513: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7509: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7510: END IF;
7511:
7512: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7513: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7514: WHERE ENTITY_NAME = 'CONTACTS'
7515: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7516: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7517: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7693: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7689: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7690: f.PROCEDURE_NAME,
7691: f.STAGED_ATTRIBUTE_COLUMN,
7692: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7693: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7694: WHERE ENTITY_NAME = 'CONTACTS'
7695: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7696: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7697: ORDER BY COLNUM) LOOP

Line 7713: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7709: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7710: END IF;
7711:
7712: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7713: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7714: WHERE ENTITY_NAME = 'CONTACTS'
7715: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7716: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7717: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8126: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

8122: f.PROCEDURE_NAME,
8123: f.STAGED_ATTRIBUTE_COLUMN,
8124: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
8125: nvl(lkp.tag,'C') column_data_type
8126: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
8127: WHERE ENTITY_NAME = 'CONTACTS'
8128: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8129: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8130: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 8148: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8144: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
8145: END IF;
8146:
8147: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8148: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8149: WHERE ENTITY_NAME = 'CONTACTS'
8150: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8151: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8152: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8323: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8319: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8320: f.PROCEDURE_NAME,
8321: f.STAGED_ATTRIBUTE_COLUMN,
8322: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8323: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8324: WHERE ENTITY_NAME = 'CONTACTS'
8325: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8326: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8327: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 8788: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8784: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8785: f.PROCEDURE_NAME,
8786: f.STAGED_ATTRIBUTE_COLUMN,
8787: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8788: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8789: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8790: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8791: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8792: ORDER BY COLNUM) LOOP

Line 8807: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8803: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
8804: END IF;
8805:
8806: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8807: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8808: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8809: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8810: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8811: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8957: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8953: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8954: f.PROCEDURE_NAME,
8955: f.STAGED_ATTRIBUTE_COLUMN,
8956: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8957: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8958: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8959: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8960: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8961: ORDER BY COLNUM) LOOP

Line 8976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8972: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
8973: END IF;
8974:
8975: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8977: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8978: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8979: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8980: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9405: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

9401: f.PROCEDURE_NAME,
9402: f.STAGED_ATTRIBUTE_COLUMN,
9403: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
9404: nvl(lkp.tag,'C') column_data_type
9405: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
9406: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9407: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9408: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9409: -- REPURI. Added the 2 lines here for bug 4957189, which were missed in bug 4279469 fix.

Line 9427: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9423: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
9424: END IF;
9425:
9426: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
9427: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9428: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9429: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9430: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9431: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9600: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9596: a.CUSTOM_ATTRIBUTE_PROCEDURE,
9597: f.PROCEDURE_NAME,
9598: f.STAGED_ATTRIBUTE_COLUMN,
9599: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
9600: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9601: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9602: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9603: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9604: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 10107: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10103: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10104: f.PROCEDURE_NAME,
10105: f.STAGED_ATTRIBUTE_COLUMN,
10106: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10107: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10108: WHERE ENTITY_NAME = 'PARTY'
10109: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10110: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10111: AND f.STAGED_FLAG='N'

Line 10148: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10144: l_oth_select(idx) := 'p.'||ATTRS.ATTRIBUTE_NAME;
10145: END IF;
10146: ELSE
10147: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10148: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10149: WHERE ENTITY_NAME = 'PARTY'
10150: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10151: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10152: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10369: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10365: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10366: f.PROCEDURE_NAME,
10367: f.STAGED_ATTRIBUTE_COLUMN,
10368: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10369: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10370: WHERE ENTITY_NAME = 'CONTACTS'
10371: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10372: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10373: AND f.staged_flag='N'

Line 10399: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10395: l_select(idx) := 'r.'||ATTRS.ATTRIBUTE_NAME;
10396: END IF;
10397: ELSE
10398: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10399: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10400: WHERE ENTITY_NAME = 'CONTACTS'
10401: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10402: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10403: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10706: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10702: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10703: f.PROCEDURE_NAME,
10704: f.STAGED_ATTRIBUTE_COLUMN,
10705: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10706: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10707: WHERE ENTITY_NAME = 'PARTY_SITES'
10708: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10709: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10710: AND f.staged_flag='N'

Line 10734: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10730: l_select(idx) := 'ps.'||ATTRS.ATTRIBUTE_NAME;
10731: END IF;
10732: ELSE
10733: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10734: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10735: WHERE ENTITY_NAME = 'PARTY_SITES'
10736: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10737: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10738: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11025: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11021: a.CUSTOM_ATTRIBUTE_PROCEDURE,
11022: f.PROCEDURE_NAME,
11023: f.STAGED_ATTRIBUTE_COLUMN,
11024: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
11025: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11026: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11027: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11028: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11029: AND f.STAGED_FLAG='N'

Line 11049: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11045: IF ATTRS.CUSTOM_ATTRIBUTE_PROCEDURE IS NULL THEN
11046: l_select(idx) := 'cp.'||ATTRS.ATTRIBUTE_NAME;
11047: ELSE
11048: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
11049: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11050: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11051: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11052: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11053: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11323: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f

11319: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
11320: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',
11321: 'CONTACT_POINTS','HZ_SRCH_CPTS') srch_table_name,
11322: f.staged_attribute_column column_name
11323: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f
11324: WHERE f.attribute_id = a.attribute_id
11325: AND f.index_required_flag = 'Y'
11326: AND a.entity_name = p_entity;
11327:

Line 11455: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

11451: c NUMBER;
11452: l_custom BOOLEAN;
11453: BEGIN
11454: FOR FUNCS IN (SELECT PROCEDURE_NAME, a.ENTITY_NAME, a.ATTRIBUTE_NAME, f.TRANSFORMATION_NAME
11455: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
11456: WHERE a.ATTRIBUTE_ID = f.ATTRIBUTE_ID
11457: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y' )
11458: LOOP
11459: BEGIN

Line 11480: FROM HZ_TRANS_ATTRIBUTES_VL a

11476: FND_MSG_PUB.ADD;
11477: END;
11478: END LOOP;
11479: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
11480: FROM HZ_TRANS_ATTRIBUTES_VL a
11481: WHERE source_table = 'CUSTOM' OR
11482: custom_attribute_procedure is NOT NULL
11483: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f
11484: WHERE f.attribute_id = a.attribute_id