APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |

45: --| HZ_ORG_CONTACTS | X | | | | | |
46: --+---------------------------------+---+---+---+---+---+----------------------+
47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |
48: --+---------------------------------+---+---+---+---+---+----------------------+
49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |
50: --+---------------------------------+---+---+---+---+---+----------------------+
51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |
52: --+---------------------------------+---+---+---+---+---+----------------------+
53: --| OKS_K_SALES_CREDITS_V | X | | | | | |

Line 1381: ,HZ_CUST_ACCT_SITES_ALL CA

1377: IS
1378: SELECT CS.SITE_USE_ID ID1
1379: FROM HZ_CUST_SITE_USES_all CS
1380: ,HZ_PARTY_SITES PS
1381: ,HZ_CUST_ACCT_SITES_ALL CA
1382: WHERE PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1383: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1384: And Ps.party_id = p_party_id
1385: And Ca.cust_account_id = p_customer_id

Line 1638: hz_cust_acct_sites_all b

1634: CURSOR l_site_csr
1635: IS
1636: SELECT 'Y'
1637: FROM hz_cust_site_uses_all a,
1638: hz_cust_acct_sites_all b
1639: WHERE a.site_use_id = p_site_use_id
1640: AND a.site_use_code = p_site_use_code
1641: AND a.cust_acct_site_id = b.cust_acct_site_id
1642: AND a.status = 'A'