APPS.AHL_FMP_MR_HEADER_PVT dependencies on QA_CHAR_VALUE_LOOKUPS

Line 655: FROM qa_char_value_lookups_v

651:
652: CURSOR get_qainspection_type_code(p_qa_inspection_type_desc VARCHAR2)
653: IS
654: SELECT short_code
655: FROM qa_char_value_lookups_v
656: WHERE char_id = 87
657: AND upper(description) = upper(ltrim(rtrim(p_qa_inspection_type_desc)));
658:
659: l_prec_mr_info get_prec_mrheader_info%rowtype;

Line 1072: qa_char_value_lookups qa,

1068: mr.down_time,
1069: mr.uom_code
1070: FROM
1071: ahl_mr_headers_b mr,
1072: qa_char_value_lookups qa,
1073: mtl_system_items_kfv mtl
1074: WHERE
1075: mr_header_id= c_mr_header_id AND
1076: qa.short_code(+) = mr.qa_inspection_type AND