DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on OKC_K_HEADERS_TL

Line 3047: l_contract_description okc_k_headers_tl.short_description%TYPE;

3043: l_conversion NUMBER;
3044: l_req_completed BOOLEAN;
3045: l_activity_rec csd_update_programs_pvt.activity_rec_type;
3046: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
3047: l_contract_description okc_k_headers_tl.short_description%TYPE;
3048: l_item_name VARCHAR2(800);
3049: l_duration_desc VARCHAR2(15);
3050: l_org_id NUMBER;
3051: l_ship_from_org_id NUMBER;

Line 3592: FROM oks_reprocessing okr,okc_k_headers_all_b okh,okc_k_headers_tl okhtl

3588: -- 1. get the contract number and its short description
3589: BEGIN
3590: SELECT okh.contract_number,okhtl.short_description
3591: INTO l_contract_number,l_contract_description
3592: FROM oks_reprocessing okr,okc_k_headers_all_b okh,okc_k_headers_tl okhtl
3593: WHERE okr.order_line_id = x_line_tbl(1).line_id
3594: AND okr.order_id = l_header_id
3595: AND okr.contract_id = okh.id
3596: AND okh.id = okhtl.id