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.ASO_VALIDATE_PVT dependencies on AS_ACCESSES_ALL_ALL

Line 5921: FROM as_accesses_all_all secu

5917: where P.status = 'A'
5918: AND p.party_type in ('PERSON','ORGANIZATION')
5919: AND P.party_id = p_cust_party_id
5920: AND EXISTS ( SELECT null
5921: FROM as_accesses_all_all secu
5922: WHERE secu.customer_id = P.party_id
5923: and secu.delete_flag is null
5924: and secu.sales_group_id in (
5925: SELECT jrgd.group_id

Line 5947: FROM as_accesses_all_all secu,

5943: AND secu.lead_id IS NULL
5944: AND secu.sales_lead_id IS NULL )
5945: UNION ALL
5946: SELECT null
5947: FROM as_accesses_all_all secu,
5948: HZ_PARTIES P
5949: WHERE secu.customer_id = P.party_id
5950: AND secu.lead_id IS NULL
5951: AND secu.sales_lead_id IS NULL

Line 6963: FROM as_accesses_all_all secu

6959: AND P.status = 'A'
6960: AND P.party_id = CA.party_id
6961: AND CA.CUST_ACCOUNT_ID = p_cust_acct_id
6962: AND EXISTS ( SELECT null
6963: FROM as_accesses_all_all secu
6964: WHERE secu.customer_id = P.party_id
6965: AND secu.lead_id IS NULL
6966: AND secu.sales_lead_id IS NULL
6967: AND secu.delete_flag is NULL

Line 6989: FROM as_accesses_all_all secu,

6985: AND jrgu.group_id = jrgd.group_id
6986: AND jrgu.usage in ('SALES', 'PRM')))
6987: UNION ALL
6988: SELECT null
6989: FROM as_accesses_all_all secu,
6990: HZ_PARTIES P
6991: WHERE secu.customer_id = P.party_id
6992: AND secu.lead_id IS NULL
6993: AND secu.sales_lead_id IS NULL

Line 7750: FROM as_accesses_all_all secu

7746: AND P.party_id = CA.party_id
7747: AND P.party_id = p_cust_party_id --Added joins for cust_acct_id and
7748: AND ca.cust_account_id = p_cust_acct_id --party id
7749: AND EXISTS ( SELECT null
7750: FROM as_accesses_all_all secu
7751: WHERE secu.customer_id = P.party_id
7752: AND secu.lead_id IS NULL
7753: AND secu.sales_lead_id IS NULL
7754: AND secu.delete_flag is NULL

Line 7775: FROM as_accesses_all_all secu,HZ_PARTIES P

7771: AND jrgu.group_id = jrgd.group_id
7772: AND jrgu.usage in ('SALES', 'PRM')) )
7773: UNION ALL
7774: SELECT null
7775: FROM as_accesses_all_all secu,HZ_PARTIES P
7776: WHERE secu.customer_id = P.party_id
7777: AND secu.lead_id IS NULL
7778: AND secu.sales_lead_id IS NULL
7779: AND secu.delete_flag is NULL