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

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 5969: FROM as_accesses_all secu

5965: where P.status = 'A'
5966: AND P.party_id = p_cust_party_id
5967: AND p.party_type in ('PERSON','ORGANIZATION')
5968: AND (exists (SELECT null
5969: FROM as_accesses_all secu
5970: WHERE secu.customer_id = p.party_id
5971: AND secu.lead_id IS NULL
5972: AND secu.sales_lead_id IS NULL AND salesforce_id = p_resource_id
5973: )

Line 6445: FROM as_accesses_all secu

6441: from HZ_PARTIES P
6442: where P.status = 'A'
6443: AND P.party_id = p_cust_party_id
6444: AND EXISTS ( SELECT null
6445: FROM as_accesses_all secu
6446: WHERE secu.customer_id = P.party_id
6447: AND secu.sales_group_id in (
6448: SELECT jrgd.group_id
6449: FROM jtf_rs_groups_denorm jrgd,

Line 6470: FROM as_accesses_all secu

6466: AND secu.lead_id IS NULL
6467: AND secu.sales_lead_id IS NULL
6468: UNION ALL
6469: SELECT null
6470: FROM as_accesses_all secu
6471: WHERE secu.customer_id = p.party_id
6472: AND secu.lead_id IS NULL
6473: AND secu.sales_lead_id IS NULL
6474: AND salesforce_id = p_resource_id

Line 6489: FROM as_accesses_all secu

6485: from HZ_PARTIES P
6486: where P.status = 'A'
6487: AND P.party_id = p_cust_party_id
6488: AND (exists (SELECT null
6489: FROM as_accesses_all secu
6490: WHERE secu.customer_id = p.party_id
6491: AND secu.lead_id IS NULL
6492: AND secu.sales_lead_id IS NULL
6493: AND salesforce_id = p_resource_id

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 7017: FROM as_accesses_all secu

7013: AND hp.party_type in ('PERSON','ORGANIZATION')
7014: AND HP.party_id = p_cust_party_id
7015: AND CA.cust_account_id = p_cust_acct_id
7016: AND (exists (SELECT null
7017: FROM as_accesses_all secu
7018: WHERE secu.customer_id = hp.party_id
7019: AND secu.lead_id IS NULL
7020: AND secu.sales_lead_id IS NULL
7021: AND salesforce_id = p_resource_id

Line 7726: FROM as_accesses_all secu

7722: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7723: AND P.status = 'A'
7724: AND P.party_id = CA.party_id
7725: AND (exists (SELECT null
7726: FROM as_accesses_all secu
7727: WHERE secu.customer_id = p.party_id
7728: AND secu.lead_id IS NULL
7729: AND secu.sales_lead_id IS NULL AND salesforce_id = p_resource_id
7730: ))

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