APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 782: 'FROM hz_cust_site_uses_all hzcsua, '||

778: 'hzcsua.site_use_id, '||
779: 'hzcsua.bill_to_site_use_id, '||
780: 'hzcsua.site_use_code ' ;
781: l_party_select_sql := l_party_select_sql ||
782: 'FROM hz_cust_site_uses_all hzcsua, '||
783: 'hz_cust_acct_sites_all hzcasa, '||
784: 'hz_cust_accounts hzca, ';
785: l_party_select_sql := l_party_select_sql ||
786: 'hz_party_sites hzps, '||

Line 854: 'hz_cust_site_uses_all hzcsua, '||

850: 'hzcsua.bill_to_site_use_id, '||
851: 'hzcsua.site_use_code ' ;
852: l_party_select_sql := l_party_select_sql ||
853: 'FROM hz_cust_accounts hzca, '||
854: 'hz_cust_site_uses_all hzcsua, '||
855: 'hz_cust_acct_sites_all hzcasa ';
856: l_party_where_sql := ' WHERE ' ;
857: --R12
858: IF l_terr_limited_to_ou = 'Y'

Line 927: 'hz_cust_site_uses_all hzcsua, '||

923: 'hzcsua.bill_to_site_use_id, '||
924: 'hzcsua.site_use_code ';
925: l_party_select_sql := l_party_select_sql ||
926: 'FROM hz_cust_accounts hzca, '||
927: 'hz_cust_site_uses_all hzcsua, '||
928: 'hz_cust_acct_sites_all hzcasa, ';
929: l_party_select_sql := l_party_select_sql ||
930: 'hz_party_sites hzps ';
931: l_party_where_sql := ' WHERE ' ;

Line 983: 'FROM hz_cust_site_uses_all hzcsua, '||

979: 'hzcsua.site_use_id, '||
980: 'hzcsua.bill_to_site_use_id, '||
981: 'hzcsua.site_use_code ';
982: l_party_select_sql := l_party_select_sql ||
983: 'FROM hz_cust_site_uses_all hzcsua, '||
984: 'hz_cust_acct_sites_all hzcasa, '||
985: 'hz_cust_accounts hzca, ';
986: l_party_select_sql := l_party_select_sql ||
987: 'hz_relationships hzpr ';

Line 1050: 'hz_cust_site_uses_all hzcsua, ';

1046: 'hzcsua.bill_to_site_use_id, ';
1047: l_party_select_sql := l_party_select_sql ||
1048: 'hzcsua.site_use_code '||
1049: 'FROM hz_cust_accounts hzca, '||
1050: 'hz_cust_site_uses_all hzcsua, ';
1051: l_party_select_sql := l_party_select_sql ||
1052: 'hz_cust_acct_sites_all hzcasa, '||
1053: 'hz_customer_profiles hzcp ';
1054: l_party_where_sql := ' WHERE ' || l_hzcustprof_sql;

Line 1119: 'FROM hz_cust_site_uses_all hzcsua, '||

1115: 'hzcsua.site_use_id, '||
1116: 'hzcsua.bill_to_site_use_id, '||
1117: 'hzcsua.site_use_code ';
1118: l_party_select_sql := l_party_select_sql ||
1119: 'FROM hz_cust_site_uses_all hzcsua, '||
1120: 'hz_cust_acct_sites_all hzcasa, '||
1121: 'hz_cust_accounts hzca, ';
1122: l_party_select_sql := l_party_select_sql ||
1123: --R12: mkothari 'hz_relationships hzpr, '||

Line 1593: hz_cust_site_uses_all site_use

1589: UPDATE ams_party_market_segments a
1590: SET a.rollup_party_id = ( SELECT acct.party_id
1591: FROM hz_cust_accounts_all acct,
1592: hz_cust_acct_sites_all acct_site,
1593: hz_cust_site_uses_all site_use
1594: WHERE site_use.site_use_id = NVL(a.bill_to_site_use_id,a.site_use_id)
1595: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1596: AND acct_site.cust_account_id = acct.cust_account_id)
1597: WHERE a.market_qualifier_type = 'TERRITORY'