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.ZX_TEST_API dependencies on HZ_PARTY_SITES

Line 1352: -- HZ_PARTY_SITES or PO_VENDOR_SITES, so we have the following:

1348: -- This User Key is a special case.
1349: -- Depending of the mapping of ZX_EVENT_CLS_MAPPINGS and
1350: -- value in table ZX_PARTY_TYPES, for
1351: -- every user_key, will be chosen a from either
1352: -- HZ_PARTY_SITES or PO_VENDOR_SITES, so we have the following:
1353: -- If PO_VENDOR_SITES the segments in user key are:
1354: -- Segment 1 is VENDOR_NAME
1355: -- Segment 2 is VENDOR_SITE_CODE
1356: -- Segment 3 is ORG_ID

Line 1357: -- If HZ_PARTY_SITES the segments in user key are:

1353: -- If PO_VENDOR_SITES the segments in user key are:
1354: -- Segment 1 is VENDOR_NAME
1355: -- Segment 2 is VENDOR_SITE_CODE
1356: -- Segment 3 is ORG_ID
1357: -- If HZ_PARTY_SITES the segments in user key are:
1358: -- Segment 1 is PARTY_SITE_NUMBER
1359: -- Segment 2 is PARTY_SITE_NAME
1360: -----------------------------------------------------------
1361: IF p_user_key_type in ('RNDG_SHIP_TO_PARTY_SITE_ID',

Line 1430: IF l_table_name = 'HZ_PARTY_SITES' THEN -- Verify if it is PARTIES or PARTY_SITES

1426: WHEN OTHERS THEN l_table_name := null;
1427: END;
1428:
1429: BEGIN
1430: IF l_table_name = 'HZ_PARTY_SITES' THEN -- Verify if it is PARTIES or PARTY_SITES
1431: ---------------------------------------------------
1432: -- Retrieves the user_key_id using HZ_PARTY_SITES
1433: ---------------------------------------------------
1434: write_message('~ Retrieves the user_key_id using HZ_PARTY_SITES');

Line 1432: -- Retrieves the user_key_id using HZ_PARTY_SITES

1428:
1429: BEGIN
1430: IF l_table_name = 'HZ_PARTY_SITES' THEN -- Verify if it is PARTIES or PARTY_SITES
1431: ---------------------------------------------------
1432: -- Retrieves the user_key_id using HZ_PARTY_SITES
1433: ---------------------------------------------------
1434: write_message('~ Retrieves the user_key_id using HZ_PARTY_SITES');
1435: begin
1436:

Line 1434: write_message('~ Retrieves the user_key_id using HZ_PARTY_SITES');

1430: IF l_table_name = 'HZ_PARTY_SITES' THEN -- Verify if it is PARTIES or PARTY_SITES
1431: ---------------------------------------------------
1432: -- Retrieves the user_key_id using HZ_PARTY_SITES
1433: ---------------------------------------------------
1434: write_message('~ Retrieves the user_key_id using HZ_PARTY_SITES');
1435: begin
1436:
1437: select party_site_id
1438: into x_user_key_id

Line 1439: from hz_party_sites

1435: begin
1436:
1437: select party_site_id
1438: into x_user_key_id
1439: from hz_party_sites
1440: where party_site_number = l_varchar2_id ;
1441: exception
1442: WHEN no_data_found then
1443: select party_site_id

Line 1450: from hz_party_sites

1446: where vendor_site_code = l_varchar2_id;
1447:
1448: select location_id
1449: into l_ship_from_location_id
1450: from hz_party_sites
1451: where party_site_id=x_user_key_id;
1452: end;
1453: ELSE
1454: ---------------------------------------------------