DBA Data[Home] [Help]

APPS.OKL_VENDORMERGE_GRP dependencies on OKC_K_HEADERS_ALL_B

Line 69: FROM OKC_K_HEADERS_ALL_B CHR

65: CURSOR chk_vendor_chr_csr (p_src_vendor_id NUMBER, p_des_vendor_id NUMBER)
66: IS
67: SELECT CHR.CONTRACT_NUMBER
68: , CHR.ID
69: FROM OKC_K_HEADERS_ALL_B CHR
70: , OKC_K_PARTY_ROLES_B CPRS
71: , OKC_K_PARTY_ROLES_B CPRD
72: WHERE CPRS.CHR_ID = CHR.ID
73: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID

Line 94: FROM OKC_K_HEADERS_ALL_B CHR

90: IS
91: SELECT CHR.CONTRACT_NUMBER
92: , CHR.ID
93: , CPRD.CLE_ID
94: FROM OKC_K_HEADERS_ALL_B CHR
95: , OKC_K_PARTY_ROLES_B CPRS
96: , OKC_K_PARTY_ROLES_B CPRD
97: WHERE CPRS.DNZ_CHR_ID = CHR.ID
98: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID