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 2984: OKX_PARTIES_V parties

2980: CURSOR l_csr_get_customer(p_party_id IN NUMBER ) IS
2981: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2982: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2983: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2984: OKX_PARTIES_V parties
2985: WHERE cust_acc.party_id = p_party_id
2986: AND cust_acc.party_id = parties.id1
2987: AND cust_acc.status = 'A';
2988:

Line 2991: FROM OKX_PARTIES_V parties

2987: AND cust_acc.status = 'A';
2988:
2989: CURSOR l_csr_get_party_name(p_party_id IN NUMBER) IS
2990: SELECT parties.id1 party_id, parties.name party_name
2991: FROM OKX_PARTIES_V parties
2992: WHERE parties.id1 = p_party_id ;
2993:
2994: CURSOR l_csr_get_all_customers IS
2995: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,

Line 2998: OKX_PARTIES_V parties

2994: CURSOR l_csr_get_all_customers IS
2995: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2996: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2997: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2998: OKX_PARTIES_V parties
2999: WHERE cust_acc.party_id = parties.id1
3000: AND cust_acc.status = 'A';
3001:
3002: l_csr_cust_rec l_csr_get_customer%ROWTYPE;

Line 3006: l_party_id OKX_PARTIES_V.id1%TYPE;

3002: l_csr_cust_rec l_csr_get_customer%ROWTYPE;
3003: l_csr_party_rec l_csr_get_party_name%ROWTYPE;
3004:
3005: l_default VARCHAR2(15);
3006: l_party_id OKX_PARTIES_V.id1%TYPE;
3007: i NUMBER ;
3008: rowcount NUMBER := 1;
3009: l_org_id NUMBER ;
3010: l_customer_id NUMBER ;

Line 3015: l_party_selected OKX_PARTIES_V.ID1%TYPE;

3011: l_cust_id_tbl cust_id_tbl;
3012: l_party_id_tbl party_id_tbl;
3013:
3014: l_old_party_Id NUMBER := - 99;
3015: l_party_selected OKX_PARTIES_V.ID1%TYPE;
3016: BEGIN
3017: l_default := p_clvl_filter_rec.clvl_default;
3018: l_party_id := p_clvl_filter_rec.clvl_party_id;
3019: l_org_id := p_clvl_filter_rec.clvl_auth_org_id;

Line 3157: FROM OKX_PARTIES_V

