APPS.CSTPMRGL dependencies on HZ_CUST_SITE_USES_ALL

Line 1432: FROM hz_cust_site_uses_all hcsua

1428:
1429: UPDATE CST_MARGIN_SUMMARY temp
1430: SET territory_id =
1431: (SELECT territory_id
1432: FROM hz_cust_site_uses_all hcsua
1433: WHERE NVL(hcsua.org_id, -999) = NVL(l_ou_id, NVL(hcsua.org_id, -999))
1434: AND hcsua.site_use_id = temp.ship_to_site_use_id )
1435: WHERE
1436: ship_to_site_use_id is not null

Line 1489: hz_cust_site_uses_all hcsua,

1485: UPDATE CST_MARGIN_SUMMARY temp
1486: SET bill_to_customer_name =
1487: (SELECT SUBSTRB(hp.party_name,1,50)
1488: FROM hz_cust_accounts hca,
1489: hz_cust_site_uses_all hcsua,
1490: hz_cust_acct_sites_all hcasa,
1491: hz_parties hp
1492: WHERE
1493: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))

Line 1515: hz_cust_site_uses_all hcsua,

1511: UPDATE CST_MARGIN_SUMMARY temp
1512: SET ship_to_customer_name =
1513: (SELECT SUBSTRB(hp.party_name,1,50)
1514: FROM hz_cust_accounts hca,
1515: hz_cust_site_uses_all hcsua,
1516: hz_cust_acct_sites_all hcasa,
1517: hz_parties hp
1518: WHERE
1519: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))