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.OKS_AUTH_UTIL_PVT dependencies on OKX_PARTIES_V

Line 73: FROM okx_parties_v

69:
70: CURSOR l_csr_cust_party (p_party_id IN NUMBER)
71: IS
72: SELECT id1, name
73: FROM okx_parties_v
74: WHERE id1 = p_party_id;
75:
76: CURSOR l_csr_rel_party (p_party_id IN NUMBER,
77: p_org_id IN NUMBER) IS

Line 79: FROM OKX_PARTIES_V P,

75:
76: CURSOR l_csr_rel_party (p_party_id IN NUMBER,
77: p_org_id IN NUMBER) IS
78: SELECT P.id1, P.name
79: FROM OKX_PARTIES_V P,
80: OKX_CUSTOMER_ACCOUNTS_V CA1
81: WHERE P.id1 = CA1.party_id
82: AND CA1.id1 IN(SELECT A.related_cust_account_id
83: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

Line 95: FROM okx_parties_v

91:
92: CURSOR l_csr_both_party(p_party_id IN NUMBER,
93: p_org_id IN NUMBER) IS
94: SELECT id1, name
95: FROM okx_parties_v
96: WHERE id1 = p_party_id
97: UNION
98: SELECT P.id1, p.name
99: FROM OKX_PARTIES_V P,

Line 99: FROM OKX_PARTIES_V P,

95: FROM okx_parties_v
96: WHERE id1 = p_party_id
97: UNION
98: SELECT P.id1, p.name
99: FROM OKX_PARTIES_V P,
100: OKX_CUSTOMER_ACCOUNTS_V CA1
101: WHERE P.id1 = CA1.party_id
102: AND CA1.id1 IN(SELECT A.related_cust_account_id
103: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

Line 113: l_party_id OKX_PARTIES_V.id1%TYPE;

109: AND A.org_id = p_org_id)
110: AND CA1.status = 'A';
111:
112: i NUMBER := 1;
113: l_party_id OKX_PARTIES_V.id1%TYPE;
114: l_party_name OKX_PARTIES_V.name%TYPE;
115: BEGIN
116: IF p_default = 'CUSTOMER' THEN
117:

Line 114: l_party_name OKX_PARTIES_V.name%TYPE;

110: AND CA1.status = 'A';
111:
112: i NUMBER := 1;
113: l_party_id OKX_PARTIES_V.id1%TYPE;
114: l_party_name OKX_PARTIES_V.name%TYPE;
115: BEGIN
116: IF p_default = 'CUSTOMER' THEN
117:
118: OPEN l_csr_cust_party(p_party_id

Line 2444: OKX_PARTIES_V parties

2440: CURSOR l_csr_get_customer(p_party_id IN NUMBER ) IS
2441: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2442: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2443: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2444: OKX_PARTIES_V parties
2445: WHERE cust_acc.party_id = p_party_id
2446: AND cust_acc.party_id = parties.id1
2447: AND cust_acc.status = 'A';
2448:

Line 2451: FROM OKX_PARTIES_V parties

2447: AND cust_acc.status = 'A';
2448:
2449: CURSOR l_csr_get_party_name(p_party_id IN NUMBER) IS
2450: SELECT parties.id1 party_id, parties.name party_name
2451: FROM OKX_PARTIES_V parties
2452: WHERE parties.id1 = p_party_id ;
2453:
2454: CURSOR l_csr_get_all_customers IS
2455: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,

Line 2458: OKX_PARTIES_V parties

2454: CURSOR l_csr_get_all_customers IS
2455: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2456: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2457: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2458: OKX_PARTIES_V parties
2459: WHERE cust_acc.party_id = parties.id1
2460: AND cust_acc.status = 'A';
2461:
2462: l_csr_cust_rec l_csr_get_customer%ROWTYPE;

Line 2466: l_party_id OKX_PARTIES_V.id1%TYPE;

2462: l_csr_cust_rec l_csr_get_customer%ROWTYPE;
2463: l_csr_party_rec l_csr_get_party_name%ROWTYPE;
2464:
2465: l_default VARCHAR2(15);
2466: l_party_id OKX_PARTIES_V.id1%TYPE;
2467: i NUMBER ;
2468: rowcount NUMBER := 1;
2469: l_org_id NUMBER ;
2470: l_customer_id NUMBER ;

Line 2475: l_party_selected OKX_PARTIES_V.ID1%TYPE;

2471: l_cust_id_tbl cust_id_tbl;
2472: l_party_id_tbl party_id_tbl;
2473:
2474: l_old_party_Id NUMBER := - 99;
2475: l_party_selected OKX_PARTIES_V.ID1%TYPE;
2476: BEGIN
2477: l_default := p_clvl_filter_rec.clvl_default;
2478: l_party_id := p_clvl_filter_rec.clvl_party_id;
2479: l_org_id := p_clvl_filter_rec.clvl_auth_org_id;

Line 2617: FROM OKX_PARTIES_V

2613: IS
2614:
2615: CURSOR l_csr_party_customer(p_party_id IN NUMBER ) IS
2616: SELECT id1, id2, Name, Description
2617: FROM OKX_PARTIES_V
2618: WHERE id1 = p_party_id
2619: AND status = 'A';
2620:
2621: CURSOR l_csr_party_related(p_party_id IN NUMBER,

Line 2624: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

2620:
2621: CURSOR l_csr_party_related(p_party_id IN NUMBER,
2622: p_org_id IN NUMBER) IS
2623: SELECT P1.id1, P1.id2, P1.name, P1.description
2624: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
2625: WHERE P1.id1 = CA1.party_id
2626: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
2627: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2628: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

Line 2640: FROM OKX_PARTIES_V

2636:
2637: CURSOR l_csr_party_both(p_party_id IN NUMBER,
2638: p_org_id IN NUMBER ) IS
2639: SELECT id1, id2, Name, Description
2640: FROM OKX_PARTIES_V
2641: WHERE id1 = p_party_id
2642: AND status = 'A'
2643: UNION
2644: SELECT P1.id1, P1.id2, P1.name, P1.description

Line 2645: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

2641: WHERE id1 = p_party_id
2642: AND status = 'A'
2643: UNION
2644: SELECT P1.id1, P1.id2, P1.name, P1.description
2645: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
2646: WHERE P1.id1 = CA1.party_id
2647: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
2648: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2649: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

Line 2660: FROM OKX_PARTIES_V

2656: AND CA1.status = 'A';
2657:
2658: CURSOR l_csr_party_all IS
2659: SELECT id1, id2, Name, Description
2660: FROM OKX_PARTIES_V
2661: WHERE status = 'A';
2662:
2663: l_csr_party_rec l_csr_party_customer%ROWTYPE;
2664:

Line 2666: l_party_id OKX_PARTIES_V.id1%TYPE;

2662:
2663: l_csr_party_rec l_csr_party_customer%ROWTYPE;
2664:
2665: l_default VARCHAR2(15);
2666: l_party_id OKX_PARTIES_V.id1%TYPE;
2667: i NUMBER ;
2668: rowcount NUMBER := 1;
2669: l_org_id NUMBER ;
2670: l_party_selected NUMBER;

Line 2770: FROM OKX_PARTIES_V parties,

2766: CURSOR l_csr_get_site(p_party_id IN NUMBER ) IS
2767: SELECT DISTINCT parties.name party_name, parties.id1 party_id,
2768: party_site.id1 id1, party_site.party_site_number, party_site.id2,
2769: party_site.name party_site_name, party_site.description
2770: FROM OKX_PARTIES_V parties,
2771: OKX_PARTY_SITES_V party_site
2772: WHERE parties.id1 = p_party_id
2773: AND party_site.party_id = parties.id1
2774: AND party_site.status = 'A'

Line 2781: FROM OKX_PARTIES_V parties,

2777: CURSOR l_csr_get_all_sites IS
2778: SELECT DISTINCT parties.name party_name, parties.id1 party_id,
2779: party_site.id1 id1, party_site.party_site_number, party_site.id2,
2780: party_site.name party_site_name, party_site.description
2781: FROM OKX_PARTIES_V parties,
2782: OKX_PARTY_SITES_V party_site
2783: WHERE party_site.party_id = parties.id1
2784: AND party_site.status = 'A'
2785: ORDER BY parties.name ;

Line 2792: l_party_id OKX_PARTIES_V.id1%TYPE;

2788: -- l_csr_cust_rec l_csr_get_site%ROWTYPE;
2789: -- Bug 4915711--
2790:
2791: l_default VARCHAR2(15);
2792: l_party_id OKX_PARTIES_V.id1%TYPE;
2793: l_old_party_id NUMBER := - 99;
2794: i NUMBER ;
2795: rowcount NUMBER := 1;
2796: l_org_id NUMBER ;

Line 2805: party_name OKX_PARTIES_V.NAME%TYPE,

2801: l_old_customer_id NUMBER := - 99 ;
2802: l_customer_id NUMBER ;
2803: -- BUG 4915711 --
2804: TYPE get_all_sites_rec IS RECORD (
2805: party_name OKX_PARTIES_V.NAME%TYPE,
2806: party_Id1 OKX_PARTIES_V.ID1%TYPE,
2807: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,
2808: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,
2809: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,

Line 2806: party_Id1 OKX_PARTIES_V.ID1%TYPE,

2802: l_customer_id NUMBER ;
2803: -- BUG 4915711 --
2804: TYPE get_all_sites_rec IS RECORD (
2805: party_name OKX_PARTIES_V.NAME%TYPE,
2806: party_Id1 OKX_PARTIES_V.ID1%TYPE,
2807: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,
2808: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,
2809: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,
2810: party_sites_name OKX_PARTY_SITES_V.NAME%TYPE,

Line 3033: OKX_PARTIES_V parties,

3029: SELECT parties.id1, parties.name, CSB.system_id, parties.id2 id2,
3030: CST.name system_name, CST.description, CSB.system_number
3031: FROM CSI_SYSTEMS_B CSB,
3032: CSI_SYSTEMS_TL CST,
3033: OKX_PARTIES_V parties,
3034: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3035: WHERE parties.id1 = p_party_id
3036: AND cust_acc.party_id = parties.id1
3037: AND CSB.system_id = CST.system_id

Line 3049: OKX_PARTIES_V parties,

3045: CST.name system_name, CST.description,
3046: CSB.system_number
3047: FROM CSI_SYSTEMS_B CSB,
3048: CSI_SYSTEMS_TL CST,
3049: OKX_PARTIES_V parties,
3050: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3051: WHERE cust_acc.party_id = parties.id1
3052: AND CSB.system_id = CST.system_id
3053: AND CSB.customer_id = cust_acc.id1