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.OKE_CONTRACT_PARTY_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 169: FROM OKC_K_PARTY_ROLES_B V

165: )IS
166:
167: CURSOR get_jtot_object_code_line is
168: SELECT DISTINCT JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
169: FROM OKC_K_PARTY_ROLES_B V
170: , okc_k_lines_b okl
171: WHERE V.DNZ_CHR_ID = p_cplv_rec.dnz_chr_id AND V.CHR_ID IS NOT NULL
172: AND okl.id= p_cplv_rec.cle_id
173: AND EXISTS (

Line 208: AND NOT EXISTS (select 'x' from okc_k_party_roles_b

204: AND SYSDATE BETWEEN SRE.START_DATE
205: AND NVL(SRE.END_DATE , SYSDATE)
206: AND NOT (RSC.RLE_CODE IN ( 'SHIP_TO', 'BILL_TO', 'MARK_FOR')
207: AND p_buy_sell = 'S'
208: AND NOT EXISTS (select 'x' from okc_k_party_roles_b
209: where chr_id = p_cplv_rec.dnz_chr_id and rle_code = 'K_CUSTOMER'
210: and object1_id1 is not null and jtot_object1_code = 'OKE_CUSTACCT'))
211: AND NOT (RSC.RLE_CODE = 'SHIP_FROM'
212: AND p_buy_sell = 'B'

Line 213: AND NOT EXISTS (select 'x' from okc_k_party_roles_b

209: where chr_id = p_cplv_rec.dnz_chr_id and rle_code = 'K_CUSTOMER'
210: and object1_id1 is not null and jtot_object1_code = 'OKE_CUSTACCT'))
211: AND NOT (RSC.RLE_CODE = 'SHIP_FROM'
212: AND p_buy_sell = 'B'
213: AND NOT EXISTS (select 'x' from okc_k_party_roles_b
214: where chr_id = p_cplv_rec.dnz_chr_id and rle_code = 'CONTRACTOR'
215: and object1_id1 is not null and jtot_object1_code = 'OKX_VENDOR')) ;
216:
217:

Line 295: ' CUST_ACCOUNT_ID IN (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B'

291:
292: if p_cplv_rec.rle_code = 'MARK_FOR' then
293:
294: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt,
295: ' CUST_ACCOUNT_ID IN (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B'
296: ||' WHERE CHR_ID = '||p_cplv_rec.dnz_chr_id||' '
297: ||' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'') AND '||
298: 'STATUS = ''A'' ' );
299: END IF;

Line 305: ' WHERE related_cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID = '||p_cplv_rec.dnz_chr_id||''||

301: IF p_cplv_rec.rle_code = 'BILL_TO' then
302:
303: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt,
304: ' Cust_account_id IN ( SELECT cust_account_id FROM hz_cust_acct_relate '||
305: ' WHERE related_cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID = '||p_cplv_rec.dnz_chr_id||''||
306: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'')'||
307: ' AND bill_to_flag = ''Y'' AND status = ''A'' UNION ' ||
308: ' SELECT cust_acct.cust_account_id FROM hz_parties party, hz_cust_accounts cust_acct '||
309: ' WHERE party.party_id = cust_acct.party_id ' ||

Line 310: ' and cust_acct.cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||

306: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'')'||
307: ' AND bill_to_flag = ''Y'' AND status = ''A'' UNION ' ||
308: ' SELECT cust_acct.cust_account_id FROM hz_parties party, hz_cust_accounts cust_acct '||
309: ' WHERE party.party_id = cust_acct.party_id ' ||
310: ' and cust_acct.cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||
311: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'' ) ) AND ' ||
312: 'STATUS = ''A'' ');
313:
314: END IF;

Line 320: ' WHERE related_cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||

316: if p_cplv_rec.rle_code = 'SHIP_TO' then
317:
318: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt,
319: ' Cust_account_id IN ( SELECT cust_account_id FROM hz_cust_acct_relate '||
320: ' WHERE related_cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||
321: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'')'||
322: ' AND ship_to_flag = ''Y'' AND status = ''A'' UNION ' ||
323: ' SELECT cust_acct.cust_account_id FROM hz_parties party, hz_cust_accounts cust_acct '||
324: ' WHERE party.party_id = cust_acct.party_id ' ||

Line 325: ' and cust_acct.cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||

321: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'')'||
322: ' AND ship_to_flag = ''Y'' AND status = ''A'' UNION ' ||
323: ' SELECT cust_acct.cust_account_id FROM hz_parties party, hz_cust_accounts cust_acct '||
324: ' WHERE party.party_id = cust_acct.party_id ' ||
325: ' and cust_acct.cust_account_id in (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||''||
326: ' AND JTOT_OBJECT1_CODE = ''OKE_CUSTACCT'' AND RLE_CODE =''K_CUSTOMER'' ) ) AND ' ||
327: 'STATUS = ''A'' ' );
328:
329: END IF;

