DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_PRICE_FORMULA_LINES

Line 2757: FROM QP_PRICE_FORMULA_LINES FL

2753: A.PRICING_PHASE_ID = 1 AND
2754: A.QUALIFICATION_IND IN (4,6,20,22) AND
2755: A.EXCLUDER_FLAG = 'N' AND
2756: (EXISTS (SELECT NULL
2757: FROM QP_PRICE_FORMULA_LINES FL
2758: WHERE FL.PRICE_FORMULA_LINE_TYPE_CODE IN ('PRA','ML') AND
2759: FL.PRICE_FORMULA_ID = L.PRICE_BY_FORMULA_ID)
2760: OR
2761: (A.PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')) AND

Line 2818: FROM QP_PRICE_FORMULA_LINES FL

2814: A.PRICING_PHASE_ID = 1 AND
2815: A.QUALIFICATION_IND IN (4,6,20,22) AND
2816: A.EXCLUDER_FLAG = 'N' AND
2817: (EXISTS (SELECT NULL
2818: FROM QP_PRICE_FORMULA_LINES FL
2819: WHERE FL.PRICE_FORMULA_LINE_TYPE_CODE IN ('PRA','ML') AND
2820: FL.PRICE_FORMULA_ID = L.PRICE_BY_FORMULA_ID)
2821: OR
2822: (A.PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')) AND

Line 2866: QP_PRICE_FORMULA_LINES FL

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

Line 2890: QP_PRICE_FORMULA_LINES FL

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