APPS.QA_PLAN_ELEMENT_API dependencies on QA_CUSTOMERS_LOV_V

Line 1197: FROM qa_customers_lov_v

1193: id NUMBER;
1194:
1195: CURSOR c (c_name VARCHAR2) IS
1196: SELECT customer_id
1197: FROM qa_customers_lov_v
1198: WHERE status = 'A'
1199: AND customer_name = c_name
1200: AND nvl(customer_prospect_code, 'CUSTOMER') = 'CUSTOMER';
1201:

Line 1397: qa_customers_lov_v rc

1393: CURSOR C(v VARCHAR2) IS
1394: SELECT sh.header_id
1395: FROM so_order_types sot,
1396: oe_order_headers sh,
1397: qa_customers_lov_v rc
1398: WHERE sh.order_type_id = sot.order_type_id and
1399: sh.sold_to_org_id = rc.customer_id and
1400: sh.order_category_code in ('RETURN', 'MIXED') and
1401: sh.order_number = v;

Line 2856: FROM qa_customers_lov_v

2852: -- After Single Scan LOV
2853: wild := value;
2854:
2855: sql_string := 'SELECT customer_name, customer_number
2856: FROM qa_customers_lov_v
2857: WHERE customer_name like :1
2858: AND status = ''A''
2859: AND nvl(customer_prospect_code, ''CUSTOMER'') =
2860: ''CUSTOMER''

Line 3053: qa_customers_lov_v rc

3049:
3050: sql_string := 'SELECT sh.order_number, sot.name
3051: FROM so_order_types sot,
3052: oe_order_headers sh,
3053: qa_customers_lov_v rc
3054: WHERE sh.order_type_id = sot.order_type_id and
3055: sh.sold_to_org_id = rc.customer_id and
3056: sh.order_category_code in (''RETURN'', ''MIXED'') and
3057: sh.order_number like :1

Line 4909: FROM qa_customers_lov_v

4905: x_customer_name OUT NOCOPY VARCHAR2) IS
4906:
4907: CURSOR c IS
4908: SELECT customer_name
4909: FROM qa_customers_lov_v
4910: WHERE customer_id =
4911: ( SELECT customer_id
4912: FROM qa_specs
4913: WHERE spec_id = p_spec_id );