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 494: FROM HZ_TRANS_ATTRIBUTES_VL a

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

Line 573: FROM HZ_TRANS_ATTRIBUTES_VL a

569: END IF;
570:
571: FOR ATTRS IN (
572: SELECT ATTRIBUTE_ID, TEMP_SECTION
573: FROM HZ_TRANS_ATTRIBUTES_VL a
574: WHERE ENTITY_NAME = entity
575: ORDER BY ATTRIBUTE_ID) LOOP
576: prefattrs := '';
577: FUNCSF:=FALSE;

Line 694: from hz_trans_attributes_vl a

690: BEGIN
691: BEGIN
692: SELECT max(to_number(substrb(temp_section,2)))
693: INTO l_next_misc
694: from hz_trans_attributes_vl a
695: where a.entity_name = p_entity
696: and a.temp_section IS NOT NULL;
697: IF l_next_misc is null THEN
698: l_next_misc := 0;

Line 707: from hz_trans_attributes_vl a

703: END;
704:
705: FOR ATTRS IN (
706: SELECT ATTRIBUTE_ID
707: from hz_trans_attributes_vl a
708: where a.entity_name = p_entity
709: and exists (
710: SELECT 1 from hz_trans_functions_vl f
711: where a.attribute_id = f.attribute_id

Line 783: FROM HZ_TRANS_ATTRIBUTES_VL a

779:
780: PROCEDURE generate_datastore_prefs(p_entity VARCHAR2) IS
781: CURSOR c_num_attrs(cp_entity VARCHAR2) IS
782: SELECT COUNT(1)
783: FROM HZ_TRANS_ATTRIBUTES_VL a
784: WHERE ENTITY_NAME = cp_entity
785: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
786: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
787: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'

Line 792: FROM HZ_TRANS_ATTRIBUTES_VL a

788: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
789:
790: CURSOR c_attrs(cp_entity VARCHAR2) IS
791: SELECT 'A'||ATTRIBUTE_ID
792: FROM HZ_TRANS_ATTRIBUTES_VL a
793: WHERE ENTITY_NAME = cp_entity
794: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
795: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
796: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'

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

1055: BEGIN
1056: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1057: FOR IDX in (
1058: SELECT OWNER||'.'||INDEX_NAME idx_name
1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1060: WHERE f.attribute_id = a.attribute_id
1061: AND i.owner = l_owner1
1062: AND f.index_required_flag in ('Y','T')
1063: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

Line 1149: from hz_trans_attributes_vl a

1145: -- this cursor will return the number of active transformations
1146: -- that have not been staged, corresponding to the passed in entity
1147: CURSOR check_any_acq IS
1148: SELECT count(1)
1149: from hz_trans_attributes_vl a
1150: where a.entity_name = p_entity
1151: and exists (
1152: SELECT 1 from hz_trans_functions_vl f
1153: where a.attribute_id = f.attribute_id

Line 1223: from hz_trans_attributes_vl a

1219: -- and offset it by how many ever unstaged active transformations are found
1220: BEGIN
1221: SELECT max(to_number(substrb(temp_section,2)))+l_num_primary
1222: INTO l_next_misc_section
1223: from hz_trans_attributes_vl a
1224: where a.entity_name = p_entity
1225: and a.temp_section IS NOT NULL;
1226: IF l_next_misc_section IS NULL THEN
1227: l_next_misc_section := l_num_primary;

Line 1289: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

1285: message VARCHAR2(32000);
1286:
1287: CURSOR c_primary(cp_entity_name VARCHAR2) IS
1288: SELECT f.TRANSFORMATION_NAME, f.STAGED_ATTRIBUTE_COLUMN
1289: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
1290: WHERE PRIMARY_FLAG = 'Y'
1291: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1292: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1293: AND a.ENTITY_NAME = cp_entity_name;

Line 3087: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

3083:
3084: CURSOR c_num_attrs (p_entity VARCHAR2) IS
3085: SELECT count(1) FROM
3086: (SELECT distinct f.staged_attribute_column
3087: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
3088: WHERE PRIMARY_FLAG = 'Y'
3089: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3090: and f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3091: AND a.entity_name = p_entity

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

3482: UPDATE HZ_TRANS_FUNCTIONS_B
3483: SET STAGED_FLAG='Y'
3484: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3485: and attribute_id in (
3486: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');
3487: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY entity transformations after staging');
3488: -- SYNC DENORM PARTY SITE TEXT INDEX
3489: ELSIF SYNC_PS_TEXT_INDEX THEN
3490: create_btree_indexes ('PARTY_SITES');

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

3528: UPDATE HZ_TRANS_FUNCTIONS_B
3529: SET STAGED_FLAG='Y'
3530: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3531: and attribute_id in (
3532: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');
3533: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY_SITES ENTITY after staging');
3534: create_denorm_attribute_pref ('PARTY_SITES');
3535:
3536: -- SYNC DENORM CONTACT TEXT INDEX

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

3577: UPDATE HZ_TRANS_FUNCTIONS_B
3578: SET STAGED_FLAG='Y'
3579: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3580: and attribute_id in (
3581: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');
3582: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACTS ENTITY after staging');
3583: create_denorm_attribute_pref ('CONTACTS');
3584: -- SYNC DENORM CONTACT POINT TEXT INDEX
3585: ELSIF SYNC_CPT_TEXT_INDEX THEN

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

3626: UPDATE HZ_TRANS_FUNCTIONS_B
3627: SET STAGED_FLAG='Y'
3628: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3629: and attribute_id in (
3630: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');
3631: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACT_POINTS ENTITY after staging');
3632: create_denorm_attribute_pref ('CONTACT_POINTS');
3633: END IF;
3634: -- CREATE FLOW

Line 4152: FROM HZ_TRANS_ATTRIBUTES_VL

4148: FIRST := TRUE;
4149: l_update_str := null;
4150:
4151: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
4152: FROM HZ_TRANS_ATTRIBUTES_VL
4153: WHERE ENTITY_NAME = p_entity)
4154:
4155: LOOP
4156: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN

Line 4201: FROM HZ_TRANS_ATTRIBUTES_VL

4197:
4198: ELSE
4199:
4200: for ATTRS IN (SELECT ATTRIBUTE_ID, ATTRIBUTE_NAME
4201: FROM HZ_TRANS_ATTRIBUTES_VL
4202: WHERE ENTITY_NAME = p_entity)
4203: LOOP
4204: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
4205: FROM HZ_TRANS_FUNCTIONS_VL

Line 4535: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4531: pref_cols VARCHAR2(1000);
4532: proc_cols VARCHAR2(2000);
4533: fetch_cols VARCHAR2(2000);
4534: CURSOR l_ent_cur(l_ent_name VARCHAR2) IS (SELECT STAGED_ATTRIBUTE_COLUMN
4535: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4536: WHERE ENTITY_NAME = l_ent_name
4537: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4538: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y'
4539: AND nvl(a.DENORM_FLAG,'N') = 'Y'

Line 4867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4863: a.CUSTOM_ATTRIBUTE_PROCEDURE,
4864: f.PROCEDURE_NAME,
4865: f.STAGED_ATTRIBUTE_COLUMN,
4866: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
4867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4868: WHERE ENTITY_NAME = 'PARTY'
4869: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4870: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4871: ORDER BY COLNUM) LOOP

Line 4889: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4885: END IF;
4886: l_mincol_list(ATTRS.COLNUM) := 'N';
4887:
4888: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
4889: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4890: WHERE ENTITY_NAME = 'PARTY'
4891: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4892: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4893: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 5093: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5089: a.CUSTOM_ATTRIBUTE_PROCEDURE,
5090: f.PROCEDURE_NAME,
5091: f.STAGED_ATTRIBUTE_COLUMN,
5092: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
5093: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5094: WHERE ENTITY_NAME = 'PARTY'
5095: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5096: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5097: ORDER BY COLNUM) LOOP

Line 5115: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5111: END IF;
5112: l_mincol_list(ATTRS.COLNUM) := 'N';
5113:
5114: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
5115: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5116: WHERE ENTITY_NAME = 'PARTY'
5117: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5118: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5119: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

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

5567: f.PROCEDURE_NAME,
5568: f.STAGED_ATTRIBUTE_COLUMN,
5569: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
5570: nvl(TAG,'C') column_data_type --Bug No: 4279469
5571: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
5572: WHERE ENTITY_NAME = 'PARTY'
5573: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5574: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5575: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4279469

Line 5595: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5591: END IF;
5592: l_mincol_list(ATTRS.COLNUM) := 'N';
5593:
5594: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
5595: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5596: WHERE ENTITY_NAME = 'PARTY'
5597: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5598: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5599: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6391: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

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

Line 6411: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

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

Line 6546: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6542: a.CUSTOM_ATTRIBUTE_PROCEDURE,
6543: f.PROCEDURE_NAME,
6544: f.STAGED_ATTRIBUTE_COLUMN,
6545: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
6546: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6547: WHERE ENTITY_NAME = 'PARTY_SITES'
6548: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6549: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6550: ORDER BY COLNUM) LOOP

Line 6566: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6562: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6563: END IF;
6564:
6565: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6566: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6567: WHERE ENTITY_NAME = 'PARTY_SITES'
6568: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6569: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6570: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

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

6972: f.PROCEDURE_NAME,
6973: f.STAGED_ATTRIBUTE_COLUMN,
6974: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
6975: nvl(lkp.tag,'C') column_data_type
6976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
6977: WHERE ENTITY_NAME = 'PARTY_SITES'
6978: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6979: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6980: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 6998: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6994: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6995: END IF;
6996:
6997: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6998: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6999: WHERE ENTITY_NAME = 'PARTY_SITES'
7000: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7001: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7002: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7165: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7161: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7162: f.PROCEDURE_NAME,
7163: f.STAGED_ATTRIBUTE_COLUMN,
7164: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7165: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7166: WHERE ENTITY_NAME = 'PARTY_SITES'
7167: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7168: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7169: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 7647: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7643: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7644: f.PROCEDURE_NAME,
7645: f.STAGED_ATTRIBUTE_COLUMN,
7646: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7647: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7648: WHERE ENTITY_NAME = 'CONTACTS'
7649: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7650: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7651: ORDER BY COLNUM) LOOP

Line 7667: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7663: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7664: END IF;
7665:
7666: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7667: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7668: WHERE ENTITY_NAME = 'CONTACTS'
7669: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7670: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7671: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7847: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7843: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7844: f.PROCEDURE_NAME,
7845: f.STAGED_ATTRIBUTE_COLUMN,
7846: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7847: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7848: WHERE ENTITY_NAME = 'CONTACTS'
7849: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7850: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7851: ORDER BY COLNUM) LOOP

Line 7867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7863: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7864: END IF;
7865:
7866: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7868: WHERE ENTITY_NAME = 'CONTACTS'
7869: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7870: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7871: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

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

8276: f.PROCEDURE_NAME,
8277: f.STAGED_ATTRIBUTE_COLUMN,
8278: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
8279: nvl(lkp.tag,'C') column_data_type
8280: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
8281: WHERE ENTITY_NAME = 'CONTACTS'
8282: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8283: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8284: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 8302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8298: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
8299: END IF;
8300:
8301: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8303: WHERE ENTITY_NAME = 'CONTACTS'
8304: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8305: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8306: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8477: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8473: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8474: f.PROCEDURE_NAME,
8475: f.STAGED_ATTRIBUTE_COLUMN,
8476: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8477: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8478: WHERE ENTITY_NAME = 'CONTACTS'
8479: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8480: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8481: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 8942: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8938: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8939: f.PROCEDURE_NAME,
8940: f.STAGED_ATTRIBUTE_COLUMN,
8941: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8942: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8943: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8944: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8945: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8946: ORDER BY COLNUM) LOOP

Line 8961: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8957: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
8958: END IF;
8959:
8960: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8961: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8962: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8963: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8964: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8965: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9111: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9107: a.CUSTOM_ATTRIBUTE_PROCEDURE,
9108: f.PROCEDURE_NAME,
9109: f.STAGED_ATTRIBUTE_COLUMN,
9110: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
9111: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9112: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9113: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9114: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9115: ORDER BY COLNUM) LOOP

Line 9130: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9126: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
9127: END IF;
9128:
9129: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
9130: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9131: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9132: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9133: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9134: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

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

9555: f.PROCEDURE_NAME,
9556: f.STAGED_ATTRIBUTE_COLUMN,
9557: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
9558: nvl(lkp.tag,'C') column_data_type
9559: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
9560: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9561: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9562: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9563: -- REPURI. Added the 2 lines here for bug 4957189, which were missed in bug 4279469 fix.

Line 9581: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9577: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
9578: END IF;
9579:
9580: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
9581: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9582: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9583: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9584: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9585: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9754: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9750: a.CUSTOM_ATTRIBUTE_PROCEDURE,
9751: f.PROCEDURE_NAME,
9752: f.STAGED_ATTRIBUTE_COLUMN,
9753: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
9754: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9755: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9756: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9757: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9758: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 10261: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10257: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10258: f.PROCEDURE_NAME,
10259: f.STAGED_ATTRIBUTE_COLUMN,
10260: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10261: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10262: WHERE ENTITY_NAME = 'PARTY'
10263: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10264: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10265: AND f.STAGED_FLAG='N'

Line 10302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10298: l_oth_select(idx) := 'p.'||ATTRS.ATTRIBUTE_NAME;
10299: END IF;
10300: ELSE
10301: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10303: WHERE ENTITY_NAME = 'PARTY'
10304: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10305: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10306: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10523: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10519: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10520: f.PROCEDURE_NAME,
10521: f.STAGED_ATTRIBUTE_COLUMN,
10522: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10523: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10524: WHERE ENTITY_NAME = 'CONTACTS'
10525: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10526: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10527: AND f.staged_flag='N'

Line 10553: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10549: l_select(idx) := 'r.'||ATTRS.ATTRIBUTE_NAME;
10550: END IF;
10551: ELSE
10552: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10553: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10554: WHERE ENTITY_NAME = 'CONTACTS'
10555: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10556: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10557: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10860: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10856: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10857: f.PROCEDURE_NAME,
10858: f.STAGED_ATTRIBUTE_COLUMN,
10859: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10860: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10861: WHERE ENTITY_NAME = 'PARTY_SITES'
10862: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10863: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10864: AND f.staged_flag='N'

Line 10888: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10884: l_select(idx) := 'ps.'||ATTRS.ATTRIBUTE_NAME;
10885: END IF;
10886: ELSE
10887: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10888: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10889: WHERE ENTITY_NAME = 'PARTY_SITES'
10890: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10891: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10892: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11179: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11175: a.CUSTOM_ATTRIBUTE_PROCEDURE,
11176: f.PROCEDURE_NAME,
11177: f.STAGED_ATTRIBUTE_COLUMN,
11178: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
11179: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11180: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11181: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11182: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11183: AND f.STAGED_FLAG='N'

Line 11203: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11199: IF ATTRS.CUSTOM_ATTRIBUTE_PROCEDURE IS NULL THEN
11200: l_select(idx) := 'cp.'||ATTRS.ATTRIBUTE_NAME;
11201: ELSE
11202: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
11203: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11204: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11205: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11206: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11207: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11477: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f

11473: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
11474: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',
11475: 'CONTACT_POINTS','HZ_SRCH_CPTS') srch_table_name,
11476: f.staged_attribute_column column_name
11477: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f
11478: WHERE f.attribute_id = a.attribute_id
11479: AND f.index_required_flag = 'Y'
11480: AND a.entity_name = p_entity;
11481:

Line 11609: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

11605: c NUMBER;
11606: l_custom BOOLEAN;
11607: BEGIN
11608: FOR FUNCS IN (SELECT PROCEDURE_NAME, a.ENTITY_NAME, a.ATTRIBUTE_NAME, f.TRANSFORMATION_NAME
11609: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
11610: WHERE a.ATTRIBUTE_ID = f.ATTRIBUTE_ID
11611: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y' )
11612: LOOP
11613: BEGIN

Line 11634: FROM HZ_TRANS_ATTRIBUTES_VL a

11630: FND_MSG_PUB.ADD;
11631: END;
11632: END LOOP;
11633: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
11634: FROM HZ_TRANS_ATTRIBUTES_VL a
11635: WHERE source_table = 'CUSTOM' OR
11636: custom_attribute_procedure is NOT NULL
11637: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f
11638: WHERE f.attribute_id = a.attribute_id