11i And 12i Customer Wise Sales Order Price List

/* Customer Wise Sales Order Price List Query OR Sales Order Wise Price List Query And Table Name*/

Select

Ql.OPERAND Price

, Ql.list_header_id /* Order Header Id Match Oe_orders_header_all and show Order Number */

From

Apps.Qp_List_lines Ql /* All types of modifiers including price modifier list lines used to derive factors. The different types of list lines are based on Look-up Type */

, Apps.Qp_pricing_attributes Qt

Where Qt.List_line_id = Ql.list_line_id

And Ql.LIST_HEADER_ID in (Select PRICE_LIST_ID

From JA_IN_CUSTOMER_ADDRESSES Ca --11i

/*12i Table JAI_CMN_CUS_ADDRESSES ,

Holds the Additional Customer information such as excise and sales tax registration numbers*/

Where Ca.CUSTOMER_ID = Ca.CUSTOMER_ID

Group by PRICE_LIST_ID)