DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 206: From qp_preq_ldets_tmp a,

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

Line 4611: -- , QP_PREQ_LDETS_TMP LDETS

4607: , qplat.attribute
4608: , qplat.setup_value_from
4609: , qplat.setup_value_to
4610: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4611: -- , QP_PREQ_LDETS_TMP LDETS
4612: -- , OE_PRICE_ADJUSTMENTS ADJ
4613: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4614: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4615: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 5973: --DELETE FROM QP_PREQ_LDETS_TMP;

5969:
5970: reset_all_tbls;
5971: --DELETE FROM QP_PREQ_LINES_TMP;
5972: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
5973: --DELETE FROM QP_PREQ_LDETS_TMP;
5974: --DELETE FROM QP_PREQ_QUAL_TMP;
5975: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
5976:
5977: G_STMT_NO := 'calculate_adjustments#10';