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.OE_BULK_TAX_UTIL dependencies on HZ_CUST_SITE_USES

Line 470: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;

466: l_ship_location_id NUMBER(15);
467: l_bill_party_id NUMBER(15);
468: l_bill_party_site_id NUMBER(15);
469: l_bill_location_id NUMBER(15);
470: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
471: l_ship_to_address_id NUMBER ;
472: l_ship_to_customer_id NUMBER ;
473: l_ship_to_postal_code VARCHAR2(60);
474: l_ship_to_customer_name VARCHAR2(360);

Line 497: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

493: from hr_organization_units
494: where organization_id = p_organization_id;
495:
496:
497: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
498: SELECT /* MOAC_SQL_CHANGE */ s_ship.site_use_id,
499: s_ship.cust_acct_site_id,
500: acct_site_ship.cust_account_id,
501: loc_ship.postal_code,

Line 508: HZ_CUST_SITE_USES S_SHIP ,

504: party.party_id,
505: party_site_ship.party_site_id,
506: loc_ship.location_id
507: FROM
508: HZ_CUST_SITE_USES S_SHIP ,
509: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
510: HZ_PARTY_SITES PARTY_SITE_SHIP,
511: HZ_LOCATIONS LOC_SHIP,
512: HZ_PARTIES PARTY,