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_SF1080_TRANSACTION dependencies on HZ_LOCATIONS

Line 37: remit_address1 hz_locations.address1%TYPE;

33: g_error_message VARCHAR2(80);
34: --
35: --
36: -- ---------- Transactions Report Header Cursor Vaiables -----------
37: remit_address1 hz_locations.address1%TYPE;
38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;

Line 38: remit_address2 hz_locations.address2%TYPE;

34: --
35: --
36: -- ---------- Transactions Report Header Cursor Vaiables -----------
37: remit_address1 hz_locations.address1%TYPE;
38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;

Line 39: remit_address3 hz_locations.address3%TYPE;

35: --
36: -- ---------- Transactions Report Header Cursor Vaiables -----------
37: remit_address1 hz_locations.address1%TYPE;
38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;
43: remit_postal_code hz_locations.postal_code%TYPE;

Line 40: remit_address4 hz_locations.address4%TYPE;

36: -- ---------- Transactions Report Header Cursor Vaiables -----------
37: remit_address1 hz_locations.address1%TYPE;
38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;
43: remit_postal_code hz_locations.postal_code%TYPE;
44: line_count number;

Line 41: remit_city hz_locations.city%TYPE;

37: remit_address1 hz_locations.address1%TYPE;
38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;
43: remit_postal_code hz_locations.postal_code%TYPE;
44: line_count number;
45: line_counter number;

Line 42: remit_state hz_locations.state%TYPE;

38: remit_address2 hz_locations.address2%TYPE;
39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;
43: remit_postal_code hz_locations.postal_code%TYPE;
44: line_count number;
45: line_counter number;
46: line_count_flag number;

Line 43: remit_postal_code hz_locations.postal_code%TYPE;

39: remit_address3 hz_locations.address3%TYPE;
40: remit_address4 hz_locations.address4%TYPE;
41: remit_city hz_locations.city%TYPE;
42: remit_state hz_locations.state%TYPE;
43: remit_postal_code hz_locations.postal_code%TYPE;
44: line_count number;
45: line_counter number;
46: line_count_flag number;
47: segment varchar2(800);

Line 257: hz_locations hzl, hz_cust_acct_sites hzcas,

253: hzl.city cust_city,
254: hzl.state cust_state,
255: hzl.postal_code cust_postal_code
256: FROM RA_CUSTOMER_TRX rct,
257: hz_locations hzl, hz_cust_acct_sites hzcas,
258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp
259: WHERE rct.set_of_books_id = parm_set_of_books_id
260: AND rct.bill_to_customer_id = hzca.cust_account_id
261: AND hzca.cust_Account_id = hzcas.cust_account_id

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

356: BEGIN
357: SELECT ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,POSTAL_CODE
358: INTO REMIT_ADDRESS1,REMIT_ADDRESS2,REMIT_ADDRESS3,REMIT_ADDRESS4,
359: REMIT_CITY,REMIT_STATE,REMIT_POSTAL_CODE
360: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps
361: WHERE hzcas.cust_Acct_site_id =
362: TS_REPORT_HEADER_ENTRY.REMIT_TO_ADDRESS_ID
363: AND hzcas.party_site_id = hzps.party_site_id
364: AND hzps.location_id = hzl.location_id;