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

Line 372: vc_address1 hz_locations.address1%TYPE;

368: vc_customer_name hz_parties.party_name%TYPE;
369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;

Line 373: vc_address2 hz_locations.address2%TYPE;

369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;

Line 374: vc_address3 hz_locations.address3%TYPE;

370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

Line 375: vc_city hz_locations.city%TYPE;

371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;

Line 376: vc_state hz_locations.state%TYPE;

372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

Line 377: vc_postal_code hz_locations.postal_code%TYPE;

373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
381: vc_trx_date ra_customer_trx.trx_date%TYPE;

Line 412: HZ_LOCATIONS HZL,

408: RA_CUSTOMER_TRX RCT,
409: RA_CUSTOMER_TRX_LINES RTL,
410: RA_CUST_TRX_LINE_GL_DIST RLD,
411: HZ_CUST_SITE_USES HZCSU,
412: HZ_LOCATIONS HZL,
413: HZ_CUST_ACCT_SITES HZCAS,
414: HZ_CUST_ACCOUNTS HZCA,
415: HZ_PARTY_SITES HZPS,
416: HZ_PARTIES HZP

Line 498: hz_locations hzl,

494: rct.bill_to_customer_id,
495: rct.trx_date,
496: rld.code_combination_id
497: FROM
498: hz_locations hzl,
499: hz_cust_acct_sites hzcas,
500: hz_party_sites hzps ,
501: HZ_CUST_SITE_USEs hzcsu,
502: hz_cust_accounts hzca,