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 3025: FROM QP_PREQ_LDETS_TMP QPLD ,

3021: QPLAT.COMPARISON_OPERATOR_TYPE_CODE,
3022: QPLAT.VALIDATED_FLAG,
3023: QPLAT.PRICING_STATUS_CODE,
3024: QPLAT.PRICING_STATUS_TEXT
3025: FROM QP_PREQ_LDETS_TMP QPLD ,
3026: QP_PREQ_LINE_ATTRS_TMP QPLAT
3027: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3028: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3029: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';

Line 3042: FROM QP_PREQ_LDETS_TMP QPLD ,

3038: QPLAT_PRICING.COMPARISON_OPERATOR_TYPE_CODE,
3039: QPLAT_PRICING.LINE_DETAIL_INDEX,
3040: QPLAT_PRICING.LINE_INDEX,
3041: QPLAT_PRICING.VALIDATED_FLAG
3042: FROM QP_PREQ_LDETS_TMP QPLD ,
3043: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3044: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3045: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3046: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');

Line 3112: FROM QP_PREQ_LDETS_TMP a,

3108: b.REBATE_TRANSACTION_TYPE_CODE,
3109: b.NUMBER_EXPIRATION_PERIODS,
3110: b.EXPIRATION_PERIOD_UOM,
3111: b.COMMENTS
3112: FROM QP_PREQ_LDETS_TMP a,
3113: QP_LIST_LINES b
3114: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3115: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3116: