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.OE_OE_AVAILABILITY dependencies on QP_PREQ_LDETS_TMP

Line 3030: FROM QP_PREQ_LDETS_TMP QPLD ,

3026: QPLAT.COMPARISON_OPERATOR_TYPE_CODE,
3027: QPLAT.VALIDATED_FLAG,
3028: QPLAT.PRICING_STATUS_CODE,
3029: QPLAT.PRICING_STATUS_TEXT
3030: FROM QP_PREQ_LDETS_TMP QPLD ,
3031: QP_PREQ_LINE_ATTRS_TMP QPLAT
3032: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3033: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3034: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';

Line 3047: FROM QP_PREQ_LDETS_TMP QPLD ,

3043: QPLAT_PRICING.COMPARISON_OPERATOR_TYPE_CODE,
3044: QPLAT_PRICING.LINE_DETAIL_INDEX,
3045: QPLAT_PRICING.LINE_INDEX,
3046: QPLAT_PRICING.VALIDATED_FLAG
3047: FROM QP_PREQ_LDETS_TMP QPLD ,
3048: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3049: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3050: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3051: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');

Line 3117: FROM QP_PREQ_LDETS_TMP a,

3113: b.REBATE_TRANSACTION_TYPE_CODE,
3114: b.NUMBER_EXPIRATION_PERIODS,
3115: b.EXPIRATION_PERIOD_UOM,
3116: b.COMMENTS
3117: FROM QP_PREQ_LDETS_TMP a,
3118: QP_LIST_LINES b
3119: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3120: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3121: