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_CUSTOMER_INT dependencies on AR_LOCATION_VALUES

Line 1450: FROM ar_location_values v,

1446: --FOR postal_code.city.county.state
1447:
1448: CURSOR C IS
1449: SELECT 'X'
1450: FROM ar_location_values v,
1451: ar_location_values pv,
1452: ar_location_values gv,
1453: ar_location_values ggv,
1454: ar_location_rates r

Line 1451: ar_location_values pv,

1447:
1448: CURSOR C IS
1449: SELECT 'X'
1450: FROM ar_location_values v,
1451: ar_location_values pv,
1452: ar_location_values gv,
1453: ar_location_values ggv,
1454: ar_location_rates r
1455: WHERE v.location_structure_id = p_location_structure_id

Line 1452: ar_location_values gv,

1448: CURSOR C IS
1449: SELECT 'X'
1450: FROM ar_location_values v,
1451: ar_location_values pv,
1452: ar_location_values gv,
1453: ar_location_values ggv,
1454: ar_location_rates r
1455: WHERE v.location_structure_id = p_location_structure_id
1456: AND v.location_segment_id = r.location_segment_id

Line 1453: ar_location_values ggv,

1449: SELECT 'X'
1450: FROM ar_location_values v,
1451: ar_location_values pv,
1452: ar_location_values gv,
1453: ar_location_values ggv,
1454: ar_location_rates r
1455: WHERE v.location_structure_id = p_location_structure_id
1456: AND v.location_segment_id = r.location_segment_id
1457: AND v.location_segment_value = UPPER(p_postal_code)

Line 1476: FROM ar_location_values v,

1472: --For city.county.state structure
1473:
1474: CURSOR C1 IS
1475: SELECT 'X'
1476: FROM ar_location_values v,
1477: ar_location_values pv,
1478: ar_location_values gv,
1479: ar_location_rates r
1480: WHERE v.location_structure_id = p_location_structure_id

Line 1477: ar_location_values pv,

1473:
1474: CURSOR C1 IS
1475: SELECT 'X'
1476: FROM ar_location_values v,
1477: ar_location_values pv,
1478: ar_location_values gv,
1479: ar_location_rates r
1480: WHERE v.location_structure_id = p_location_structure_id
1481: AND v.location_segment_id = r.location_segment_id

Line 1478: ar_location_values gv,

1474: CURSOR C1 IS
1475: SELECT 'X'
1476: FROM ar_location_values v,
1477: ar_location_values pv,
1478: ar_location_values gv,
1479: ar_location_rates r
1480: WHERE v.location_structure_id = p_location_structure_id
1481: AND v.location_segment_id = r.location_segment_id
1482: AND v.location_segment_value = UPPER(p_city)

Line 1499: FROM ar_location_values v,

1495: --For city.province and city.state structure
1496:
1497: CURSOR C2(p_child VARCHAR2,p_parent_value VARCHAR2,p_child_value VARCHAR2) IS
1498: SELECT 'X'
1499: FROM ar_location_values v,
1500: ar_location_values gv,
1501: ar_location_rates r
1502: WHERE v.location_structure_id = p_location_structure_id
1503: AND v.location_segment_id = r.location_segment_id

Line 1500: ar_location_values gv,

1496:
1497: CURSOR C2(p_child VARCHAR2,p_parent_value VARCHAR2,p_child_value VARCHAR2) IS
1498: SELECT 'X'
1499: FROM ar_location_values v,
1500: ar_location_values gv,
1501: ar_location_rates r
1502: WHERE v.location_structure_id = p_location_structure_id
1503: AND v.location_segment_id = r.location_segment_id
1504: AND v.location_segment_value = UPPER(p_child_value)

Line 1518: FROM ar_location_values v, ar_location_rates r

1514: --For city and province Structure
1515:
1516: CURSOR C3(p_segment VARCHAR2,p_value VARCHAR2) IS
1517: SELECT 'X'
1518: FROM ar_location_values v, ar_location_rates r
1519: WHERE v.location_structure_id = p_location_structure_id
1520: AND v.location_segment_id = r.location_segment_id
1521: AND v.location_segment_value = UPPER(p_value)
1522: AND v.location_segment_qualifier = p_segment