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_PRICING_AVAILABILITY dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 3797: QP_PREQ_LINE_ATTRS_TMP QPLAT

3793: QPLAT.VALIDATED_FLAG,
3794: QPLAT.PRICING_STATUS_CODE,
3795: QPLAT.PRICING_STATUS_TEXT
3796: FROM QP_PREQ_LDETS_TMP QPLD ,
3797: QP_PREQ_LINE_ATTRS_TMP QPLAT
3798: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3799: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3800: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3801: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 3814: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING

3810: QPLAT_PRICING.LINE_DETAIL_INDEX,
3811: QPLAT_PRICING.LINE_INDEX,
3812: QPLAT_PRICING.VALIDATED_FLAG
3813: FROM QP_PREQ_LDETS_TMP QPLD ,
3814: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3815: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3816: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3817: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3818: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 4905: oe_debug_pub.add('inserted pbh line into qp_preq_line_attrs_tmp');

4901: 'X',
4902: g_manual_modifier_tbl(i).pricing_phase_id,
4903: g_manual_modifier_tbl(i).modifier_level_code,
4904: 'N');
4905: oe_debug_pub.add('inserted pbh line into qp_preq_line_attrs_tmp');
4906: end if;
4907:
4908: if g_modf_attributes_tbl.count >0 then
4909: for k in g_modf_attributes_tbl.first..g_modf_attributes_tbl.last