APPS.OKL_AM_PARTIES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 43: FROM okc_k_party_roles_b pr

39: SELECT pr.id cpl_id,
40: pr.jtot_object1_code object1_code,
41: pr.object1_id1 object1_id1,
42: pr.object1_id2 object1_id2
43: FROM okc_k_party_roles_b pr
44: WHERE pr.rle_code = cp_role_code
45: AND pr.cle_id IS NULL
46: AND pr.chr_id = cp_contract_id
47: AND pr.dnz_chr_id = cp_contract_id

Line 481: FROM okc_k_party_roles_b pr,

477: SELECT kh.buy_or_sell k_buy_or_sell,
478: lq.meaning qp_party_role,
479: pr.rle_code kp_role_code,
480: lk.meaning kp_party_role
481: FROM okc_k_party_roles_b pr,
482: okc_k_headers_b kh,
483: fnd_lookups lq,
484: fnd_lookups lk
485: WHERE pr.id = cp_cpl_id

Line 799: okc_k_party_roles_b kpr

795: kpr.object1_id1 object1_id1,
796: kpr.object1_id2 object1_id2
797: FROM okl_k_headers khr,
798: okc_k_headers_all_b par,
799: okc_k_party_roles_b kpr
800: WHERE khr.id = cp_chr_id
801: AND par.id (+) = khr.khr_id
802: AND par.scs_code (+) = 'PROGRAM'
803: AND kpr.dnz_chr_id (+) = par.id

Line 1047: FROM okc_k_party_roles_b kpr

1043: SELECT kpr.rle_code rle_code,
1044: kpr.jtot_object1_code object1_code,
1045: kpr.object1_id1 object1_id1,
1046: kpr.object1_id2 object1_id2
1047: FROM okc_k_party_roles_b kpr
1048: WHERE kpr.id = cp_cpl_id
1049: AND kpr.chr_id = cp_khr_id
1050: AND kpr.dnz_chr_id = cp_khr_id;
1051:

Line 1584: okc_k_party_roles_b pr,

1580: pr.object1_id2 po_party_id2,
1581: kh.id contract_id,
1582: kh.buy_or_sell k_buy_or_sell
1583: FROM okl_quote_parties qp,
1584: okc_k_party_roles_b pr,
1585: okl_trx_quotes_b tq,
1586: okc_k_headers_all_b kh,
1587: fnd_lookups lq,
1588: fnd_lookups lk