DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_PRICE_FORMULA_LINES

Line 3087: FROM QP_PRICE_FORMULA_LINES FL

3083: A.PRICING_PHASE_ID = 1 AND
3084: A.QUALIFICATION_IND IN (4,6,20,22) AND
3085: A.EXCLUDER_FLAG = 'N' AND
3086: (EXISTS (SELECT NULL
3087: FROM QP_PRICE_FORMULA_LINES FL
3088: WHERE FL.PRICE_FORMULA_LINE_TYPE_CODE IN ('PRA','ML') AND
3089: FL.PRICE_FORMULA_ID = L.PRICE_BY_FORMULA_ID)
3090: OR
3091: (A.PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')) AND

Line 3148: FROM QP_PRICE_FORMULA_LINES FL

3144: A.PRICING_PHASE_ID = 1 AND
3145: A.QUALIFICATION_IND IN (4,6,20,22) AND
3146: A.EXCLUDER_FLAG = 'N' AND
3147: (EXISTS (SELECT NULL
3148: FROM QP_PRICE_FORMULA_LINES FL
3149: WHERE FL.PRICE_FORMULA_LINE_TYPE_CODE IN ('PRA','ML') AND
3150: FL.PRICE_FORMULA_ID = L.PRICE_BY_FORMULA_ID)
3151: OR
3152: (A.PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')) AND

Line 3196: QP_PRICE_FORMULA_LINES FL

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
3198: A.LIST_HEADER_ID = P_Price_List_Id AND
3199: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
3200: A.PRODUCT_ATTRIBUTE IN ( 'PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3' ) AND

Line 3220: QP_PRICE_FORMULA_LINES FL

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
3222: A.LIST_HEADER_ID = P_Price_List_Id AND
3223: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
3224: A.PRODUCT_ATTRIBUTE IN ( 'PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3' ) AND