DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on HZ_RELATIONSHIPS

Line 1394: HZ_RELATIONSHIPS R

1390: select SUBSTRB(P.PERSON_LAST_NAME,1,50) || ', ' || SUBSTRB(P.PERSON_FIRST_NAME,1,40) name
1391: FROM OKS_K_HEADERS_B OKSH,
1392: HZ_CUST_ACCOUNT_ROLES CAR,
1393: HZ_PARTIES P,
1394: HZ_RELATIONSHIPS R
1395: WHERE OKSH.quote_to_contact_id = car.CUST_ACCOUNT_ROLE_ID
1396: AND CAR.ROLE_TYPE = 'CONTACT'
1397: AND R.PARTY_ID = CAR.PARTY_ID
1398: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'