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.

[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on AS_ACCESSES_ALL_ALL

Line 5937: FROM as_accesses_all_all secu

5933: where P.status = 'A'
5934: AND p.party_type in ('PERSON','ORGANIZATION')
5935: AND P.party_id = p_cust_party_id
5936: AND EXISTS ( SELECT null
5937: FROM as_accesses_all_all secu
5938: WHERE secu.customer_id = P.party_id
5939: and secu.delete_flag is null
5940: and secu.sales_group_id in (
5941: SELECT jrgd.group_id

Line 5963: FROM as_accesses_all_all secu,

5959: AND secu.lead_id IS NULL
5960: AND secu.sales_lead_id IS NULL )
5961: UNION ALL
5962: SELECT null
5963: FROM as_accesses_all_all secu,
5964: HZ_PARTIES P
5965: WHERE secu.customer_id = P.party_id
5966: AND secu.lead_id IS NULL
5967: AND secu.sales_lead_id IS NULL

Line 6979: FROM as_accesses_all_all secu

6975: AND P.status = 'A'
6976: AND P.party_id = CA.party_id
6977: AND CA.CUST_ACCOUNT_ID = p_cust_acct_id
6978: AND EXISTS ( SELECT null
6979: FROM as_accesses_all_all secu
6980: WHERE secu.customer_id = P.party_id
6981: AND secu.lead_id IS NULL
6982: AND secu.sales_lead_id IS NULL
6983: AND secu.delete_flag is NULL

Line 7005: FROM as_accesses_all_all secu,

7001: AND jrgu.group_id = jrgd.group_id
7002: AND jrgu.usage in ('SALES', 'PRM')))
7003: UNION ALL
7004: SELECT null
7005: FROM as_accesses_all_all secu,
7006: HZ_PARTIES P
7007: WHERE secu.customer_id = P.party_id
7008: AND secu.lead_id IS NULL
7009: AND secu.sales_lead_id IS NULL

Line 7766: FROM as_accesses_all_all secu

7762: AND P.party_id = CA.party_id
7763: AND P.party_id = p_cust_party_id --Added joins for cust_acct_id and
7764: AND ca.cust_account_id = p_cust_acct_id --party id
7765: AND EXISTS ( SELECT null
7766: FROM as_accesses_all_all secu
7767: WHERE secu.customer_id = P.party_id
7768: AND secu.lead_id IS NULL
7769: AND secu.sales_lead_id IS NULL
7770: AND secu.delete_flag is NULL

Line 7791: FROM as_accesses_all_all secu,HZ_PARTIES P

7787: AND jrgu.group_id = jrgd.group_id
7788: AND jrgu.usage in ('SALES', 'PRM')) )
7789: UNION ALL
7790: SELECT null
7791: FROM as_accesses_all_all secu,HZ_PARTIES P
7792: WHERE secu.customer_id = P.party_id
7793: AND secu.lead_id IS NULL
7794: AND secu.sales_lead_id IS NULL
7795: AND secu.delete_flag is NULL