Line 333: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt, ' VENDOR_ID IN (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||' '

329: END IF;
330: ELSE --buy_or_sell = 'S'
331:
332: if p_cplv_rec.rle_code = 'SHIP_FROM' then
333: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt, ' VENDOR_ID IN (SELECT OBJECT1_ID1 FROM OKC_K_PARTY_ROLES_B WHERE CHR_ID ='||p_cplv_rec.dnz_chr_id||' '
334: || ' AND JTOT_OBJECT1_CODE = ''OKX_VENDOR'' AND RLE_CODE =''CONTRACTOR'')'
335: || ' AND STATUS = ''A''');
336:
337: end if;

Line 436: SELECT object_version_number FROM okc_k_party_roles_B

432: p_cplv_tbl_in out nocopy OKC_CONTRACT_PARTY_PUB.cplv_tbl_type
433: ) IS
434: l_cplv_tbl_in OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;
435: CURSOR party_roles_cur IS
436: SELECT object_version_number FROM okc_k_party_roles_B
437: WHERE id=p_cplv_rec.id;
438:
439: l_object_vers_num NUMBER;
440: BEGIN

Line 1357: FROM okc_k_party_roles_b

1353: )IS
1354:
1355: CURSOR get_party_info IS
1356: SELECT rle_code,jtot_object1_code,object1_id1,object1_id2
1357: FROM okc_k_party_roles_b
1358: WHERE id= p_ctcv_rec.cpl_id ;
1359:
1360: CURSOR get_header_info IS
1361: SELECT buy_or_sell FROM

Line 1374: party_rle_code OKC_K_PARTY_ROLEs_B.RLE_CODE%TYPE;

1370: and b.buy_or_sell = p_BUY_OR_SELL ;
1371:
1372: l_sql_stmt VARCHAR2(2500);
1373: l_dummy_var VARCHAR2(1) := '?';
1374: party_rle_code OKC_K_PARTY_ROLEs_B.RLE_CODE%TYPE;
1375: party_jtot_object1_code OKC_K_PARTY_ROLEs_B.JTOT_OBJECT1_CODE%TYPE;
1376: party_object1_id1 OKC_K_PARTY_ROLEs_B.object1_id1%TYPE;
1377: party_object1_id2 OKC_K_PARTY_ROLEs_B.object1_id2%TYPE;
1378:

Line 1375: party_jtot_object1_code OKC_K_PARTY_ROLEs_B.JTOT_OBJECT1_CODE%TYPE;

1371:
1372: l_sql_stmt VARCHAR2(2500);
1373: l_dummy_var VARCHAR2(1) := '?';
1374: party_rle_code OKC_K_PARTY_ROLEs_B.RLE_CODE%TYPE;
1375: party_jtot_object1_code OKC_K_PARTY_ROLEs_B.JTOT_OBJECT1_CODE%TYPE;
1376: party_object1_id1 OKC_K_PARTY_ROLEs_B.object1_id1%TYPE;
1377: party_object1_id2 OKC_K_PARTY_ROLEs_B.object1_id2%TYPE;
1378:
1379: l_party_id VARCHAR2(40);

Line 1376: party_object1_id1 OKC_K_PARTY_ROLEs_B.object1_id1%TYPE;

1372: l_sql_stmt VARCHAR2(2500);
1373: l_dummy_var VARCHAR2(1) := '?';
1374: party_rle_code OKC_K_PARTY_ROLEs_B.RLE_CODE%TYPE;
1375: party_jtot_object1_code OKC_K_PARTY_ROLEs_B.JTOT_OBJECT1_CODE%TYPE;
1376: party_object1_id1 OKC_K_PARTY_ROLEs_B.object1_id1%TYPE;
1377: party_object1_id2 OKC_K_PARTY_ROLEs_B.object1_id2%TYPE;
1378:
1379: l_party_id VARCHAR2(40);
1380:

Line 1377: party_object1_id2 OKC_K_PARTY_ROLEs_B.object1_id2%TYPE;

1373: l_dummy_var VARCHAR2(1) := '?';
1374: party_rle_code OKC_K_PARTY_ROLEs_B.RLE_CODE%TYPE;
1375: party_jtot_object1_code OKC_K_PARTY_ROLEs_B.JTOT_OBJECT1_CODE%TYPE;
1376: party_object1_id1 OKC_K_PARTY_ROLEs_B.object1_id1%TYPE;
1377: party_object1_id2 OKC_K_PARTY_ROLEs_B.object1_id2%TYPE;
1378:
1379: l_party_id VARCHAR2(40);
1380:
1381: l_buy_or_sell VARCHAR2(5);