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 1416: qa_customers_lov_v rc

1412: CURSOR C(v VARCHAR2) IS
1413: SELECT sh.header_id
1414: FROM so_order_types sot,
1415: oe_order_headers sh,
1416: qa_customers_lov_v rc
1417: WHERE sh.order_type_id = sot.order_type_id and
1418: sh.sold_to_org_id = rc.customer_id and
1419: sh.order_category_code in ('RETURN', 'MIXED') and
1420: sh.order_number = v;

Line 2891: FROM qa_customers_lov_v

2887: -- After Single Scan LOV
2888: wild := value;
2889:
2890: sql_string := 'SELECT customer_name, customer_number
2891: FROM qa_customers_lov_v
2892: WHERE customer_name like :1
2893: AND status = ''A''
2894: AND nvl(customer_prospect_code, ''CUSTOMER'') =
2895: ''CUSTOMER''

Line 3145: qa_customers_lov_v rc

3141:
3142: sql_string := 'SELECT sh.order_number, sot.name
3143: FROM so_order_types sot,
3144: oe_order_headers sh,
3145: qa_customers_lov_v rc
3146: WHERE sh.order_type_id = sot.order_type_id and
3147: sh.sold_to_org_id = rc.customer_id and
3148: sh.order_category_code in (''RETURN'', ''MIXED'') and
3149: sh.order_number like :1

Line 5107: FROM qa_customers_lov_v

5103: x_customer_name OUT NOCOPY VARCHAR2) IS
5104:
5105: CURSOR c IS
5106: SELECT customer_name
5107: FROM qa_customers_lov_v
5108: WHERE customer_id =
5109: ( SELECT customer_id
5110: FROM qa_specs
5111: WHERE spec_id = p_spec_id );