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_SITE_USES_ALL

Line 915: FROM hz_cust_site_uses_all s

911: SELECT /* MOAC_SQL_CHANGE */ s.site_use_id
912: ,a.cust_account_id
913: INTO G_SHIP_TO_TBL(p_key).ship_to_org_id
914: ,G_SHIP_TO_TBL(p_key).customer_id
915: FROM hz_cust_site_uses_all s
916: ,hz_cust_acct_sites a
917: WHERE s.site_use_id = p_key
918: AND s.site_use_code = 'SHIP_TO'
919: AND s.cust_acct_site_id = a.cust_acct_site_id

Line 956: FROM hz_cust_site_uses_all s

952: ,G_SHIP_TO_TBL(p_key).fob_point_code
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

Line 1003: , hz_cust_site_uses_all b

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';
1007:

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 1355: , hz_cust_site_uses_all b

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;
1359: BEGIN

Line 1579: FROM hz_cust_site_uses_all s

1575: SELECT /* MOAC_SQL_CHANGE */ s.site_use_id
1576: ,a.cust_account_id
1577: INTO G_INVOICE_TO_TBL(p_key).invoice_to_org_id
1578: ,G_INVOICE_TO_TBL(p_key).customer_id
1579: FROM hz_cust_site_uses_all s
1580: ,hz_cust_acct_sites a
1581: WHERE s.site_use_id = p_key
1582: AND s.site_use_code = 'BILL_TO'
1583: AND s.cust_acct_site_id = a.cust_acct_site_id

Line 1601: FROM hz_cust_site_uses_all s

1597: ,G_INVOICE_TO_TBL(p_key).order_type_id
1598: ,G_INVOICE_TO_TBL(p_key).payment_term_id
1599: ,G_INVOICE_TO_TBL(p_key).price_list_id
1600: ,G_INVOICE_TO_TBL(p_key).default_attributes
1601: FROM hz_cust_site_uses_all s
1602: ,hz_cust_acct_sites a
1603: ,oe_transaction_types_all o
1604: ,ra_terms_b term
1605: ,qp_list_headers_b pl

Line 1632: , hz_cust_site_uses_all b

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';
1636:

Line 1727: FROM hz_cust_site_uses_all s

1723: SELECT /* MOAC_SQL_CHANGE */ s.site_use_id
1724: ,a.cust_account_id
1725: INTO G_SOLD_TO_SITE_TBL(p_key).sold_to_site_use_id
1726: ,G_SOLD_TO_SITE_TBL(p_key).customer_id
1727: FROM hz_cust_site_uses_all s
1728: ,hz_cust_acct_sites a
1729: WHERE s.site_use_id = p_key
1730: AND s.site_use_code = 'SOLD_TO'
1731: AND s.cust_acct_site_id = a.cust_acct_site_id

Line 1749: FROM hz_cust_site_uses_all s

1745: ,G_SOLD_TO_SITE_TBL(p_key).order_type_id
1746: ,G_SOLD_TO_SITE_TBL(p_key).payment_term_id
1747: ,G_SOLD_TO_SITE_TBL(p_key).price_list_id
1748: ,G_SOLD_TO_SITE_TBL(p_key).default_attributes
1749: FROM hz_cust_site_uses_all s
1750: ,hz_cust_acct_sites a
1751: ,oe_transaction_types_all o
1752: ,ra_terms_b term
1753: ,qp_list_headers_b pl

Line 1780: , hz_cust_site_uses_all b

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';
1784:

Line 2149: HZ_CUST_SITE_USES_ALL SU ,

2145: G_LOC_INFO_TBL(p_key).state,
2146: G_LOC_INFO_TBL(p_key).tax_header_level_flag,
2147: G_LOC_INFO_TBL(p_key).tax_rounding_rule
2148: FROM
2149: HZ_CUST_SITE_USES_ALL SU ,
2150: HZ_CUST_ACCT_SITES ACCT_SITE,
2151: HZ_PARTY_SITES PARTY_SITE,
2152: HZ_LOCATIONS LOC,
2153: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,