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.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_K_PARTY_ROLES_V

Line 192: p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%Type,

188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_chr_id IN VARCHAR2,
191: p_cle_id IN VARCHAR2,
192: p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%Type,
193: p_intent IN VARCHAR2 default 'S',
194: x_party_tab out NOCOPY party_tab_type) is
195:
196: CURSOR party_role_curs(p_chr_id IN NUMBER,

Line 204: from OKC_K_PARTY_ROLES_V

200: select object1_id1,
201: object1_id2,
202: jtot_object1_code,
203: rle_code
204: from OKC_K_PARTY_ROLES_V
205: where rle_code = nvl(p_role_code,rle_code)
206: and nvl(cle_id,-99999) = p_cle_id
207: and nvl(chr_id,-99999) = p_chr_id
208: and dnz_chr_id = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)

Line 216: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

212: l_from_clause varchar2(2000) default null;
213: l_where_clause varchar2(2000) default null;
214: l_order_by_clause varchar2(2000) default null;
215: l_query_string varchar2(2000) default null;
216: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
217: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
218: l_name VARCHAR2(250) Default Null;
219: l_Description VARCHAR2(250) Default Null;
220: l_object_code VARCHAR2(30) Default Null;

Line 217: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

213: l_where_clause varchar2(2000) default null;
214: l_order_by_clause varchar2(2000) default null;
215: l_query_string varchar2(2000) default null;
216: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
217: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
218: l_name VARCHAR2(250) Default Null;
219: l_Description VARCHAR2(250) Default Null;
220: l_object_code VARCHAR2(30) Default Null;
221: type party_curs_type is REF CURSOR;

Line 432: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

428: l_from_clause varchar2(2000) default null;
429: l_where_clause varchar2(2000) default null;
430: l_order_by_clause varchar2(2000) default null;
431: l_query_string varchar2(2000) default null;
432: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
433: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
434: l_name VARCHAR2(250) Default Null;
435: l_Description VARCHAR2(250) Default Null;
436: l_object_code VARCHAR2(30) Default Null;

Line 433: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

429: l_where_clause varchar2(2000) default null;
430: l_order_by_clause varchar2(2000) default null;
431: l_query_string varchar2(2000) default null;
432: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
433: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
434: l_name VARCHAR2(250) Default Null;
435: l_Description VARCHAR2(250) Default Null;
436: l_object_code VARCHAR2(30) Default Null;
437: type party_curs_type is REF CURSOR;

Line 808: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

804: l_where_clause varchar2(2000) default null;
805: l_order_by_clause varchar2(2000) default null;
806: l_query_string varchar2(2000) default null;
807:
808: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
809: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
810: l_name VARCHAR2(250) Default Null;
811: l_description VARCHAR2(250) Default Null;
812: l_object_code VARCHAR2(30) Default Null;

Line 809: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

805: l_order_by_clause varchar2(2000) default null;
806: l_query_string varchar2(2000) default null;
807:
808: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
809: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
810: l_name VARCHAR2(250) Default Null;
811: l_description VARCHAR2(250) Default Null;
812: l_object_code VARCHAR2(30) Default Null;
813:

Line 814: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

810: l_name VARCHAR2(250) Default Null;
811: l_description VARCHAR2(250) Default Null;
812: l_object_code VARCHAR2(30) Default Null;
813:
814: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
815: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
816:
817: type party_curs_type is REF CURSOR;
818: party_curs party_curs_type;

Line 815: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

811: l_description VARCHAR2(250) Default Null;
812: l_object_code VARCHAR2(30) Default Null;
813:
814: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
815: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
816:
817: type party_curs_type is REF CURSOR;
818: party_curs party_curs_type;
819:

Line 823: l_rle_code okc_k_party_roles_v.rle_code%type;

819:
820: row_count Number default 0;
821:
822: l_chr_id okl_k_headers.id%type;
823: l_rle_code okc_k_party_roles_v.rle_code%type;
824: l_cle_id okl_k_lines.id%type;
825: l_lty_code okc_line_styles_b.lty_code%type;
826:
827: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Party';

Line 850: FROM okc_k_party_roles_v

846: --end modified abhsaxen for performance SQLID 20562561
847: ;
848: CURSOR get_party_csr(p_cpl_id NUMBER) IS
849: SELECT rle_code, object1_id1, object1_id2
850: FROM okc_k_party_roles_v
851: WHERE id = p_cpl_id;
852:
853: Begin
854:

Line 1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;

1250: l_rle_code_meaning fnd_lookup_values.meaning%type;
1251:
1252: row_count number;
1253:
1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;
1255: l_rle_code okc_k_party_roles_v.rle_code%type;
1256: l_id1 okx_vendor_sites_v.vendor_id%type;
1257:
1258: l_id okc_rg_party_roles_v.id%type;

Line 1255: l_rle_code okc_k_party_roles_v.rle_code%type;

1251:
1252: row_count number;
1253:
1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;
1255: l_rle_code okc_k_party_roles_v.rle_code%type;
1256: l_id1 okx_vendor_sites_v.vendor_id%type;
1257:
1258: l_id okc_rg_party_roles_v.id%type;
1259: l_rgp_id okc_rg_party_roles_v.rgp_id%type;

Line 1276: select object1_id1,rle_code from okc_k_party_roles_v

1272:
1273: lp_rulv_tbl Okl_Rule_Pub.rulv_tbl_type;
1274:
1275: cursor l_vendor_csr is
1276: select object1_id1,rle_code from okc_k_party_roles_v
1277: where id = p_cpl_id;
1278:
1279: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and khr_id
1280: -- be referred from this table instead of okl_trx_ap_invoices_b. changes made