APPS.OE_ORDER_ADJ_PVT dependencies on QP_PREQ_LDETS_TMP

Line 297: From qp_preq_ldets_tmp a,

293: Function Get_List_Lines (p_line_id Number) Return Varchar2 As
294: Cursor list_lines_no is
295: Select c.name,
296: a.list_line_no
297: From qp_preq_ldets_tmp a,
298: qp_preq_lines_tmp b,
299: qp_list_headers_vl c
300: Where b.line_id = p_line_id
301: And b.line_index = a.line_index

Line 12733: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll

12729: ld.pricing_phase_id, ll.override_flag, ld.operand_calculation_code,
12730: ld.ADJUSTMENT_AMOUNT, ll.CHARGE_TYPE_CODE, ll.CHARGE_SUBTYPE_CODE,
12731: l.line_type_code, l.line_id, ld.PRICE_BREAK_TYPE_CODE,
12732: ld.pricing_group_sequence
12733: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll
12734: where l.line_index = ld.line_index
12735: and ld.CREATED_FROM_LIST_LINE_ID = ll.LIST_LINE_ID
12736: and ld.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
12737: ORDER BY ld.list_line_no; -- bug 6323362