APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 3822: QP_PREQ_LINE_ATTRS_TMP QPLAT

3818: QPLAT.VALIDATED_FLAG,
3819: QPLAT.PRICING_STATUS_CODE,
3820: QPLAT.PRICING_STATUS_TEXT
3821: FROM QP_PREQ_LDETS_TMP QPLD ,
3822: QP_PREQ_LINE_ATTRS_TMP QPLAT
3823: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3824: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3825: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3826: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 3839: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING

3835: QPLAT_PRICING.LINE_DETAIL_INDEX,
3836: QPLAT_PRICING.LINE_INDEX,
3837: QPLAT_PRICING.VALIDATED_FLAG
3838: FROM QP_PREQ_LDETS_TMP QPLD ,
3839: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3840: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3841: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3842: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3843: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;

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

4926: 'X',
4927: g_manual_modifier_tbl(i).pricing_phase_id,
4928: g_manual_modifier_tbl(i).modifier_level_code,
4929: 'N');
4930: oe_debug_pub.add('inserted pbh line into qp_preq_line_attrs_tmp');
4931: end if;
4932:
4933: if g_modf_attributes_tbl.count >0 then
4934: for k in g_modf_attributes_tbl.first..g_modf_attributes_tbl.last