DBA Data[Home] [Help]

APPS.OZF_OM_PAYMENT_PVT dependencies on QP_LIST_LINES

Line 467: FROM qp_list_lines ql

463: CURSOR csr_qp_list_price( cv_item_id IN NUMBER
464: , cv_price_list_id IN NUMBER
465: ) IS
466: SELECT ql.list_price
467: FROM qp_list_lines ql
468: , qp_pricing_attributes atr
469: WHERE ql.list_line_id = atr.list_line_id
470: AND atr.product_attribute_context = 'ITEM'
471: AND atr.product_attribute = 'PRICING_ATTRIBUTE1'

Line 488: FROM qp_list_lines

484: WHERE line_id = cv_line_id;
485:
486: CURSOR csr_modifier(cv_list_line_id IN NUMBER) IS
487: SELECT list_header_id
488: FROM qp_list_lines
489: WHERE list_line_id = cv_list_line_id;
490:
491: CURSOR csr_order_source(cv_order_source_id IN NUMBER) IS
492: SELECT order_source_id