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

5981: where P.status = 'A'
5982: AND P.party_id = p_cust_party_id
5983: AND p.party_type in ('PERSON','ORGANIZATION')
5984: AND (exists (SELECT null
5985: FROM as_accesses_all secu
5986: WHERE secu.customer_id = p.party_id
5987: AND secu.lead_id IS NULL
5988: AND secu.sales_lead_id IS NULL AND salesforce_id = p_resource_id
5989: )

Line 6461: FROM as_accesses_all secu

6457: from HZ_PARTIES P
6458: where P.status = 'A'
6459: AND P.party_id = p_cust_party_id
6460: AND EXISTS ( SELECT null
6461: FROM as_accesses_all secu
6462: WHERE secu.customer_id = P.party_id
6463: AND secu.sales_group_id in (
6464: SELECT jrgd.group_id
6465: FROM jtf_rs_groups_denorm jrgd,

Line 6486: FROM as_accesses_all secu

6482: AND secu.lead_id IS NULL
6483: AND secu.sales_lead_id IS NULL
6484: UNION ALL
6485: SELECT null
6486: FROM as_accesses_all secu
6487: WHERE secu.customer_id = p.party_id
6488: AND secu.lead_id IS NULL
6489: AND secu.sales_lead_id IS NULL
6490: AND salesforce_id = p_resource_id

Line 6505: FROM as_accesses_all secu

6501: from HZ_PARTIES P
6502: where P.status = 'A'
6503: AND P.party_id = p_cust_party_id
6504: AND (exists (SELECT null
6505: FROM as_accesses_all secu
6506: WHERE secu.customer_id = p.party_id
6507: AND secu.lead_id IS NULL
6508: AND secu.sales_lead_id IS NULL
6509: AND salesforce_id = p_resource_id

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

7029: AND hp.party_type in ('PERSON','ORGANIZATION')
7030: AND HP.party_id = p_cust_party_id
7031: AND CA.cust_account_id = p_cust_acct_id
7032: AND (exists (SELECT null
7033: FROM as_accesses_all secu
7034: WHERE secu.customer_id = hp.party_id
7035: AND secu.lead_id IS NULL
7036: AND secu.sales_lead_id IS NULL
7037: AND salesforce_id = p_resource_id

Line 7742: FROM as_accesses_all secu

7738: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7739: AND P.status = 'A'
7740: AND P.party_id = CA.party_id
7741: AND (exists (SELECT null
7742: FROM as_accesses_all secu
7743: WHERE secu.customer_id = p.party_id
7744: AND secu.lead_id IS NULL
7745: AND secu.sales_lead_id IS NULL AND salesforce_id = p_resource_id
7746: ))

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