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 3075: QP_PRICING_ATTRIBUTES A,

3071:
3072: CURSOR c_check_qpprc_atr IS
3073: SELECT 'X'
3074: FROM
3075: QP_PRICING_ATTRIBUTES A,
3076: QP_LIST_LINES L,
3077: QP_LIST_HEADERS_B QLH
3078: WHERE
3079: A.LIST_HEADER_ID = P_Price_List_Id AND

Line 3136: QP_PRICING_ATTRIBUTES A,

3132:
3133: CURSOR c_check_qpprc_atr IS
3134: SELECT 'X'
3135: FROM
3136: QP_PRICING_ATTRIBUTES A,
3137: QP_LIST_LINES L,
3138: QP_LIST_HEADERS_B QLH
3139: WHERE
3140: A.LIST_HEADER_ID = P_Price_List_Id AND

Line 3166: FROM qp_pricing_attributes

3162:
3163: /*
3164: CURSOR l_pricing_attribs IS
3165: SELECT distinct pricing_attribute_context, pricing_attribute
3166: FROM qp_pricing_attributes
3167: WHERE product_attribute IN ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3')
3168: AND product_attribute_context = 'ITEM'
3169: AND product_attr_value IN (to_char(P_Inventory_Id),'ALL')
3170: AND ((pricing_attribute_context IS NOT NULL AND pricing_attribute IS NOT NULL )

Line 3179: FROM qp_pricing_attributes

3175: */
3176:
3177: CURSOR l_pricing_attribs IS
3178: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3179: FROM qp_pricing_attributes
3180: WHERE list_header_id = P_Price_List_Id
3181: AND ( product_attribute IN ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3')
3182: AND product_attribute_context = 'ITEM'
3183: AND product_attr_value IN (TO_CHAR(P_Inventory_Id),'ALL')

Line 3189: FROM qp_pricing_attributes

3185: AND (pricing_attribute_context <> 'VOLUME'
3186: AND pricing_attribute NOT IN ('PRICING_ATTRIBUTE10','PRICING_ATTRIBUTE12'))) )
3187: UNION ALL
3188: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3189: FROM qp_pricing_attributes
3190: WHERE list_header_id IN (
3191: SELECT FL.price_modifier_list_id
3192: FROM
3193: QP_PRICING_ATTRIBUTES A,

Line 3193: QP_PRICING_ATTRIBUTES A,

3189: FROM qp_pricing_attributes
3190: WHERE list_header_id IN (
3191: SELECT FL.price_modifier_list_id
3192: FROM
3193: QP_PRICING_ATTRIBUTES A,
3194: QP_LIST_LINES L,
3195: QP_LIST_HEADERS_B QLH,
3196: QP_PRICE_FORMULA_LINES FL
3197: WHERE

Line 3217: QP_PRICING_ATTRIBUTES A,

3213: )
3214: UNION ALL
3215: SELECT DISTINCT FL.pricing_attribute_context, FL.pricing_attribute
3216: FROM
3217: QP_PRICING_ATTRIBUTES A,
3218: QP_LIST_LINES L,
3219: QP_LIST_HEADERS_B QLH,
3220: QP_PRICE_FORMULA_LINES FL
3221: WHERE