APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 783: 'hz_cust_acct_sites_all hzcasa, '||

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, '||
787: 'hz_locations hzloc, '||

Line 855: 'hz_cust_acct_sites_all hzcasa ';

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'
859: THEN

Line 928: 'hz_cust_acct_sites_all hzcasa, ';

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 ' ;
932: --R12

Line 984: 'hz_cust_acct_sites_all hzcasa, '||

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 ';
988: l_party_where_sql := 'WHERE ' ;

Line 1052: 'hz_cust_acct_sites_all hzcasa, '||

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;
1055: --R12
1056: IF l_terr_limited_to_ou = 'Y'

Line 1120: 'hz_cust_acct_sites_all hzcasa, '||

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, '||
1124: 'hz_party_sites hzps, '||

Line 1592: hz_cust_acct_sites_all acct_site,

1588: END IF;
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)