DBA Data[Home] [Help]

APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 400: FROM okc_k_party_roles_b cpr

396: ,cpr.jtot_object1_code
397: ,cpr.object1_id1
398: ,cpr.object1_id2
399: ,cpr.rle_code
400: FROM okc_k_party_roles_b cpr
401: ,okc_role_sources rsc
402: WHERE
403: rsc.buy_or_sell = 'S' -- sell contract
404: AND rsc.rle_code = cpr.rle_code -- role

Line 2563: okc_k_party_roles_b pt,

2559: SELECT
2560: sr.resource_id
2561: FROM
2562: okc_contacts ct,
2563: okc_k_party_roles_b pt,
2564: okx_salesreps_v sr
2565: WHERE
2566: pt.jtot_object1_code = g_okx_legentity
2567: AND pt.rle_code = g_supplier_ptrol -- g_supplier_ptrol = SUPPLIER