DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_K_HDR_AGREEDS_V

Line 111: OKC_K_HDR_AGREEDS_V K,

107: C.AUTHORITY REQUESTOR,
108: C.SIGNATURE_REQUIRED_YN
109: from okc_change_requests_v C,
110: OKC_K_PROCESSES cpr,
111: OKC_K_HDR_AGREEDS_V K,
112: fnd_user_view U
113: where C.ID = p_change_request_id
114: and K.ID = C.CHR_ID
115: and cpr.crt_id = C.ID

Line 746: OKC_K_HDR_AGREEDS_V K

742: substr(K.CONTRACT_NUMBER
743: ||K.CONTRACT_NUMBER_MODIFIER
744: ||C.NAME,1,240) KEY
745: from okc_change_requests_v C,
746: OKC_K_HDR_AGREEDS_V K
747: where C.ID = p_change_request_id
748: and K.ID = C.CHR_ID;
749: --
750: --

Line 819: OKC_K_HDR_AGREEDS_V K

815: substr(K.CONTRACT_NUMBER
816: ||K.CONTRACT_NUMBER_MODIFIER
817: ||C.NAME,1,240) KEY
818: from okc_change_requests_v C,
819: OKC_K_HDR_AGREEDS_V K
820: where C.ID = p_change_request_id
821: and K.ID = C.CHR_ID;
822: --
823: l_wf_name_active varchar2(150);