APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 775: 'FROM hz_cust_site_uses_all hzcsua, '||

771: 'hzcsua.site_use_id, '||
772: 'hzcsua.bill_to_site_use_id, '||
773: 'hzcsua.site_use_code ' ;
774: l_party_select_sql := l_party_select_sql ||
775: 'FROM hz_cust_site_uses_all hzcsua, '||
776: 'hz_cust_acct_sites_all hzcasa, '||
777: 'hz_cust_accounts hzca, ';
778: l_party_select_sql := l_party_select_sql ||
779: 'hz_party_sites hzps, '||

Line 847: 'hz_cust_site_uses_all hzcsua, '||

843: 'hzcsua.bill_to_site_use_id, '||
844: 'hzcsua.site_use_code ' ;
845: l_party_select_sql := l_party_select_sql ||
846: 'FROM hz_cust_accounts hzca, '||
847: 'hz_cust_site_uses_all hzcsua, '||
848: 'hz_cust_acct_sites_all hzcasa ';
849: l_party_where_sql := ' WHERE ' ;
850: --R12
851: IF l_terr_limited_to_ou = 'Y'

Line 920: 'hz_cust_site_uses_all hzcsua, '||

916: 'hzcsua.bill_to_site_use_id, '||
917: 'hzcsua.site_use_code ';
918: l_party_select_sql := l_party_select_sql ||
919: 'FROM hz_cust_accounts hzca, '||
920: 'hz_cust_site_uses_all hzcsua, '||
921: 'hz_cust_acct_sites_all hzcasa, ';
922: l_party_select_sql := l_party_select_sql ||
923: 'hz_party_sites hzps ';
924: l_party_where_sql := ' WHERE ' ;

Line 976: 'FROM hz_cust_site_uses_all hzcsua, '||

972: 'hzcsua.site_use_id, '||
973: 'hzcsua.bill_to_site_use_id, '||
974: 'hzcsua.site_use_code ';
975: l_party_select_sql := l_party_select_sql ||
976: 'FROM hz_cust_site_uses_all hzcsua, '||
977: 'hz_cust_acct_sites_all hzcasa, '||
978: 'hz_cust_accounts hzca, ';
979: l_party_select_sql := l_party_select_sql ||
980: 'hz_relationships hzpr ';

Line 1043: 'hz_cust_site_uses_all hzcsua, ';

1039: 'hzcsua.bill_to_site_use_id, ';
1040: l_party_select_sql := l_party_select_sql ||
1041: 'hzcsua.site_use_code '||
1042: 'FROM hz_cust_accounts hzca, '||
1043: 'hz_cust_site_uses_all hzcsua, ';
1044: l_party_select_sql := l_party_select_sql ||
1045: 'hz_cust_acct_sites_all hzcasa, '||
1046: 'hz_customer_profiles hzcp ';
1047: l_party_where_sql := ' WHERE ' || l_hzcustprof_sql;

Line 1112: 'FROM hz_cust_site_uses_all hzcsua, '||

1108: 'hzcsua.site_use_id, '||
1109: 'hzcsua.bill_to_site_use_id, '||
1110: 'hzcsua.site_use_code ';
1111: l_party_select_sql := l_party_select_sql ||
1112: 'FROM hz_cust_site_uses_all hzcsua, '||
1113: 'hz_cust_acct_sites_all hzcasa, '||
1114: 'hz_cust_accounts hzca, ';
1115: l_party_select_sql := l_party_select_sql ||
1116: --R12: mkothari 'hz_relationships hzpr, '||

Line 1580: hz_cust_site_uses_all site_use

1576: UPDATE ams_party_market_segments a
1577: SET a.rollup_party_id = ( SELECT acct.party_id
1578: FROM hz_cust_accounts_all acct,
1579: hz_cust_acct_sites_all acct_site,
1580: hz_cust_site_uses_all site_use
1581: WHERE site_use.site_use_id = NVL(a.bill_to_site_use_id,a.site_use_id)
1582: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1583: AND acct_site.cust_account_id = acct.cust_account_id)
1584: WHERE a.market_qualifier_type = 'TERRITORY'