3153: IS
3154:
3155: CURSOR l_csr_party_customer(p_party_id IN NUMBER ) IS
3156: SELECT id1, id2, Name, Description
3157: FROM OKX_PARTIES_V
3158: WHERE id1 = p_party_id
3159: AND status = 'A';
3160:
3161: CURSOR l_csr_party_related(p_party_id IN NUMBER,

Line 3164: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

3160:
3161: CURSOR l_csr_party_related(p_party_id IN NUMBER,
3162: p_org_id IN NUMBER) IS
3163: SELECT P1.id1, P1.id2, P1.name, P1.description
3164: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
3165: WHERE P1.id1 = CA1.party_id
3166: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
3167: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
3168: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

Line 3180: FROM OKX_PARTIES_V

3176:
3177: CURSOR l_csr_party_both(p_party_id IN NUMBER,
3178: p_org_id IN NUMBER ) IS
3179: SELECT id1, id2, Name, Description
3180: FROM OKX_PARTIES_V
3181: WHERE id1 = p_party_id
3182: AND status = 'A'
3183: UNION
3184: SELECT P1.id1, P1.id2, P1.name, P1.description

Line 3185: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

3181: WHERE id1 = p_party_id
3182: AND status = 'A'
3183: UNION
3184: SELECT P1.id1, P1.id2, P1.name, P1.description
3185: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
3186: WHERE P1.id1 = CA1.party_id
3187: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
3188: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
3189: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

Line 3200: FROM OKX_PARTIES_V

3196: AND CA1.status = 'A';
3197:
3198: CURSOR l_csr_party_all IS
3199: SELECT id1, id2, Name, Description
3200: FROM OKX_PARTIES_V
3201: WHERE status = 'A';
3202:
3203: l_csr_party_rec l_csr_party_customer%ROWTYPE;
3204:

Line 3206: l_party_id OKX_PARTIES_V.id1%TYPE;

3202:
3203: l_csr_party_rec l_csr_party_customer%ROWTYPE;
3204:
3205: l_default VARCHAR2(15);
3206: l_party_id OKX_PARTIES_V.id1%TYPE;
3207: i NUMBER ;
3208: rowcount NUMBER := 1;
3209: l_org_id NUMBER ;
3210: l_party_selected NUMBER;

Line 3310: FROM OKX_PARTIES_V parties,

3306: CURSOR l_csr_get_site(p_party_id IN NUMBER ) IS
3307: SELECT DISTINCT parties.name party_name, parties.id1 party_id,
3308: party_site.id1 id1, party_site.party_site_number, party_site.id2,
3309: party_site.name party_site_name, party_site.description
3310: FROM OKX_PARTIES_V parties,
3311: OKX_PARTY_SITES_V party_site
3312: WHERE parties.id1 = p_party_id
3313: AND party_site.party_id = parties.id1
3314: AND party_site.status = 'A'

Line 3321: FROM OKX_PARTIES_V parties,

3317: CURSOR l_csr_get_all_sites IS
3318: SELECT DISTINCT parties.name party_name, parties.id1 party_id,
3319: party_site.id1 id1, party_site.party_site_number, party_site.id2,
3320: party_site.name party_site_name, party_site.description
3321: FROM OKX_PARTIES_V parties,
3322: OKX_PARTY_SITES_V party_site
3323: WHERE party_site.party_id = parties.id1
3324: AND party_site.status = 'A'
3325: ORDER BY parties.name ;

Line 3332: l_party_id OKX_PARTIES_V.id1%TYPE;

3328: -- l_csr_cust_rec l_csr_get_site%ROWTYPE;
3329: -- Bug 4915711--
3330:
3331: l_default VARCHAR2(15);
3332: l_party_id OKX_PARTIES_V.id1%TYPE;
3333: l_old_party_id NUMBER := - 99;
3334: i NUMBER ;
3335: rowcount NUMBER := 1;
3336: l_org_id NUMBER ;

Line 3345: party_name OKX_PARTIES_V.NAME%TYPE,

3341: l_old_customer_id NUMBER := - 99 ;
3342: l_customer_id NUMBER ;
3343: -- BUG 4915711 --
3344: TYPE get_all_sites_rec IS RECORD (
3345: party_name OKX_PARTIES_V.NAME%TYPE,
3346: party_Id1 OKX_PARTIES_V.ID1%TYPE,
3347: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,
3348: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,
3349: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,

Line 3346: party_Id1 OKX_PARTIES_V.ID1%TYPE,

3342: l_customer_id NUMBER ;
3343: -- BUG 4915711 --
3344: TYPE get_all_sites_rec IS RECORD (
3345: party_name OKX_PARTIES_V.NAME%TYPE,
3346: party_Id1 OKX_PARTIES_V.ID1%TYPE,
3347: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,
3348: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,
3349: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,
3350: party_sites_name OKX_PARTY_SITES_V.NAME%TYPE,

Line 3573: OKX_PARTIES_V parties,

3569: SELECT parties.id1, parties.name, CSB.system_id, parties.id2 id2,
3570: CST.name system_name, CST.description, CSB.system_number
3571: FROM CSI_SYSTEMS_B CSB,
3572: CSI_SYSTEMS_TL CST,
3573: OKX_PARTIES_V parties,
3574: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3575: WHERE parties.id1 = p_party_id
3576: AND cust_acc.party_id = parties.id1
3577: AND CSB.system_id = CST.system_id

Line 3589: OKX_PARTIES_V parties,

3585: CST.name system_name, CST.description,
3586: CSB.system_number
3587: FROM CSI_SYSTEMS_B CSB,
3588: CSI_SYSTEMS_TL CST,
3589: OKX_PARTIES_V parties,
3590: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3591: WHERE cust_acc.party_id = parties.id1
3592: AND CSB.system_id = CST.system_id
3593: AND CSB.customer_id = cust_acc.id1