The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_id
FROM ams_party_market_segments
WHERE market_segment_id = p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND end_date_active IS NULL
ORDER BY party_id;
UPDATE AMS_PARTY_MARKET_SEGMENTS
SET end_date_active = SYSDATE
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = l_old_party_id;
SELECT market_segment_id, party_id FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_id <> p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND end_date_active IS NULL
ORDER BY party_id;
UPDATE ams_party_market_segments
SET end_date_active = SYSDATE
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = l_old_mkt_seg_id
AND party_id = l_old_party_id;
PROCEDURE Insert_New_Party
(
p_mkt_seg_id IN NUMBER
, p_mkt_seg_flag IN VARCHAR2
, p_sql_str IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_new_party';
SELECT count(*) FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = id;
SELECT count(*) FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = id
AND end_date_active IS NOT NULL;
SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
FROM DUAL;
SELECT count(*)
FROM AMS_PARTY_MARKET_SEGMENTS
WHERE ams_party_market_segment_id = party_mkt_seg_id;
AMS_Utility_Pvt.Debug_Message('Insert ');
AMS_Utility_Pvt.Debug_Message('Insert ');
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
)
VALUES
(
l_party_mkt_seg_id
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, p_mkt_seg_id
, p_mkt_seg_flag
, l_party_id
, SYSDATE
, NULL
);
AMS_Utility_Pvt.Debug_Message('Update ');
UPDATE AMS_PARTY_MARKET_SEGMENTS SET
last_update_date = SYSDATE
, last_updated_by = FND_GLOBAL.user_id
, last_update_login = FND_GLOBAL.conc_login_id
, object_version_number = object_version_number + 1
, market_segment_id = p_mkt_seg_id
, market_segment_flag = p_mkt_seg_flag
, party_id = l_party_id
, start_date_active =SYSDATE
, end_date_active = NULL
WHERE market_segment_id = p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND party_id = l_party_id;
AMS_Utility_Pvt.Debug_Message('Error in insert_new_party'||sqlerrm);
END Insert_New_Party;
SELECT party_id FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_id = p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND end_date_active IS NULL
ORDER BY party_id;
UPDATE AMS_PARTY_MARKET_SEGMENTS
SET end_date_active = SYSDATE
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = l_old_party_id;
SELECT market_segment_id, party_id
FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_id <> p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND end_date_active IS NULL
ORDER BY party_id;
UPDATE AMS_PARTY_MARKET_SEGMENTS
SET end_date_active = SYSDATE
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = l_old_mkt_seg_id
AND party_id = l_old_party_id;
PROCEDURE Insert_New_Party_Dbms
(
p_mkt_seg_id IN NUMBER
, p_mkt_seg_flag IN VARCHAR2
, p_sql_tbl IN t_party_tab
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_new_party';
SELECT count(*) FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = id;
SELECT count(*) FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_segment_flag = p_mkt_seg_flag
AND market_segment_id = p_mkt_seg_id
AND party_id = id
AND end_date_active IS NOT NULL;
SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
FROM DUAL;
SELECT count(*)
FROM AMS_PARTY_MARKET_SEGMENTS
WHERE ams_party_market_segment_id = party_mkt_seg_id;
AMS_Utility_Pvt.Debug_Message('Insert ');
AMS_Utility_Pvt.Debug_Message('Insert ');
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
)
VALUES
(
l_party_mkt_seg_id
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, p_mkt_seg_id
, p_mkt_seg_flag
, l_party_id
, SYSDATE
, NULL
);
AMS_Utility_Pvt.Debug_Message('Update ');
UPDATE AMS_PARTY_MARKET_SEGMENTS SET
last_update_date = SYSDATE
, last_updated_by = FND_GLOBAL.user_id
, last_update_login = FND_GLOBAL.conc_login_id
, object_version_number = object_version_number + 1
, market_segment_id = p_mkt_seg_id
, market_segment_flag = p_mkt_seg_flag
, party_id = l_party_id
, start_date_active =SYSDATE
, end_date_active = NULL
WHERE market_segment_id = p_mkt_seg_id
AND market_segment_flag = p_mkt_seg_flag
AND party_id = l_party_id;
AMS_Utility_Pvt.Debug_Message('Error in insert_new_party'||sqlerrm);
END Insert_New_Party_Dbms;
Insert_New_Party
(
p_mkt_seg_id,
'Y',
l_sql_str,
x_return_status,
x_msg_count ,
x_msg_data
);
Insert_New_Party_Dbms
(
p_mkt_seg_id,
'Y',
l_party_tab,
x_return_status,
x_msg_count ,
x_msg_data
);
Insert_New_Party
(
p_mkt_seg_id,
'N',
l_sql_str,
x_return_status,
x_msg_count ,
x_msg_data
);
Insert_New_Party_Dbms
(
p_mkt_seg_id,
'N',
l_party_tab,
x_return_status,
x_msg_count ,
x_msg_data
);
SELECT cell_id, market_segment_flag,cell_name
FROM ams_cells_vl
WHERE cell_id = l_cell_id
OR (parent_cell_id = l_cell_id
AND market_segment_flag = 'N' );
SELECT cell_id, market_segment_flag ,cell_name
FROM ams_cells_vl ;
SELECT workbook_name,workbook_owner,worksheet_name
FROM ams_act_discoverer_all
WHERE act_discoverer_used_by_id = cell_id
AND arc_act_discoverer_used_by = 'CELL';
l_party_str := 'SELECT '||SUBSTR(l_party_str,INSTR(l_party_str,',',-1,1) +1 )||' FROM ' ;
SELECT 1
FROM ams_discoverer_sql
WHERE workbook_name = p_workbook_name
AND workbook_owner_name = p_workbook_owner
AND worksheet_name = p_worksheet_name ;
SELECT sql_string
FROM ams_discoverer_sql
WHERE workbook_name = p_workbook_name
AND worksheet_name = p_worksheet_name
AND workbook_owner_name = p_workbook_owner
AND sequence_order <= l_sequence_order
ORDER BY Sequence_Order;
SELECT sql_string
FROM ams_discoverer_sql
WHERE workbook_name = p_workbook_name
AND worksheet_name = p_worksheet_name
AND workbook_owner_name = p_workbook_owner
AND sequence_order >= l_sequence_order
ORDER BY sequence_order;
AMS_Cell_PVT.Update_Segment_Size
( p_cell_id => p_cell_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
* changed. The insert statement for AMS_PARTY_MARKET_SEGMENTS
* is changed. It now inserts cust_account_id,cust_acct_site_id
* and cust_site_use_code.
******************************************************************************/
PROCEDURE generate_party_for_territory
( p_errbuf OUT NOCOPY VARCHAR2,
p_retcode OUT NOCOPY NUMBER,
p_terr_id IN NUMBER,
p_getparent_flag IN VARCHAR2 := 'N',
p_bind_vars IN BIND_TBL_TYPE,
p_hzparty_sql IN VARCHAR2 := null,
p_hzpartyacc_sql IN VARCHAR2 := null,
p_hzpartyrel_sql IN VARCHAR2 := null,
-- p_hzpartysite_sql IN VARCHAR2 := null,
p_hzpartysiteuse_sql IN VARCHAR2 := null,
p_hzcustprof_sql IN VARCHAR2 := null,
p_hzlocations_sql IN VARCHAR2 := null
-- p_hzcustname_sql IN VARCHAR2 := null,
-- p_hzcustcat_sql IN VARCHAR2 := null,
-- p_hzsaleschannel_sql IN VARCHAR2 := null
)
IS
l_full_name CONSTANT VARCHAR2(60) := 'GENERATE_PARTY_FOR_TERRITORY';
l_party_select_sql VARCHAR2(32000) := null;
CURSOR c_party_mkt_seg_seq IS -- generate an ID for INSERT
SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
FROM DUAL;
l_party_select_sql := 'select DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id,hzcsua.site_use_code';
l_party_select_sql := l_party_select_sql || ' from hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa,hz_cust_accounts hzca, ';
l_party_select_sql := l_party_select_sql || ' hz_party_sites hzps, hz_locations hzloc, hz_parties hzp ' ;
write_conc_log('l_hzparty_sql ' || l_party_select_sql || l_party_where_sql);
IF l_party_select_sql IS NULL THEN
l_party_select_sql := 'SELECT DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id, hzcsua.site_use_code ' ;
l_party_select_sql := l_party_select_sql || ' FROM hz_cust_accounts hzca, hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa ';
write_conc_log('IF l_hzpartysiteuse_sql ' || l_party_select_sql || l_party_where_sql);
write_conc_log('Else l_hzpartysiteuse_sql ' || l_party_select_sql || l_party_where_sql);
IF l_party_select_sql IS NULL THEN
l_party_select_sql := 'SELECT DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id, hzcsua.site_use_code FROM ';
l_party_select_sql := l_party_select_sql || 'hz_cust_accounts hzca, hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa, ';
l_party_select_sql := l_party_select_sql || ' hz_party_sites hzps ';
write_conc_log('IF l_hzpartyacc_sql ' || l_party_select_sql || l_party_where_sql);
l_party_select_sql := l_party_select_sql || ' ,hz_party_sites hzps ';
write_conc_log('ELSE l_hzpartyacc_sql ' || l_party_select_sql || l_party_where_sql);
IF l_party_select_sql IS NULL THEN
l_party_select_sql := 'SELECT DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id,hzcsua.site_use_code from ';
l_party_select_sql := l_party_select_sql || ' hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa, hz_cust_accounts hzca, ';
l_party_select_sql := l_party_select_sql || ' hz_relationships hzpr ';
write_conc_log('IF l_hzpartyrel_sql ' || l_party_select_sql || l_party_where_sql);
l_party_select_sql := l_party_select_sql || ', hz_relationships hzpr';
write_conc_log('Else l_hzpartyrel_sql ' || l_party_select_sql || l_party_where_sql);
IF l_party_select_sql IS NULL THEN
l_party_select_sql := 'SELECT DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id, ';
l_party_select_sql := l_party_select_sql || ' hzcsua.site_use_code FROM hz_cust_accounts hzca, hz_cust_site_uses_all hzcsua, ';
l_party_select_sql := l_party_select_sql || ' hz_cust_acct_sites_all hzcasa, hz_customer_profiles hzcp';
write_conc_log(' If l_hzcustprof_sql ' || l_party_select_sql || l_party_where_sql);
l_party_select_sql := l_party_select_sql || ', hz_customer_profiles hzcp';
write_conc_log(' If Else If l_hzcustprof_sql ' || l_party_select_sql || l_party_where_sql);
l_party_select_sql := l_party_select_sql || ', hz_customer_profiles hzcp ';
write_conc_log(' If Else else l_hzcustprof_sql ' || l_party_select_sql || l_party_where_sql);
IF l_party_select_sql IS NULL THEN
l_party_select_sql := 'SELECT DISTINCT hzca.party_id, hzca.cust_account_id, hzcsua.cust_acct_site_id,hzcsua.site_use_code ';
l_party_select_sql := l_party_select_sql || ' from hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa, hz_cust_accounts hzca, ';
l_party_select_sql := l_party_select_sql || ' hz_relationships hzpr, hz_party_sites hzps, hz_locations hzloc ';
write_conc_log(' If l_hzloactions_sql ' || l_party_select_sql || l_party_where_sql);
l_party_select_sql := l_party_select_sql || ', hz_locations hzloc, hz_party_sites hzps ';
write_conc_log(' Else l_hzloactions_sql ' || l_party_select_sql || l_party_where_sql);
DBMS_OUTPUT.PUT_LINE(' final from sql(' || length(l_party_select_sql) || '): ' || l_party_select_sql);
DELETE FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_qualifier_type = 'TERRITORY'
AND market_qualifier_reference = p_terr_id;
write_conc_log('D: The dynamic SQL ' || l_party_select_sql ||substr(l_party_where_sql, 1, length(l_party_where_sql)-4));
IF l_party_select_sql IS NOT NULL THEN
-- yzhao: 05/08/2003 SQL bind variable project
l_final_sql := 'INSERT INTO AMS_PARTY_MARKET_SEGMENTS(ams_party_market_segment_id, last_update_date, last_updated_by';
l_final_sql := l_final_sql || ', creation_date, created_by, last_update_login, object_version_number, market_segment_id';
l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';
l_final_sql := l_final_sql || l_party_select_sql || substr(l_party_where_sql, 1, length(l_party_where_sql)-4) || ')';
OPEN l_party_cv FOR l_party_select_sql || substr(l_party_where_sql, 1, length(l_party_where_sql)-4);
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
, org_id
, market_qualifier_type
, market_qualifier_reference
, cust_account_id
, cust_acct_site_id
, site_use_code
)
VALUES
(
l_party_mkt_seg_id
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, 0
, 'N'
, l_party_id
, SYSDATE
, NULL
, l_client_info
, 'TERRITORY'
, p_terr_id
,l_cust_account_id
,l_cust_acct_site_id
,l_cust_site_use_code
);
SELECT subject_id
FROM hz_relationships
WHERE relationship_code = fnd_profile.VALUE('AMS_PARTY_RELATIONS_TYPE')
AND subject_type = 'ORGANIZATION'
AND subject_table_name = 'HZ_PARTIES'
AND object_type = 'ORGANIZATION'
AND object_table_name = 'HZ_PARTIES'
AND start_date <= SYSDATE AND NVL(end_date, SYSDATE) >= SYSDATE
AND status = 'A'
AND object_id = p_bg_id
/* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI */
AND directional_flag = NVL(p_direction, directional_flag);
SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
FROM DUAL;
DELETE FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_qualifier_type = 'BG'
AND market_qualifier_reference = p_bg_id;
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
, org_id
, market_qualifier_type
, market_qualifier_reference
)
VALUES
(
l_index
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, 0
, 'N'
, p_bg_id
, SYSDATE
, NULL
, l_client_info
, 'BG'
, p_bg_id
);
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
, org_id
, market_qualifier_type
, market_qualifier_reference
)
VALUES
(
l_party_mkt_seg_id(I)
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, 0
, 'N'
, l_all_obj_list(I)
, SYSDATE
, NULL
, l_client_info
, 'BG'
, p_bg_id
);
for non-directional records, always insert a row pair of (A, B) and (B, A) */
IF (p_direction IS NOT NULL AND l_all_obj_list.FIRST IS NOT NULL) THEN
FOR I IN l_all_obj_list.FIRST .. l_all_obj_list.LAST LOOP
OPEN c_party_mkt_seg_seq;
INSERT INTO AMS_PARTY_MARKET_SEGMENTS
(
ams_party_market_segment_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
, market_segment_id
, market_segment_flag
, party_id
, start_date_active
, end_date_active
, org_id
, market_qualifier_type
, market_qualifier_reference
)
VALUES
(
l_party_mkt_seg_id(I)
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.conc_login_id
, 1
, 0
, 'N'
, p_bg_id
, SYSDATE
, NULL
, l_client_info
, 'BG'
, l_all_obj_list(I)
);
SELECT distinct terr_id
FROM jtf_terr_overview_v jtov
WHERE jtov.source_id = -1003
AND parent_territory_id = 1;
select distinct JTR.terr_id
FROM JTF_TERR_ALL JTR ,
JTF_TERR_USGS_ALL JTU ,
JTF_SOURCES_ALL JSE
WHERE
JTU.TERR_ID = JTR.TERR_ID
AND JTU.SOURCE_ID = JSE.SOURCE_ID
AND JTU.SOURCE_ID = -1003
AND JTR.PARENT_TERRITORY_ID = 1
AND NVL(JTR.ORG_ID, -99) = NVL(JTU.ORG_ID, NVL(JTR.ORG_ID, -99))
AND JSE.ORG_ID IS NULL
AND NVL(JTR.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ' ,
NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)) =
NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',
NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
SELECT relationship_type, direction_code
FROM hz_relationship_types
WHERE (forward_rel_code = p_relationship_code
OR backward_rel_code = p_relationship_code)
AND subject_type = 'ORGANIZATION'
AND object_type = 'ORGANIZATION'
/* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI
P - Parent C - Child N - non-directional
e.g. 'PARTNER_OF' is non-directional relationship
AND direction_code = 'P'
*/
AND direction_code IN ('P', 'N')
AND status = 'A';
SELECT distinct r1.object_id
FROM hz_relationships r1
WHERE r1.relationship_type = p_relationship_type
AND r1.relationship_code = p_relationship_code
AND r1.subject_type = 'ORGANIZATION'
AND r1.subject_table_name = 'HZ_PARTIES'
AND r1.object_type = 'ORGANIZATION'
AND r1.object_table_name = 'HZ_PARTIES'
AND r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
AND r1.status = 'A'
/* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI
handle non-directional relationship e.g. PARTNER_OF
*/
AND r1.directional_flag = NVL(p_direction_code, r1.directional_flag)
AND NOT EXISTS
(SELECT 1
FROM hz_relationships r2
WHERE r1.object_id = r2.subject_id
AND r2.relationship_type = p_relationship_type
AND r2.relationship_code = p_relationship_code
AND r2.subject_type = 'ORGANIZATION'
AND r2.subject_table_name = 'HZ_PARTIES'
AND r2.object_type = 'ORGANIZATION'
AND r2.object_table_name = 'HZ_PARTIES'
AND r2.start_date <= SYSDATE AND NVL(r2.end_date, SYSDATE) >= SYSDATE
AND r2.status = 'A'
/* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI
handle non-directional relationship e.g. PARTNER_OF
*/
AND r2.directional_flag = NVL(p_direction_code, r2.directional_flag)
);
DELETE FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_qualifier_type = 'BG';
DELETE FROM AMS_PARTY_MARKET_SEGMENTS
WHERE market_qualifier_type = 'TERRITORY';