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_FUNCTIONS_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 347: SELECT 1 from hz_trans_functions_vl f

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
349: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
350: and primary_flag = 'Y'
351: AND NVL(STAGED_FLAG,'N') ='N');

Line 469: SELECT 1 FROM hz_trans_functions_vl f

465: AND (upper(prv_value) like '%'||p_stg_col||' %'
466: OR upper(prv_value) like '%'||p_stg_col||'||%');
467:
468: CURSOR check_any_tx(p_ATTRIBUTE_ID NUMBER) IS
469: SELECT 1 FROM hz_trans_functions_vl f
470: where f.attribute_id = p_attribute_id
471: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
472: and primary_flag = 'Y'
473: AND NVL(STAGED_FLAG,'N') ='Y';

Line 502: FROM HZ_TRANS_FUNCTIONS_VL f

498: prefattrs := '';
499: FUNCSF:=FALSE;
500: FOR FUNCS IN (
501: SELECT STAGED_ATTRIBUTE_COLUMN
502: FROM HZ_TRANS_FUNCTIONS_VL f
503: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
504: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
505: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y') LOOP
506:

Line 569: FROM HZ_TRANS_FUNCTIONS_VL f

565: prefattrs := '';
566: FUNCSF:=FALSE;
567: FOR FUNCS IN (
568: SELECT STAGED_ATTRIBUTE_COLUMN
569: FROM HZ_TRANS_FUNCTIONS_VL f
570: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
571: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
572: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y') LOOP
573:

Line 698: SELECT 1 from hz_trans_functions_vl f

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
700: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
701: and primary_flag = 'Y'
702: AND NVL(STAGED_FLAG,'N') ='N')

Line 773: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f

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'
776: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
777:

Line 782: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f

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'
785: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
786:

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 1140: SELECT 1 from hz_trans_functions_vl f

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
1142: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1143: and primary_flag = 'Y'
1144: AND NVL(STAGED_FLAG,'N') ='N');

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 1283: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;

1279: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1280: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1281: AND a.ENTITY_NAME = cp_entity_name;
1282:
1283: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;
1284: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;
1285:
1286: l_cols VARCHAR2(4000);
1287: l_message VARCHAR2(4000);

Line 1284: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;

1280: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1281: AND a.ENTITY_NAME = cp_entity_name;
1282:
1283: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;
1284: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;
1285:
1286: l_cols VARCHAR2(4000);
1287: l_message VARCHAR2(4000);
1288: l_status VARCHAR2(255) := 'NORMAL';

Line 2891: from hz_trans_functions_vl t, hz_trans_attributes_b a

2887: FUNCTION new_primary_trans(p_entity VARCHAR2
2888: ) RETURN BOOLEAN IS
2889: cursor is_new_tran (p_entity VARCHAR2) is
2890: select 'Y'
2891: from hz_trans_functions_vl t, hz_trans_attributes_b a
2892: where a.attribute_id = t.attribute_id
2893: and ENTITY_NAME = p_entity
2894: and nvl(staged_flag, 'N') = 'N'
2895: and primary_flag = 'Y'

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 4029: FROM HZ_TRANS_FUNCTIONS_VL

4025: WHERE ENTITY_NAME = p_entity)
4026:
4027: LOOP
4028: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
4029: FROM HZ_TRANS_FUNCTIONS_VL
4030: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
4031: AND nvl(ACTIVE_FLAG,'Y') = 'Y'
4032: AND NVL(STAGED_FLAG,'N') <> 'Y')
4033: LOOP

Line 4077: FROM HZ_TRANS_FUNCTIONS_VL

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
4078: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
4079: AND nvl(ACTIVE_FLAG,'Y') = 'Y')
4080: LOOP
4081: l(' l_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ' := ');

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 11483: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f

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
11485: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'))
11486: LOOP
11487: BEGIN