APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_ACCT_SITES

Line 886: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'

882: ATTRIBUTE20)
883: FROM HZ_ORIG_SYS_REFERENCES OSR
884: WHERE
885: OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
886: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
887: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm
888: CAST(MULTISET (
889: SELECT HZ_ORIG_SYS_REF_OBJ(
890: NULL, --P_ACTION_TYPE,

Line 935: FROM HZ_CUST_ACCT_SITES CAS

931: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
932: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
933: HZ_CUST_SITE_USE_BO_TBL(),
934: HZ_CUST_ACCT_CONTACT_BO_TBL())
935: FROM HZ_CUST_ACCT_SITES CAS
936: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
937: OR (P_CUST_ACCT_SITE_ID IS NOT NULL
938: AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));
939:

Line 1632: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'

1628: ATTRIBUTE20)
1629: FROM HZ_ORIG_SYS_REFERENCES OSR
1630: WHERE
1631: OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
1632: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
1633: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm
1634: CAST(MULTISET (
1635: SELECT HZ_ORIG_SYS_REF_OBJ(
1636: NULL, --P_ACTION_TYPE,

Line 1681: FROM HZ_CUST_ACCT_SITES CAS

1677: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
1678: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
1679: HZ_CUST_SITE_USE_V2_BO_TBL(),
1680: HZ_CUST_ACCT_CONTACT_BO_TBL())
1681: FROM HZ_CUST_ACCT_SITES CAS
1682: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
1683: OR (P_CUST_ACCT_SITE_ID IS NOT NULL
1684: AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));
1685: