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.

[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_HZ_B2C_MAPPING_V

Line 915: FROM AMS_HZ_B2C_MAPPING_V

911: ADDRESS_ATTRIBUTE17,
912: ADDRESS_ATTRIBUTE18,
913: ADDRESS_ATTRIBUTE19,
914: ADDRESS_ATTRIBUTE20
915: FROM AMS_HZ_B2C_MAPPING_V
916: WHERE IMPORT_LIST_HEADER_ID = P_IMPORT_LIST_HEADER_ID
917: and request_id = l_request_id
918: AND load_status in ('ACTIVE','RELOAD');
919:

Line 2685: UPDATE ams_hz_b2c_mapping_v

2681:
2682: elsif l_imp_type = 'B2C' then
2683:
2684: --aanjaria: bug 4913239: copy party_id to person_party_id so that existence check is by passed
2685: UPDATE ams_hz_b2c_mapping_v
2686: SET person_party_id = party_id,
2687: person_exist = 'Y'
2688: WHERE import_list_header_id = p_import_list_header_id
2689: AND party_id is not null

Line 4857: FROM AMS_HZ_B2C_MAPPING_V

4853: ADDRESS_ATTRIBUTE_CATEGORY ,
4854: SHORT_DESCRIPTION,
4855: DESCRIPTION,
4856: PARTY_SITE_USE
4857: FROM AMS_HZ_B2C_MAPPING_V
4858: WHERE party_id = p_party_id
4859: and load_status = 'SUCCESS';
4860:
4861:

Line 7737: from ams_hz_b2c_mapping_v where import_source_line_id = p_import_source_line_id;

7733: from ams_hz_b2b_mapping_v where import_source_line_id = p_import_source_line_id;
7734:
7735: cursor c_b2cxmlrec is
7736: select per_imp_xml_element_id, add_imp_xml_element_id,cp_imp_xml_element_id, em_imp_xml_element_id
7737: from ams_hz_b2c_mapping_v where import_source_line_id = p_import_source_line_id;
7738:
7739: cursor c_file_type is
7740: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
7741:

Line 9740: FROM AMS_HZ_B2C_MAPPING_V

9736: Null col145,
9737: Null col146,
9738: Null col147,
9739: Null col148
9740: FROM AMS_HZ_B2C_MAPPING_V
9741: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id
9742: and load_status in ('ACTIVE','RELOAD')
9743: AND
9744: (

Line 10038: FROM ams_hz_b2c_mapping_v

10034: DATE_OF_BIRTH,
10035: DATE_OF_DEATH,
10036: null date1,
10037: MARITAL_STATUS_EFFECTIVE_DATE
10038: FROM ams_hz_b2c_mapping_v
10039: WHERE import_list_header_id = p_import_list_header_id
10040: and load_status in ('ACTIVE','RELOAD')
10041: AND (ADDRESS_EFFECTIVE_DATE is not null or ADDRESS_EXPIRATION_DATE is not null or
10042: DATE_OF_BIRTH is not null or DATE_OF_DEATH is not null or MARITAL_STATUS_EFFECTIVE_DATE is not null);

Line 11780: FROM AMS_HZ_B2C_MAPPING_V

11776: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(ORIG_SYSTEM_REFERENCE)),'x')),240) -240,0,' ','ORIG_SYSTEM_REFERENCE :'||l_invalid_size
11777: ||'(240)') ORIG_SYSTEM_REFERENCE,
11778: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(TAX_REFERENCE)),'x')),60) - 60,0,' ','TAX_REFERENCE :'||l_invalid_size||'(60)') TAX_REFERENCE,
11779: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(RENT_OWNED_INDICATOR)),'x')),30) - 30,0,' ','RENT_OWNED_INDICATOR :'||l_invalid_size||'(30)') RENT_OWNED_INDICATOR
11780: FROM AMS_HZ_B2C_MAPPING_V
11781: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id
11782: and load_status = 'ERROR'
11783: AND
11784: (

Line 13979: UPDATE ams_hz_b2c_mapping_v b2c

13975: elsif l_import_type = 'B2C' then
13976:
13977: --aanjaria: bug 4913239: copy party_id to person_party_id so that existence check is by passed
13978: -- mayjain bug 5100612 this update should be done only if the party_id is a valid one.
13979: UPDATE ams_hz_b2c_mapping_v b2c
13980: SET person_party_id = (select party_id from hz_parties where party_type = 'PERSON' and party_id = b2c.party_id and nvl(status,'A') = 'A') -- bug 5100612,
13981: WHERE import_list_header_id = p_import_list_header_id
13982: AND party_id is not null
13983: AND person_party_id is null;

Line 13986: UPDATE ams_hz_b2c_mapping_v b2c

13982: AND party_id is not null
13983: AND person_party_id is null;
13984:
13985: -- bug 5100612
13986: UPDATE ams_hz_b2c_mapping_v b2c
13987: SET person_exist = 'Y'
13988: WHERE import_list_header_id = p_import_list_header_id
13989: and person_party_id is not null;
13990: end if;

Line 18055: Insert into AMS_HZ_B2C_MAPPING_V(

18051: open c_batchID;
18052: fetch c_batchID into l_batch_id;
18053: close c_batchID;
18054: FOR i IN 1..p_cust_b2c_tbl.COUNT LOOP
18055: Insert into AMS_HZ_B2C_MAPPING_V(
18056: IMPORT_SOURCE_LINE_ID,
18057: LAST_UPDATED_BY,
18058: LAST_UPDATE_DATE,
18059: CREATION_DATE,

Line 19104: from ams_hz_b2c_mapping_v b2c

19100:
19101: cursor c_per_key is
19102: select b2c.import_source_line_id, 'N',
19103: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19104: from ams_hz_b2c_mapping_v b2c
19105: where b2c.import_list_header_id = p_import_list_header_id
19106: and b2c.load_status in ('ACTIVE','RELOAD')
19107: and b2c.PERSON_FIRST_NAME is not null
19108: and b2c.PERSON_LAST_NAME is not null

Line 19113: from hz_parties pty, ams_hz_b2c_mapping_v b2c

19109: and b2c.PERSON_PARTY_ID is null;
19110:
19111: cursor c_person_exists is
19112: select distinct b2c.import_source_line_id, 'Y'
19113: from hz_parties pty, ams_hz_b2c_mapping_v b2c
19114: where b2c.import_list_header_id = p_import_list_header_id
19115: and pty.customer_key = b2c.person_key
19116: and b2c.person_key is not null
19117: and b2c.PERSON_PARTY_ID is null

Line 19124: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c

19120: and pty.party_type = 'PERSON';
19121:
19122: cursor c_email_address is
19123: select b2c.import_source_line_id, max(p.party_id)
19124: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c
19125: where b2c.import_list_header_id = p_import_list_header_id
19126: and b2c.load_status in ('ACTIVE','RELOAD')
19127: and b2c.person_exist = 'Y'
19128: and b2c.email_address is not null

Line 19141: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c

19137: group by b2c.import_source_line_id;
19138:
19139: cursor c_ph_number is
19140: select b2c.import_source_line_id, max(p.party_id)
19141: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c
19142: where b2c.import_list_header_id = p_import_list_header_id
19143: and b2c.load_status in ('ACTIVE','RELOAD')
19144: and b2c.person_exist = 'Y'
19145: and b2c.phone_number is not null

Line 19161: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c

19157: group by b2c.import_source_line_id;
19158:
19159: cursor c_address_country is
19160: select b2c.import_source_line_id, max(psite.party_id)
19161: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19162: where b2c.import_list_header_id = p_import_list_header_id
19163: and b2c.load_status in ('ACTIVE','RELOAD')
19164: and b2c.person_exist = 'Y'
19165: and b2c.address1 is not null

Line 19180: from ams_hz_b2c_mapping_v

19176:
19177: cursor c_per_dedup is
19178: select max(import_source_line_id),person_key,email_address,transposed_phone_number,address1,
19179: country, 'DUPLICATE' status
19180: from ams_hz_b2c_mapping_v
19181: where import_list_header_id = p_import_list_header_id
19182: and load_status in ('ACTIVE','RELOAD')
19183: group by person_key,email_address,transposed_phone_number,address1,country;
19184:

Line 19206: UPDATE AMS_HZ_B2C_MAPPING_V

19202: EXIT;
19203: END IF;
19204:
19205: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST
19206: UPDATE AMS_HZ_B2C_MAPPING_V
19207: SET person_key = L_person_KEY(I),
19208: person_exist = L_person_EXIST(I)
19209: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19210:

Line 19236: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19232:
19233: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19234: EXIT;
19235: END IF;
19236: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19237: SET person_exist = L_person_EXIST(I)
19238: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19239:
19240: if l_last_fetch then

Line 19264: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19260:
19261: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19262: EXIT;
19263: END IF;
19264: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19265: SET person_party_id = L_person_PARTY_ID(I)
19266: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19267:
19268: if l_last_fetch then

Line 19293: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19289:
19290: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19291: EXIT;
19292: END IF;
19293: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19294: SET person_party_id = L_person_PARTY_ID(I)
19295: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19296:
19297: if l_last_fetch then

Line 19322: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19318:
19319: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19320: EXIT;
19321: END IF;
19322: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19323: SET person_party_id = L_person_PARTY_ID(I)
19324: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19325:
19326: if l_last_fetch then

Line 19357: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19353:
19354: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19355: EXIT;
19356: END IF;
19357: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19358: SET load_status = L_person_status(i)
19359: WHERE import_list_header_id = p_import_list_header_id
19360: and IMPORT_SOURCE_LINE_ID < L_IMPORT_SOURCE_LINE_ID(i)
19361: and load_status in ('ACTIVE','RELOAD')

Line 19419: from ams_hz_b2c_mapping_v b2c

19415:
19416: cursor c_per_key is
19417: select b2c.import_source_line_id, 'N',
19418: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19419: from ams_hz_b2c_mapping_v b2c
19420: where b2c.import_list_header_id = p_import_list_header_id
19421: and b2c.load_status in ('ACTIVE','RELOAD')
19422: and b2c.PERSON_FIRST_NAME is not null
19423: and b2c.PERSON_LAST_NAME is not null;

Line 19427: from ams_hz_b2c_mapping_v b2c

19423: and b2c.PERSON_LAST_NAME is not null;
19424:
19425: cursor c_person_exists is
19426: select b2c.import_source_line_id, 'Y'
19427: from ams_hz_b2c_mapping_v b2c
19428: where b2c.import_list_header_id = p_import_list_header_id
19429: and b2c.person_key is not null
19430: and b2c.PERSON_PARTY_ID is null
19431: and b2c.load_status in ('ACTIVE','RELOAD')

Line 19439: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c

19435: and pty.party_type = 'PERSON');
19436:
19437: cursor c_email_address is
19438: select b2c.import_source_line_id, max(p.party_id)
19439: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c
19440: where b2c.import_list_header_id = p_import_list_header_id
19441: and b2c.load_status in ('ACTIVE','RELOAD')
19442: and b2c.person_exist = 'Y'
19443: and b2c.orig_system_reference = p.orig_system_reference

Line 19456: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c

19452: group by b2c.import_source_line_id;
19453:
19454: cursor c_ph_number is
19455: select b2c.import_source_line_id, max(p.party_id)
19456: from hz_contact_points cp, hz_parties p, ams_hz_b2c_mapping_v b2c
19457: where b2c.import_list_header_id = p_import_list_header_id
19458: and b2c.load_status in ('ACTIVE','RELOAD')
19459: and b2c.person_exist = 'Y'
19460: and b2c.phone_number is not null

Line 19477: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c

19473: group by b2c.import_source_line_id;
19474:
19475: cursor c_address_country is
19476: select b2c.import_source_line_id, max(psite.party_id)
19477: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19478: where b2c.import_list_header_id = p_import_list_header_id
19479: and b2c.load_status in ('ACTIVE','RELOAD')
19480: and b2c.person_exist = 'Y'
19481: and b2c.address1 is not null

Line 19512: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19508:
19509: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19510: EXIT;
19511: END IF;
19512: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19513: SET person_key = L_person_KEY(I),
19514: person_exist = L_person_EXIST(I)
19515: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19516:

Line 19542: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19538:
19539: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19540: EXIT;
19541: END IF;
19542: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19543: SET person_exist = L_person_EXIST(I)
19544: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19545:
19546: if l_last_fetch then

Line 19570: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19566:
19567: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19568: EXIT;
19569: END IF;
19570: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19571: SET person_party_id = L_person_PARTY_ID(I)
19572: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19573:
19574: if l_last_fetch then

Line 19599: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19595:
19596: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19597: EXIT;
19598: END IF;
19599: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19600: SET person_party_id = L_person_PARTY_ID(I)
19601: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19602:
19603: if l_last_fetch then

Line 19628: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

19624:
19625: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
19626: EXIT;
19627: END IF;
19628: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
19629: SET person_party_id = L_person_PARTY_ID(I)
19630: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
19631:
19632: if l_last_fetch then

Line 20701: from ams_hz_b2c_mapping_v b2c

20697: cursor c_addr_key is
20698: select b2c.import_source_line_id,
20699: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2c.address1,b2c.address2,b2c.address3,b2c.address4,b2c.postal_code,null,null)
20700: "add_key"
20701: from ams_hz_b2c_mapping_v b2c
20702: where b2c.import_list_header_id = p_import_list_header_id
20703: and b2c.load_status in ('ACTIVE','RELOAD')
20704: and b2c.address1 is not null;
20705:

Line 20708: from hz_party_sites ps, hz_locations loc,ams_hz_b2c_mapping_v b2c

20704: and b2c.address1 is not null;
20705:
20706: cursor c_addr_ps is
20707: select b2c.import_source_line_id,max(loc.location_id)
20708: from hz_party_sites ps, hz_locations loc,ams_hz_b2c_mapping_v b2c
20709: where b2c.import_list_header_id = p_import_list_header_id
20710: and b2c.load_status in ('ACTIVE','RELOAD')
20711: and b2c.address_key is not null
20712: and b2c.person_party_id is not null

Line 20722: from hz_locations loc,ams_hz_b2c_mapping_v b2c

20718: group by b2c.import_source_line_id;
20719:
20720: cursor c_addr is
20721: select b2c.import_source_line_id,max(loc.location_id)
20722: from hz_locations loc,ams_hz_b2c_mapping_v b2c
20723: where b2c.import_list_header_id = p_import_list_header_id
20724: and b2c.load_status in ('ACTIVE','RELOAD')
20725: and b2c.address_key is not null
20726: and b2c.party_location_id is null

Line 20749: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

20745:
20746: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
20747: EXIT;
20748: END IF;
20749: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
20750: SET address_key = L_address_KEY(I)
20751: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
20752:
20753: if l_last_fetch then

Line 20777: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

20773:
20774: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
20775: EXIT;
20776: END IF;
20777: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
20778: SET party_location_id = L_PARTY_location_ID(I)
20779: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
20780:
20781: if l_last_fetch then

Line 20806: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V

20802:
20803: IF L_IMPORT_SOURCE_LINE_ID.COUNT = 0 AND l_last_fetch THEN
20804: EXIT;
20805: END IF;
20806: FORALL i IN L_IMPORT_SOURCE_LINE_ID.FIRST..L_IMPORT_SOURCE_LINE_ID.LAST UPDATE AMS_HZ_B2C_MAPPING_V
20807: SET party_location_id = L_PARTY_location_ID(I)
20808: WHERE IMPORT_SOURCE_LINE_ID = L_IMPORT_SOURCE_LINE_ID(i);
20809:
20810: if l_last_fetch then

Line 21199: ams_hz_b2c_mapping_v

21195: cursor c_b2c_ph_no is
21196: select IMPORT_SOURCE_LINE_ID ,
21197: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"
21198: from
21199: ams_hz_b2c_mapping_v
21200: where import_list_header_id = p_import_list_header_id
21201: and phone_number is not null
21202: and TRANSPOSED_PHONE_NUMBER is null
21203: and load_status in ('ACTIVE','RELOAD');

Line 21297: from ams_hz_b2c_mapping_v

21293: and load_status = 'RELOAD';
21294:
21295: cursor c_b2cxmlrec is
21296: select per_imp_xml_element_id, add_imp_xml_element_id,cp_imp_xml_element_id, em_imp_xml_element_id
21297: from ams_hz_b2c_mapping_v
21298: where import_list_header_id = p_import_list_header_id
21299: and load_status = 'RELOAD';
21300:
21301: begin