APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PREQ_LDETS_TMP

Line 3796: FROM QP_PREQ_LDETS_TMP QPLD ,

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

Line 3813: FROM QP_PREQ_LDETS_TMP QPLD ,

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

Line 3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b

3842: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3843: b.proration_type_code, b.include_on_returns_flag,
3844: b.rebate_transaction_type_code, b.number_expiration_periods,
3845: b.expiration_period_uom, b.comments
3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3847: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3848: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3849: AND qpt.created_from_list_line_id = b.list_line_id
3850: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

4760: l_insert_flag varchar2(2);
4761: rs number;
4762: BEGIN
4763: oe_debug_pub.add('entered insert adjustment'||g_manual_modifier_tbl.count);
4764: select count(*) into in_line_detail_index from qp_preq_ldets_tmp;
4765:
4766: for i in g_manual_modifier_tbl.first..g_manual_modifier_tbl.last
4767: Loop
4768: l_insert_flag:='Y';

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

4968: if g_modf_rel_tbl.exists(s) and g_modf_rel_Tbl(s).p_line_id=in_line_id
4969: then
4970:
4971: select line_index,line_detail_index into l_line_index,l_line_detail_index
4972: from qp_preq_ldets_Tmp where created_From_list_line_id=g_modf_rel_tbl(s).line_detail_index;
4973:
4974: select line_index,line_detail_index into rltd_line_index,rltd_line_detail_index from
4975: qp_preq_ldets_tmp where created_from_list_line_id=g_modf_rel_tbl(s).rltd_line_detail_index;
4976:

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

4971: select line_index,line_detail_index into l_line_index,l_line_detail_index
4972: from qp_preq_ldets_Tmp where created_From_list_line_id=g_modf_rel_tbl(s).line_detail_index;
4973:
4974: select line_index,line_detail_index into rltd_line_index,rltd_line_detail_index from
4975: qp_preq_ldets_tmp where created_from_list_line_id=g_modf_rel_tbl(s).rltd_line_detail_index;
4976:
4977: IF l_debug_level >0 then
4978: oe_debug_pub.add('line index'||l_line_index);
4979: oe_debug_pub.add('line detail index'||l_line_detail_index);