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.FV_1099_TRANSACTION dependencies on HZ_LOCATIONS

Line 18: v_address1 hz_locations.address1%TYPE;

14: IS
15: l_module_name VARCHAR2(200) ;
16: v_cust_name hz_parties.party_name%TYPE;
17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;

Line 19: v_address2 hz_locations.address2%TYPE;

15: l_module_name VARCHAR2(200) ;
16: v_cust_name hz_parties.party_name%TYPE;
17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;

Line 20: v_address3 hz_locations.address3%TYPE;

16: v_cust_name hz_parties.party_name%TYPE;
17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;

Line 21: v_address4 hz_locations.address4%TYPE;

17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;

Line 22: v_city hz_locations.city%TYPE;

18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;

Line 23: v_state hz_locations.state%TYPE;

19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;

Line 24: v_postal_code hz_locations.postal_code%TYPE;

20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;

Line 25: v_province hz_locations.province%TYPE;

21: v_address4 hz_locations.address4%TYPE;
22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

Line 26: v_country hz_locations.country%TYPE;

22: v_city hz_locations.city%TYPE;
23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
30: v_apply_date ar_adjustments.apply_date%TYPE;

Line 170: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps

166: SELECT address1, address2, address3, address4, city, state,
167: postal_code, country, province
168: INTO v_address1, v_address2, v_address3, v_address4, v_city,
169: v_state, v_postal_code, v_country, v_province
170: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps
171: WHERE hzcas.cust_account_id = v_customer_id
172: AND hzcas.party_site_id = hzps.party_site_id
173: AND hzps.location_id = hzl.location_id;
174: