eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCT_MERGE_DETAIL_OBJ_TBL

Line 366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS

362: HZ_ORIG_SYS_REF_OBJ_TBL())
363: FROM hz_cust_accounts_m fa
364: WHERE fa.cust_account_id = mh.duplicate_id
365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS

Line 367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS

363: FROM hz_cust_accounts_m fa
364: WHERE fa.cust_account_id = mh.duplicate_id
365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS

Line 368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS

364: WHERE fa.cust_account_id = mh.duplicate_id
365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS
372: )

Line 369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS

365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS
372: )
373: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp

Line 370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS

366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS
372: )
373: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp
374: WHERE mh.customer_merge_header_id = p_customer_merge_header_id

Line 371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS

367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS
372: )
373: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp
374: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
375: AND ta.cust_account_id = mh.customer_id