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_PRC_UTIL dependencies on QP_QUALIFIERS

Line 525: FROM QP_QUALIFIERS QPQ

521: AND QPPA.PRODUCT_ATTRIBUTE_CONTEXT IN (G_ITEM_CONTEXT
522: ,G_ITEM_CATEGORY_CONTEXT)
523: UNION
524: SELECT DISTINCT QPQ.QUALIFIER_ATTRIBUTE
525: FROM QP_QUALIFIERS QPQ
526: ,QP_LIST_HEADERS QPLH
527: ,QP_LIST_LINES QPLL
528: WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
529: AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID

Line 745: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ

741: OPEN l_discount_csr FOR
742: SELECT QPH.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPH.NAME,
743: DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
744: '%',NVL(QPL.OPERAND,0))
745: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
746: WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
747: AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
748: AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
749: AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME

Line 760: FROM QP_QUALIFIERS QPQ

756: AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
757: AND DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
758: '%', NVL(QPL.OPERAND,0)) < p_best_adj_percent
759: AND ( NOT EXISTS (SELECT NULL
760: FROM QP_QUALIFIERS QPQ
761: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
762: AND QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
763: AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_CLASS_NAME
764: ,G_SOLD_TO_ORG_NAME

Line 768: FROM QP_QUALIFIERS QPQ

764: ,G_SOLD_TO_ORG_NAME
765: ,G_SITE_ORG_NAME))
766: OR
767: ( EXISTS(SELECT NULL
768: FROM QP_QUALIFIERS QPQ
769: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
770: AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
771: AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
772: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))

Line 774: FROM QP_QUALIFIERS QPQ

770: AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
771: AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
772: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))
773: OR EXISTS(SELECT NULL
774: FROM QP_QUALIFIERS QPQ
775: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
776: AND (qpq.qualifier_context = G_CUSTOMER_CLASS_CONTEXT
777: AND QPQ.QUALIFIER_ATTRIBUTE = G_CUSTOMER_CLASS_NAME
778: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_customer_class_code) =

Line 781: FROM QP_QUALIFIERS QPQ

777: AND QPQ.QUALIFIER_ATTRIBUTE = G_CUSTOMER_CLASS_NAME
778: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_customer_class_code) =
779: p_customer_class_code))
780: AND EXISTS(SELECT NULL
781: FROM QP_QUALIFIERS QPQ
782: WHERE (QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
783: AND QPQ.QUALIFIER_ATTRIBUTE = G_SITE_ORG_NAME
784: AND (NVL(QPQ.QUALIFIER_ATTR_VALUE,p_ship_to_id) = p_ship_to_id
785: OR NVL(QPQ.QUALIFIER_ATTR_VALUE,p_invoice_to_id) = p_invoice_to_id)))))

Line 813: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ

809: OPEN l_discount_csr FOR
810: SELECT QPH.LIST_HEADER_ID,QPL.LIST_LINE_ID, QPH.NAME,
811: DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
812: '%',NVL(QPL.OPERAND,0))
813: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
814: WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
815: AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
816: AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
817: AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME

Line 828: FROM QP_QUALIFIERS QPQ

824: AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
825: AND DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
826: '%', NVL(QPL.OPERAND,0)) > p_best_adj_percent
827: AND ( NOT EXISTS (SELECT NULL
828: FROM QP_QUALIFIERS QPQ
829: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
830: AND QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
831: AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_CLASS_NAME
832: ,G_SOLD_TO_ORG_NAME

Line 836: FROM QP_QUALIFIERS QPQ

832: ,G_SOLD_TO_ORG_NAME
833: ,G_SITE_ORG_NAME))
834: OR
835: ( EXISTS(SELECT NULL
836: FROM QP_QUALIFIERS QPQ
837: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
838: AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
839: AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
840: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))

Line 842: FROM QP_QUALIFIERS QPQ

838: AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
839: AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
840: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))
841: AND EXISTS(SELECT NULL
842: FROM QP_QUALIFIERS QPQ
843: WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
844: AND (qpq.qualifier_context = G_CUSTOMER_CLASS_CONTEXT
845: AND QPQ.QUALIFIER_ATTRIBUTE = G_CUSTOMER_CLASS_NAME
846: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,

Line 850: FROM QP_QUALIFIERS QPQ

846: AND NVL(QPQ.QUALIFIER_ATTR_VALUE,
847: NVL(p_customer_class_code,'NULL')) =
848: NVL(p_customer_class_code,'NULL') ))
849: AND EXISTS(SELECT NULL
850: FROM QP_QUALIFIERS QPQ
851: WHERE QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
852: AND QPQ.QUALIFIER_ATTRIBUTE = G_SITE_ORG_NAME
853: AND (NVL(QPQ.QUALIFIER_ATTR_VALUE,p_ship_to_id) = p_ship_to_id
854: OR NVL(QPQ.QUALIFIER_ATTR_VALUE,p_invoice_to_id) = p_invoice_to_id