DBA Data[Home] [Help]

APPS.QA_SPECS_PUB dependencies on QA_CUSTOMERS_LOV_V

Line 985: FROM qa_customers_lov_v

981: l_customer_id := qa_plan_element_api.get_customer_id(p_customer_name);
982: ELSE
983: -- Validate customer
984: SELECT count(*) into l_validate_customer
985: FROM qa_customers_lov_v
986: WHERE customer_id = p_customer_id
987: AND status = 'A'
988: AND nvl(customer_prospect_code, 'CUSTOMER') = 'CUSTOMER';
989: