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.

[Home] [Help]

APPS.OE_BULK_CACHE dependencies on HZ_CUST_ACCT_SITES_ALL

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

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

Line 1003: FROM hz_cust_acct_sites_all a

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

Line 1102: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a

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

Line 1195: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a

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

Line 1355: FROM hz_cust_acct_sites_all a

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

Line 1632: FROM hz_cust_acct_sites_all a

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

Line 1780: FROM hz_cust_acct_sites_all a

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