APPS.AHL_FMP_MR_HEADER_PVT dependencies on QA_CHAR_VALUE_LOOKUPS

Line 718: FROM qa_char_value_lookups_v

714:
715: CURSOR get_qainspection_type_code(p_qa_inspection_type_desc VARCHAR2)
716: IS
717: SELECT short_code
718: FROM qa_char_value_lookups_v
719: WHERE char_id = 87
720: AND upper(description) = upper(ltrim(rtrim(p_qa_inspection_type_desc)));
721:
722: l_prec_mr_info get_prec_mrheader_info%rowtype;

Line 1202: qa_char_value_lookups qa,

1198: mr.down_time,
1199: mr.uom_code
1200: FROM
1201: ahl_mr_headers_b mr,
1202: qa_char_value_lookups qa,
1203: mtl_system_items_kfv mtl
1204: WHERE
1205: mr_header_id= c_mr_header_id AND
1206: qa.short_code(+) = mr.qa_inspection_type AND