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_CACHE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 957: ,hz_cust_acct_sites_all a -- changed to _all since we know site_use_id and to perform better.

953: ,G_SHIP_TO_TBL(p_key).freight_terms_code
954: ,G_SHIP_TO_TBL(p_key).demand_class_code
955: ,G_SHIP_TO_TBL(p_key).default_attributes
956: FROM hz_cust_site_uses_all s
957: ,hz_cust_acct_sites_all a -- changed to _all since we know site_use_id and to perform better.
958: ,oe_transaction_types_all o
959: ,oe_ship_methods_v sm
960: ,oe_ar_lookups_v fp
961: ,oe_lookups ft

Line 1002: FROM hz_cust_acct_sites_all a

998: ,b.location
999: INTO G_SHIP_TO_TBL(p_key).address_id
1000: ,G_SHIP_TO_TBL(p_key).edi_location_code
1001: ,G_SHIP_TO_TBL(p_key).location
1002: FROM hz_cust_acct_sites_all a
1003: , hz_cust_site_uses_all b
1004: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1005: AND b.site_use_id = p_key
1006: AND b.site_use_code='SHIP_TO';

Line 1101: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a

1097: BEGIN
1098:
1099: SELECT /* MOAC_SQL_CHANGE */ a.cust_acct_site_id
1100: INTO G_SOLD_TO_TBL(p_key).address_id
1101: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a
1102: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1103: AND a.cust_account_id = p_key
1104: /* AND NVL(a.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),
1105: 1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 1194: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a

1190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1191: --
1192: Cursor End_Customer_site(p_site_use_code VARCHAR,p_key NUMBER) IS
1193: SELECT a.cust_acct_site_id
1194: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a
1195: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1196: AND a.cust_account_id = p_key
1197: AND NVL(a.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
1198: NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

Line 1354: FROM hz_cust_acct_sites_all a

1350: Cursor End_customer_address(p_site_use_code varchar2,p_key number) IS
1351: SELECT b.cust_acct_site_id
1352: ,a.ece_tp_location_code
1353: ,b.location
1354: FROM hz_cust_acct_sites_all a
1355: , hz_cust_site_uses_all b
1356: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1357: AND b.site_use_id = p_key
1358: AND b.site_use_code=p_site_use_code;

Line 1631: FROM hz_cust_acct_sites_all a

1627: ,b.location
1628: INTO G_INVOICE_TO_TBL(p_key).address_id
1629: ,G_INVOICE_TO_TBL(p_key).edi_location_code
1630: ,G_INVOICE_TO_TBL(p_key).location
1631: FROM hz_cust_acct_sites_all a
1632: , hz_cust_site_uses_all b
1633: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1634: AND b.site_use_id = p_key
1635: AND b.site_use_code='BILL_TO';

Line 1779: FROM hz_cust_acct_sites_all a

1775: ,b.location
1776: INTO G_SOLD_TO_SITE_TBL(p_key).address_id
1777: ,G_SOLD_TO_SITE_TBL(p_key).edi_location_code
1778: ,G_SOLD_TO_SITE_TBL(p_key).location
1779: FROM hz_cust_acct_sites_all a
1780: , hz_cust_site_uses_all b
1781: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1782: AND b.site_use_id = p_key
1783: AND b.site_use_code='SOLD_TO';