APPS.ASO_VALIDATE_PVT dependencies on QP_LIST_LINES

Line 4418: FROM qp_list_lines

4414: adj_rec_exists VARCHAR2(1):= 'N';
4415:
4416: Cursor C_get_list_lines(p_list_header_id NUMBER) IS
4417: SELECT list_line_id
4418: FROM qp_list_lines
4419: WHERE list_header_id = p_list_header_id;
4420:
4421: Cursor C_get_list_header(p_list_line_id NUMBER) IS
4422: SELECT list_header_id

Line 4423: FROM qp_list_lines

4419: WHERE list_header_id = p_list_header_id;
4420:
4421: Cursor C_get_list_header(p_list_line_id NUMBER) IS
4422: SELECT list_header_id
4423: FROM qp_list_lines
4424: WHERE list_line_id = p_list_line_id;
4425:
4426: Cursor C_get_attr(p_quote_header_id NUMBER,
4427: p_quote_line_id NUMBER,

Line 4445: FROM qp_list_lines qpe

4441: FROM aso_price_attributes
4442: WHERE quote_header_id = p_quote_header_id
4443: AND nvl(quote_line_id,0) = nvl(decode(p_quote_line_id,FND_API.G_MISS_NUM,null,p_quote_line_id),0)
4444: AND pricing_attribute1 IN ( SELECT to_char(qpe.list_header_id)
4445: FROM qp_list_lines qpe
4446: WHERE qpe.list_line_id = p_list_line_id);
4447:
4448: Cursor C_get_attr2(p_quote_header_id NUMBER,
4449: p_quote_line_id NUMBER,

Line 4462: FROM qp_list_lines qpe

4458: p_pricing_attribute2 IS NOT NULL
4459: )
4460: OR ( p_pricing_attribute2 IS NULL
4461: AND pricing_attribute2 IN ( SELECT to_char(qpe.list_line_id)
4462: FROM qp_list_lines qpe
4463: WHERE qpe.list_header_id = p_list_header_id)
4464: )
4465: );
4466:

Line 4481: FROM qp_list_lines qpe

4477: AND quote_header_id = p_quote_header_id
4478: AND nvl(quote_line_id,0) = nvl(p_quote_line_id,0)
4479: AND pricing_attribute1 IS NULL
4480: AND nvl(pricing_attribute2,'Y') IN ( SELECT qpe.list_line_id
4481: FROM qp_list_lines qpe
4482: WHERE qpe.list_header_id = qp.list_header_id)
4483: )
4484: */
4485: