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 510: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)

506: TYPE Entity_info_rec_tbl
507: IS
508: TABLE OF Entity_info INDEX BY binary_integer;
509: Entity_info_tbl Entity_info_rec_tbl;
510: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)
511: IS
512: SELECT
513: /* MOAC_SQL_CHANGE */
514: s_ship.site_use_id,

Line 523: FROM HZ_CUST_SITE_USES S_SHIP ,

519: cust_acct.account_number,
520: party.party_id,
521: party_site_ship.party_site_id,
522: loc_ship.location_id
523: FROM HZ_CUST_SITE_USES S_SHIP ,
524: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
525: HZ_PARTY_SITES PARTY_SITE_SHIP,
526: HZ_LOCATIONS LOC_SHIP,
527: HZ_PARTIES PARTY,