APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PREQ_LDETS_TMP

Line 3821: FROM QP_PREQ_LDETS_TMP QPLD ,

3817: QPLAT.COMPARISON_OPERATOR_TYPE_CODE,
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';

Line 3838: FROM QP_PREQ_LDETS_TMP QPLD ,

3834: QPLAT_PRICING.COMPARISON_OPERATOR_TYPE_CODE,
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');

Line 3871: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b

3867: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3868: b.proration_type_code, b.include_on_returns_flag,
3869: b.rebate_transaction_type_code, b.number_expiration_periods,
3870: b.expiration_period_uom, b.comments
3871: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3872: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3873: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3874: AND qpt.created_from_list_line_id = b.list_line_id
3875: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 4789: select count(*) into in_line_detail_index from qp_preq_ldets_tmp;

4785: l_insert_flag varchar2(2);
4786: rs number;
4787: BEGIN
4788: oe_debug_pub.add('entered insert adjustment'||g_manual_modifier_tbl.count);
4789: select count(*) into in_line_detail_index from qp_preq_ldets_tmp;
4790:
4791: for i in g_manual_modifier_tbl.first..g_manual_modifier_tbl.last
4792: Loop
4793: l_insert_flag:='Y';

Line 4997: from qp_preq_ldets_Tmp where created_From_list_line_id=g_modf_rel_tbl(s).line_detail_index;

4993: if g_modf_rel_tbl.exists(s) and g_modf_rel_Tbl(s).p_line_id=in_line_id
4994: then
4995:
4996: select line_index,line_detail_index into l_line_index,l_line_detail_index
4997: from qp_preq_ldets_Tmp where created_From_list_line_id=g_modf_rel_tbl(s).line_detail_index;
4998:
4999: select line_index,line_detail_index into rltd_line_index,rltd_line_detail_index from
5000: qp_preq_ldets_tmp where created_from_list_line_id=g_modf_rel_tbl(s).rltd_line_detail_index;
5001:

Line 5000: qp_preq_ldets_tmp where created_from_list_line_id=g_modf_rel_tbl(s).rltd_line_detail_index;

4996: select line_index,line_detail_index into l_line_index,l_line_detail_index
4997: from qp_preq_ldets_Tmp where created_From_list_line_id=g_modf_rel_tbl(s).line_detail_index;
4998:
4999: select line_index,line_detail_index into rltd_line_index,rltd_line_detail_index from
5000: qp_preq_ldets_tmp where created_from_list_line_id=g_modf_rel_tbl(s).rltd_line_detail_index;
5001:
5002: IF l_debug_level >0 then
5003: oe_debug_pub.add('line index'||l_line_index);
5004: oe_debug_pub.add('line detail index'||l_line_detail_index);