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 1377: ,HZ_CUST_ACCT_SITES_ALL CA

1373: IS
1374: SELECT CS.SITE_USE_ID ID1
1375: FROM HZ_CUST_SITE_USES_all CS
1376: ,HZ_PARTY_SITES PS
1377: ,HZ_CUST_ACCT_SITES_ALL CA
1378: WHERE PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1379: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1380: And Ps.party_id = p_party_id
1381: And Ca.cust_account_id = p_customer_id

Line 1634: hz_cust_acct_sites_all b

1630: CURSOR l_site_csr
1631: IS
1632: SELECT 'Y'
1633: FROM hz_cust_site_uses_all a,
1634: hz_cust_acct_sites_all b
1635: WHERE a.site_use_id = p_site_use_id
1636: AND a.site_use_code = p_site_use_code
1637: AND a.cust_acct_site_id = b.cust_acct_site_id
1638: AND a.status = 'A'