eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CNL_PVT dependencies on OKC_CONDITION_HEADERS_V

Line 735: FROM Okc_Condition_Headers_V

731: CREATION_DATE,
732: LAST_UPDATED_BY,
733: LAST_UPDATE_DATE,
734: LAST_UPDATE_LOGIN
735: FROM Okc_Condition_Headers_V
736: WHERE okc_condition_headers_v.id = p_id;
737: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
738: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
739: SELECT

Line 736: WHERE okc_condition_headers_v.id = p_id;

732: LAST_UPDATED_BY,
733: LAST_UPDATE_DATE,
734: LAST_UPDATE_LOGIN
735: FROM Okc_Condition_Headers_V
736: WHERE okc_condition_headers_v.id = p_id;
737: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
738: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
739: SELECT
740: ID,

Line 921: CURSOR cnhv_cur IS select 'X' from okc_condition_headers_v cnh

917: IS
918:
919: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
920: l_temp NUMBER ;
921: CURSOR cnhv_cur IS select 'X' from okc_condition_headers_v cnh
922: where cnh.id = p_cnlv_rec.cnh_id;
923: v_cnhv_rec varchar2(1);
924: BEGIN
925: -- initialize return status

Line 1064: select 'X' from okc_action_attributes_v aae,okc_condition_headers_v cnh

1060: CURSOR aaev_cur IS
1061: select 'X' from okc_action_attributes_v aae
1062: where aae.id = p_cnlv_rec.aae_id;
1063: CURSOR aae_cnh_cur IS
1064: select 'X' from okc_action_attributes_v aae,okc_condition_headers_v cnh
1065: where aae.id = p_cnlv_rec.aae_id
1066: and cnh.id = p_cnlv_rec.cnh_id
1067: and aae.acn_id = cnh.acn_id;
1068: BEGIN