DBA Data[Home] [Help]

APPS.CSTPMRGL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1676: hz_cust_acct_sites_all hcasa,

1672: SET bill_to_customer_name =
1673: (SELECT SUBSTRB(hp.party_name,1,50)
1674: FROM hz_cust_accounts hca,
1675: hz_cust_site_uses_all hcsua,
1676: hz_cust_acct_sites_all hcasa,
1677: hz_parties hp
1678: WHERE
1679: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1680: and hca.cust_account_id = hcasa.cust_account_id

Line 1702: hz_cust_acct_sites_all hcasa,

1698: SET ship_to_customer_name =
1699: (SELECT SUBSTRB(hp.party_name,1,50)
1700: FROM hz_cust_accounts hca,
1701: hz_cust_site_uses_all hcsua,
1702: hz_cust_acct_sites_all hcasa,
1703: hz_parties hp
1704: WHERE
1705: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1706: and hca.cust_account_id = hcasa.cust_account_id