APPS.OKS_AUTH_UTIL_PVT dependencies on CSI_SYSTEMS_B

Line 1860: TYPE get_all_systems_rec IS RECORD (id1 CSI_SYSTEMS_B.system_id%TYPE,

1856: l_get_all_systems_sql VARCHAR2(2000);
1857: TYPE var_cur_type IS REF CURSOR;
1858: l_csr_get_all_systems var_cur_type;
1859:
1860: TYPE get_all_systems_rec IS RECORD (id1 CSI_SYSTEMS_B.system_id%TYPE,
1861: NAME CSI_SYSTEMS_TL.name%TYPE,
1862: Description CSI_SYSTEMS_TL.description%TYPE);
1863:
1864: l_get_all_systems_rec get_all_systems_rec;

Line 2173: || ' FROM CSI_SYSTEMS_B CSB, '

2169:
2170:
2171: -- Bug 5041892 --
2172: l_get_all_systems_sql_c := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
2173: || ' FROM CSI_SYSTEMS_B CSB, '
2174: || ' CSI_SYSTEMS_TL CST '
2175: || ' WHERE CSB.system_id = CST.system_id '
2176: || ' AND CSB.system_id IN (Select CII.system_id '
2177: || ' From CSI_ITEM_INSTANCES CII, '

Line 2196: || ' FROM CSI_SYSTEMS_B CSB, '

2192:
2193:
2194: -- Bug 5041892 --
2195: l_get_all_systems_sql_b := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
2196: || ' FROM CSI_SYSTEMS_B CSB, '
2197: || ' CSI_SYSTEMS_TL CST '
2198: || ' WHERE CSB.system_id = CST.system_id '
2199: || ' AND CSB.system_id IN '
2200: ||' (SELECT CII.system_id '

Line 2229: || ' FROM CSI_SYSTEMS_B CSB, '

2225: || ' Order by CST.name ';
2226:
2227: -- Bug 5041892 --
2228: l_get_all_systems_sql_r := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
2229: || ' FROM CSI_SYSTEMS_B CSB, '
2230: || ' CSI_SYSTEMS_TL CST '
2231: || ' WHERE CSB.system_id = CST.system_id '
2232: || ' AND CSB.system_id IN (Select CII.system_id '
2233: || ' From CSI_ITEM_INSTANCES CII, '

Line 2258: || ' FROM CSI_SYSTEMS_B CSB, '

2254: || ' Order by CST.name ';
2255:
2256:
2257: l_get_all_systems_sql_a := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
2258: || ' FROM CSI_SYSTEMS_B CSB, '
2259: || ' CSI_SYSTEMS_TL CST '
2260: || ' WHERE CSB.system_id = CST.system_id '
2261: || ' AND CSB.system_id IN (Select CII.system_id '
2262: || ' From CSI_ITEM_INSTANCES CII, '

Line 3545: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc

3541: CURSOR l_csr_get_cust_system(p_customer_id IN NUMBER ) IS
3542: SELECT cust_acc.id1, cust_acc.name,
3543: CSB.system_id, '#' id2, CSB.system_number,
3544: CST.description, CST.name system_name
3545: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3546: WHERE cust_acc.id1 = p_customer_id
3547: AND CSB.system_id = CST.system_id
3548: AND CSB.Customer_id = cust_acc.id1
3549: AND CST.language = userenv('lang') -- new

Line 3559: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc

3555: CURSOR l_csr_get_all_cust_system IS
3556: SELECT cust_acc.id1, cust_acc.name,
3557: CSB.system_id, '#' id2, CSB.system_number,
3558: CST.description, CST.name system_name
3559: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3560: WHERE CSB.system_id = CST.system_id
3561: AND CSB.Customer_id = cust_acc.id1
3562: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3563: AND CST.language = userenv('lang') -- new

Line 3571: FROM CSI_SYSTEMS_B CSB,

3567: /** Covered System by party */
3568: CURSOR l_csr_get_party_system(p_party_id IN VARCHAR2) IS
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

Line 3587: FROM CSI_SYSTEMS_B CSB,

3583: CURSOR l_csr_get_all_party_systems IS
3584: SELECT parties.id1, parties.name, CSB.system_id, parties.id2 id2,
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

Line 3603: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site

3599: CURSOR l_csr_get_site_system(p_party_site_id IN NUMBER) IS
3600: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name, CSB.system_id,
3601: '#', CST.name system_name, CST.description,
3602: CSB.system_number, party_site.id2 id2
3603: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3604: WHERE party_site.id1 = p_party_site_id
3605: AND CSB.system_id = CST.system_id
3606: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3607: AND CSB.install_site_use_id = party_site.id1

Line 3615: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site

3611: CURSOR l_csr_site_system_by_party(p_party_id IN NUMBER) IS
3612: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name, CSB.system_id,
3613: '#', CST.name system_name, CST.description,
3614: CSB.system_number, party_site.id2 id2
3615: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3616: WHERE party_site.party_id = p_party_id
3617: AND CSB.system_id = CST.system_id
3618: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3619: AND CSB.install_site_use_id = party_site.id1

Line 3627: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site

3623: CURSOR l_csr_get_all_site_systems IS
3624: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name,
3625: CSB.system_id, party_site.id2 id2, CST.name system_name, CST.description,
3626: CSB.system_number
3627: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3628: WHERE CSB.system_id = CST.system_id
3629: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3630: AND CSB.install_site_use_id = party_site.id1
3631: AND CST.language = userenv('lang') -- new