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

Line 916: ,hz_cust_acct_sites a

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
920: AND s.status = 'A'

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 1343: ,hz_cust_acct_sites a

1339: Cursor End_customer_site_use (p_site_use_code varchar2) IS
1340: SELECT s.site_use_id
1341: ,a.cust_account_id
1342: from hz_cust_site_uses s
1343: ,hz_cust_acct_sites a
1344: WHERE s.site_use_id = p_key
1345: AND s.site_use_code =p_site_use_code
1346: AND s.cust_acct_site_id = a.cust_acct_site_id
1347: AND s.status = 'A'

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 1580: ,hz_cust_acct_sites a

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
1584: AND s.status = 'A'

Line 1602: ,hz_cust_acct_sites a

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
1606: WHERE s.site_use_id = p_key

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 1728: ,hz_cust_acct_sites a

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
1732: AND s.status = 'A'

Line 1750: ,hz_cust_acct_sites a

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
1754: WHERE s.site_use_id = p_key

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

Line 2150: HZ_CUST_ACCT_SITES ACCT_SITE,

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,
2154: HZ_PARTIES PARTY,