APPS.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 207: From qp_preq_ldets_tmp a,

203: Function Get_List_Lines (p_line_id Number) Return Varchar2 As
204: Cursor list_lines_no is
205: Select c.name,
206: a.list_line_no
207: From qp_preq_ldets_tmp a,
208: qp_preq_lines_tmp b,
209: qp_list_headers_vl c
210: Where b.line_id = p_line_id
211: And b.line_index = a.line_index

Line 4726: -- , QP_PREQ_LDETS_TMP LDETS

4722: , qplat.attribute
4723: , qplat.setup_value_from
4724: , qplat.setup_value_to
4725: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4726: -- , QP_PREQ_LDETS_TMP LDETS
4727: -- , OE_PRICE_ADJUSTMENTS ADJ
4728: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4729: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4730: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 5107: , QP_PREQ_LDETS_TMP LDETS

5103: 'QP_ATTR_DEFNS_PRICING')
5104: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5105: ,1
5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ
5109: , QP_PREQ_LINES_TMP QPLINE
5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5111: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 6256: --DELETE FROM QP_PREQ_LDETS_TMP;

6252:
6253: reset_all_tbls;
6254: --DELETE FROM QP_PREQ_LINES_TMP;
6255: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
6256: --DELETE FROM QP_PREQ_LDETS_TMP;
6257: --DELETE FROM QP_PREQ_QUAL_TMP;
6258: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
6259:
6260: G_STMT_NO := 'calculate_adjustments#10';