APPS.OE_BULK_CACHE dependencies on HZ_CUST_SITE_USES_ALL

Line 916: FROM hz_cust_site_uses_all s

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

Line 957: FROM hz_cust_site_uses_all s

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

Line 1004: , hz_cust_site_uses_all b

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

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

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

Line 1580: FROM hz_cust_site_uses_all s

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

Line 1602: FROM hz_cust_site_uses_all s

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

Line 1633: , hz_cust_site_uses_all b

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

Line 1728: FROM hz_cust_site_uses_all s

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

Line 1750: FROM hz_cust_site_uses_all s

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

Line 1781: , hz_cust_site_uses_all b

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

Line 2150: HZ_CUST_SITE_USES_ALL SU ,

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