APPS.OKS_AUTH_UTIL_PVT dependencies on CSI_SYSTEMS_B

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

1328: l_get_all_systems_sql VARCHAR2(2000);
1329: TYPE var_cur_type IS REF CURSOR;
1330: l_csr_get_all_systems var_cur_type;
1331:
1332: TYPE get_all_systems_rec IS RECORD (id1 CSI_SYSTEMS_B.system_id%TYPE,
1333: NAME CSI_SYSTEMS_TL.name%TYPE,
1334: Description CSI_SYSTEMS_TL.description%TYPE);
1335:
1336: l_get_all_systems_rec get_all_systems_rec;

Line 1645: || ' FROM CSI_SYSTEMS_B CSB, '

1641:
1642:
1643: -- Bug 5041892 --
1644: l_get_all_systems_sql_c := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
1645: || ' FROM CSI_SYSTEMS_B CSB, '
1646: || ' CSI_SYSTEMS_TL CST '
1647: || ' WHERE CSB.system_id = CST.system_id '
1648: || ' AND CSB.system_id IN (Select CII.system_id '
1649: || ' From CSI_ITEM_INSTANCES CII, '

Line 1668: || ' FROM CSI_SYSTEMS_B CSB, '

1664:
1665:
1666: -- Bug 5041892 --
1667: l_get_all_systems_sql_b := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
1668: || ' FROM CSI_SYSTEMS_B CSB, '
1669: || ' CSI_SYSTEMS_TL CST '
1670: || ' WHERE CSB.system_id = CST.system_id '
1671: || ' AND CSB.system_id IN '
1672: ||' (SELECT CII.system_id '

Line 1701: || ' FROM CSI_SYSTEMS_B CSB, '

1697: || ' Order by CST.name ';
1698:
1699: -- Bug 5041892 --
1700: l_get_all_systems_sql_r := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
1701: || ' FROM CSI_SYSTEMS_B CSB, '
1702: || ' CSI_SYSTEMS_TL CST '
1703: || ' WHERE CSB.system_id = CST.system_id '
1704: || ' AND CSB.system_id IN (Select CII.system_id '
1705: || ' From CSI_ITEM_INSTANCES CII, '

Line 1730: || ' FROM CSI_SYSTEMS_B CSB, '

1726: || ' Order by CST.name ';
1727:
1728:
1729: l_get_all_systems_sql_a := ' SELECT CSB.system_Id Id1 , CST.name name , CST.description description '
1730: || ' FROM CSI_SYSTEMS_B CSB, '
1731: || ' CSI_SYSTEMS_TL CST '
1732: || ' WHERE CSB.system_id = CST.system_id '
1733: || ' AND CSB.system_id IN (Select CII.system_id '
1734: || ' From CSI_ITEM_INSTANCES CII, '

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

3001: CURSOR l_csr_get_cust_system(p_customer_id IN NUMBER ) IS
3002: SELECT cust_acc.id1, cust_acc.name,
3003: CSB.system_id, '#' id2, CSB.system_number,
3004: CST.description, CST.name system_name
3005: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3006: WHERE cust_acc.id1 = p_customer_id
3007: AND CSB.system_id = CST.system_id
3008: AND CSB.Customer_id = cust_acc.id1
3009: AND CST.language = userenv('lang') -- new

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

3015: CURSOR l_csr_get_all_cust_system IS
3016: SELECT cust_acc.id1, cust_acc.name,
3017: CSB.system_id, '#' id2, CSB.system_number,
3018: CST.description, CST.name system_name
3019: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3020: WHERE CSB.system_id = CST.system_id
3021: AND CSB.Customer_id = cust_acc.id1
3022: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3023: AND CST.language = userenv('lang') -- new

Line 3031: FROM CSI_SYSTEMS_B CSB,

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

Line 3047: FROM CSI_SYSTEMS_B CSB,

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

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

3059: CURSOR l_csr_get_site_system(p_party_site_id IN NUMBER) IS
3060: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name, CSB.system_id,
3061: '#', CST.name system_name, CST.description,
3062: CSB.system_number, party_site.id2 id2
3063: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3064: WHERE party_site.id1 = p_party_site_id
3065: AND CSB.system_id = CST.system_id
3066: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3067: AND CSB.install_site_use_id = party_site.id1

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

3071: CURSOR l_csr_site_system_by_party(p_party_id IN NUMBER) IS
3072: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name, CSB.system_id,
3073: '#', CST.name system_name, CST.description,
3074: CSB.system_number, party_site.id2 id2
3075: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3076: WHERE party_site.party_id = p_party_id
3077: AND CSB.system_id = CST.system_id
3078: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3079: AND CSB.install_site_use_id = party_site.id1

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

3083: CURSOR l_csr_get_all_site_systems IS
3084: SELECT party_site.id1, party_site.party_site_number || '-' || party_site.name party_site_name,
3085: CSB.system_id, party_site.id2 id2, CST.name system_name, CST.description,
3086: CSB.system_number
3087: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_PARTY_SITES_V party_site
3088: WHERE CSB.system_id = CST.system_id
3089: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3090: AND CSB.install_site_use_id = party_site.id1
3091: AND CST.language = userenv('lang') -- new