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_PARTY_SITES_V

Line 666: FROM OKX_PARTY_SITES_V S

662:
663:
664: CURSOR l_site_name_csr IS
665: SELECT S.DESCRIPTION
666: FROM OKX_PARTY_SITES_V S
667: WHERE S.ID1 = p_install_location_id;
668:
669: CURSOR l_loc_site_name_csr IS
670: SELECT

Line 748: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;

744: x_prod_selections_tbl IN OUT NOCOPY prod_selections_tbl )
745: IS
746: l_price NUMBER;
747: l_name VARCHAR2(1000);
748: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;
749: -- Bug 4915711 --
750: -- l_install_site_name OKX_PARTY_SITES_V.DESCRIPTION%TYPE;
751: l_install_site_name VARCHAR2(2000);
752: -- Bug 4915711 --

Line 750: -- l_install_site_name OKX_PARTY_SITES_V.DESCRIPTION%TYPE;

746: l_price NUMBER;
747: l_name VARCHAR2(1000);
748: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;
749: -- Bug 4915711 --
750: -- l_install_site_name OKX_PARTY_SITES_V.DESCRIPTION%TYPE;
751: l_install_site_name VARCHAR2(2000);
752: -- Bug 4915711 --
753:
754: rowcount NUMBER ;

Line 761: FROM OKX_PARTY_SITES_V S

757: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;
758:
759: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
760: SELECT S.DESCRIPTION
761: FROM OKX_PARTY_SITES_V S
762: WHERE S.ID1 = l_install_site_id;
763:
764: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
765: IS

Line 1501: FROM OKX_PARTY_SITES_V S

1497: l_install_site_name VARCHAR2(1000);
1498:
1499: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
1500: SELECT S.DESCRIPTION
1501: FROM OKX_PARTY_SITES_V S
1502: WHERE S.ID1 = l_install_site_id;
1503:
1504: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
1505: IS

Line 1847: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,

1843: -- Setting up cursor types + record types to fetch Party Sites using Dynamic cursor
1844: l_get_all_sites_sql VARCHAR2(2000);
1845: TYPE var_cur_type1 IS REF CURSOR ;
1846: l_csr_get_all_sites var_cur_type1;
1847: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1848: name OKX_PARTY_SITES_V.name%TYPE,
1849: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1850: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1851: description VARCHAR2(2000));

Line 1848: name OKX_PARTY_SITES_V.name%TYPE,

1844: l_get_all_sites_sql VARCHAR2(2000);
1845: TYPE var_cur_type1 IS REF CURSOR ;
1846: l_csr_get_all_sites var_cur_type1;
1847: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1848: name OKX_PARTY_SITES_V.name%TYPE,
1849: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1850: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1851: description VARCHAR2(2000));
1852:

Line 1849: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,

1845: TYPE var_cur_type1 IS REF CURSOR ;
1846: l_csr_get_all_sites var_cur_type1;
1847: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1848: name OKX_PARTY_SITES_V.name%TYPE,
1849: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1850: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1851: description VARCHAR2(2000));
1852:
1853: l_get_all_sites_rec get_all_sites_rec;

Line 1850: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711

1846: l_csr_get_all_sites var_cur_type1;
1847: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1848: name OKX_PARTY_SITES_V.name%TYPE,
1849: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1850: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1851: description VARCHAR2(2000));
1852:
1853: l_get_all_sites_rec get_all_sites_rec;
1854:

Line 2427: || ' FROM OKX_PARTY_SITES_V SI '

2423: -- Bug 5004778 --
2424: -- Modified Query to reduce shared memory Usage
2425: -- Replaced views to base tables where ever possible
2426: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2427: || ' FROM OKX_PARTY_SITES_V SI '
2428: || ' WHERE exists (SELECT CII.install_location_Id '
2429: ||' FROM CSI_ITEM_INSTANCES CII, '
2430: ||' CSI_INSTANCE_STATUSES CIS, '
2431: ||' MTL_SYSTEM_ITEMS_B IT '

Line 2455: || ' FROM OKX_PARTY_SITES_V SI '

2451: -- Bug 5004778 --
2452: -- Modified Query to reduce shared memory Usage
2453: -- Replaced views to base tables where ever possible
2454: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2455: || ' FROM OKX_PARTY_SITES_V SI '
2456: || ' WHERE exists (SELECT CII.install_location_Id '
2457: ||' FROM CSI_ITEM_INSTANCES CII, '
2458: ||' CSI_INSTANCE_STATUSES CIS '
2459: ||' , MTL_SYSTEM_ITEMS_B IT '

Line 2489: || ' FROM OKX_PARTY_SITES_V SI '

2485: -- Bug 5004778 --
2486: -- Modified Query to reduce shared memory Usage
2487: -- Replaced views to base tables where ever possible
2488: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2489: || ' FROM OKX_PARTY_SITES_V SI '
2490: || ' WHERE exists (SELECT CII.install_location_Id '
2491: || ' FROM CSI_ITEM_INSTANCES CII, '
2492: ||' CSI_INSTANCE_STATUSES CIS '
2493: ||' , MTL_SYSTEM_ITEMS_B IT '

Line 2525: || ' FROM OKX_PARTY_SITES_V SI '

2521: ||' ORDER BY si.party_site_number, si.name ';
2522: -- Bug 5004778 --
2523:
2524: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2525: || ' FROM OKX_PARTY_SITES_V SI '
2526: || ' WHERE exists (SELECT CII.install_location_Id '
2527: || ' FROM CSI_ITEM_INSTANCES CII, '
2528: ||' CSI_INSTANCE_STATUSES CIS '
2529: ||' , MTL_SYSTEM_ITEMS_KFV IT '

Line 3311: OKX_PARTY_SITES_V party_site

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'
3315: ORDER BY parties.name ;

Line 3322: OKX_PARTY_SITES_V party_site

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 ;
3326:

Line 3347: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,

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,
3351: party_desc VARCHAR2(2000)

Line 3348: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,

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,
3351: party_desc VARCHAR2(2000)
3352: );

Line 3349: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,

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,
3351: party_desc VARCHAR2(2000)
3352: );
3353:

Line 3350: party_sites_name OKX_PARTY_SITES_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,
3351: party_desc VARCHAR2(2000)
3352: );
3353:
3354: l_get_all_sites_rec get_all_sites_rec;

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