eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_UTIL_PUB dependencies on QP_PRICING_ATTRIBUTES

Line 2745: QP_PRICING_ATTRIBUTES A,

2741:
2742: CURSOR c_check_qpprc_atr IS
2743: SELECT 'X'
2744: FROM
2745: QP_PRICING_ATTRIBUTES A,
2746: QP_LIST_LINES L,
2747: QP_LIST_HEADERS_B QLH
2748: WHERE
2749: A.LIST_HEADER_ID = P_Price_List_Id AND

Line 2806: QP_PRICING_ATTRIBUTES A,

2802:
2803: CURSOR c_check_qpprc_atr IS
2804: SELECT 'X'
2805: FROM
2806: QP_PRICING_ATTRIBUTES A,
2807: QP_LIST_LINES L,
2808: QP_LIST_HEADERS_B QLH
2809: WHERE
2810: A.LIST_HEADER_ID = P_Price_List_Id AND

Line 2836: FROM qp_pricing_attributes

2832:
2833: /*
2834: CURSOR l_pricing_attribs IS
2835: SELECT distinct pricing_attribute_context, pricing_attribute
2836: FROM qp_pricing_attributes
2837: WHERE product_attribute IN ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3')
2838: AND product_attribute_context = 'ITEM'
2839: AND product_attr_value IN (to_char(P_Inventory_Id),'ALL')
2840: AND ((pricing_attribute_context IS NOT NULL AND pricing_attribute IS NOT NULL )

Line 2849: FROM qp_pricing_attributes

2845: */
2846:
2847: CURSOR l_pricing_attribs IS
2848: SELECT DISTINCT pricing_attribute_context, pricing_attribute
2849: FROM qp_pricing_attributes
2850: WHERE list_header_id = P_Price_List_Id
2851: AND ( product_attribute IN ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3')
2852: AND product_attribute_context = 'ITEM'
2853: AND product_attr_value IN (TO_CHAR(P_Inventory_Id),'ALL')

Line 2859: FROM qp_pricing_attributes

2855: AND (pricing_attribute_context <> 'VOLUME'
2856: AND pricing_attribute NOT IN ('PRICING_ATTRIBUTE10','PRICING_ATTRIBUTE12'))) )
2857: UNION ALL
2858: SELECT DISTINCT pricing_attribute_context, pricing_attribute
2859: FROM qp_pricing_attributes
2860: WHERE list_header_id IN (
2861: SELECT FL.price_modifier_list_id
2862: FROM
2863: QP_PRICING_ATTRIBUTES A,

Line 2863: QP_PRICING_ATTRIBUTES A,

2859: FROM qp_pricing_attributes
2860: WHERE list_header_id IN (
2861: SELECT FL.price_modifier_list_id
2862: FROM
2863: QP_PRICING_ATTRIBUTES A,
2864: QP_LIST_LINES L,
2865: QP_LIST_HEADERS_B QLH,
2866: QP_PRICE_FORMULA_LINES FL
2867: WHERE

Line 2887: QP_PRICING_ATTRIBUTES A,

2883: )
2884: UNION ALL
2885: SELECT DISTINCT FL.pricing_attribute_context, FL.pricing_attribute
2886: FROM
2887: QP_PRICING_ATTRIBUTES A,
2888: QP_LIST_LINES L,
2889: QP_LIST_HEADERS_B QLH,
2890: QP_PRICE_FORMULA_LINES FL
2891: WHERE