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: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;

662: x_prod_selections_tbl IN OUT NOCOPY prod_selections_tbl )
663: IS
664: l_price NUMBER;
665: l_name VARCHAR2(1000);
666: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;
667: -- Bug 4915711 --
668: -- l_install_site_name OKX_PARTY_SITES_V.DESCRIPTION%TYPE;
669: l_install_site_name VARCHAR2(2000);
670: -- Bug 4915711 --

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

664: l_price NUMBER;
665: l_name VARCHAR2(1000);
666: l_install_site_id OKX_PARTY_SITES_V.id1%TYPE;
667: -- Bug 4915711 --
668: -- l_install_site_name OKX_PARTY_SITES_V.DESCRIPTION%TYPE;
669: l_install_site_name VARCHAR2(2000);
670: -- Bug 4915711 --
671:
672: rowcount NUMBER ;

Line 679: FROM OKX_PARTY_SITES_V S

675: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;
676:
677: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
678: SELECT S.DESCRIPTION
679: FROM OKX_PARTY_SITES_V S
680: WHERE S.ID1 = l_install_site_id;
681:
682: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
683: IS

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

1315: -- Setting up cursor types + record types to fetch Party Sites using Dynamic cursor
1316: l_get_all_sites_sql VARCHAR2(2000);
1317: TYPE var_cur_type1 IS REF CURSOR ;
1318: l_csr_get_all_sites var_cur_type1;
1319: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1320: name OKX_PARTY_SITES_V.name%TYPE,
1321: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1322: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1323: description VARCHAR2(2000));

Line 1320: name OKX_PARTY_SITES_V.name%TYPE,

1316: l_get_all_sites_sql VARCHAR2(2000);
1317: TYPE var_cur_type1 IS REF CURSOR ;
1318: l_csr_get_all_sites var_cur_type1;
1319: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1320: name OKX_PARTY_SITES_V.name%TYPE,
1321: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1322: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1323: description VARCHAR2(2000));
1324:

Line 1321: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,

1317: TYPE var_cur_type1 IS REF CURSOR ;
1318: l_csr_get_all_sites var_cur_type1;
1319: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1320: name OKX_PARTY_SITES_V.name%TYPE,
1321: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1322: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1323: description VARCHAR2(2000));
1324:
1325: l_get_all_sites_rec get_all_sites_rec;

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

1318: l_csr_get_all_sites var_cur_type1;
1319: TYPE get_all_sites_rec IS RECORD (id1 OKX_PARTY_SITES_V.id1%TYPE,
1320: name OKX_PARTY_SITES_V.name%TYPE,
1321: party_site_number OKX_PARTY_SITES_V.party_site_number%TYPE,
1322: -- description OKX_PARTY_SITES_V.description%TYPE -- Bug 4915711
1323: description VARCHAR2(2000));
1324:
1325: l_get_all_sites_rec get_all_sites_rec;
1326:

Line 1899: || ' FROM OKX_PARTY_SITES_V SI '

1895: -- Bug 5004778 --
1896: -- Modified Query to reduce shared memory Usage
1897: -- Replaced views to base tables where ever possible
1898: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1899: || ' FROM OKX_PARTY_SITES_V SI '
1900: || ' WHERE exists (SELECT CII.install_location_Id '
1901: ||' FROM CSI_ITEM_INSTANCES CII, '
1902: ||' CSI_INSTANCE_STATUSES CIS, '
1903: ||' MTL_SYSTEM_ITEMS_B IT '

Line 1927: || ' FROM OKX_PARTY_SITES_V SI '

1923: -- Bug 5004778 --
1924: -- Modified Query to reduce shared memory Usage
1925: -- Replaced views to base tables where ever possible
1926: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1927: || ' FROM OKX_PARTY_SITES_V SI '
1928: || ' WHERE exists (SELECT CII.install_location_Id '
1929: ||' FROM CSI_ITEM_INSTANCES CII, '
1930: ||' CSI_INSTANCE_STATUSES CIS '
1931: ||' , MTL_SYSTEM_ITEMS_B IT '

Line 1961: || ' FROM OKX_PARTY_SITES_V SI '

1957: -- Bug 5004778 --
1958: -- Modified Query to reduce shared memory Usage
1959: -- Replaced views to base tables where ever possible
1960: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1961: || ' FROM OKX_PARTY_SITES_V SI '
1962: || ' WHERE exists (SELECT CII.install_location_Id '
1963: || ' FROM CSI_ITEM_INSTANCES CII, '
1964: ||' CSI_INSTANCE_STATUSES CIS '
1965: ||' , MTL_SYSTEM_ITEMS_B IT '

Line 1997: || ' FROM OKX_PARTY_SITES_V SI '

1993: ||' ORDER BY si.party_site_number, si.name ';
1994: -- Bug 5004778 --
1995:
1996: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1997: || ' FROM OKX_PARTY_SITES_V SI '
1998: || ' WHERE exists (SELECT CII.install_location_Id '
1999: || ' FROM CSI_ITEM_INSTANCES CII, '
2000: ||' CSI_INSTANCE_STATUSES CIS '
2001: ||' , MTL_SYSTEM_ITEMS_KFV IT '

Line 2771: OKX_PARTY_SITES_V party_site

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

Line 2782: OKX_PARTY_SITES_V party_site

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

Line 2807: party_sites_Id1 OKX_PARTY_SITES_V.ID1%TYPE,

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

Line 2808: Party_Sites_Number OKX_PARTY_SITES_V.party_site_number%TYPE,

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

Line 2809: party_sites_Id2 OKX_PARTY_SITES_V.ID2%TYPE,

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,
2811: party_desc VARCHAR2(2000)
2812: );
2813:

Line 2810: party_sites_name OKX_PARTY_SITES_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,
2811: party_desc VARCHAR2(2000)
2812: );
2813:
2814: l_get_all_sites_rec get_all_sites_rec;

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