APPS.OE_ORDER_ADJ_PVT dependencies on QP_PREQ_LDETS_TMP

Line 296: From qp_preq_ldets_tmp a,

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

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

12574: ld.pricing_phase_id, ll.override_flag, ld.operand_calculation_code,
12575: ld.ADJUSTMENT_AMOUNT, ll.CHARGE_TYPE_CODE, ll.CHARGE_SUBTYPE_CODE,
12576: l.line_type_code, l.line_id, ld.PRICE_BREAK_TYPE_CODE,
12577: ld.pricing_group_sequence
12578: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll
12579: where l.line_index = ld.line_index
12580: and ld.CREATED_FROM_LIST_LINE_ID = ll.LIST_LINE_ID
12581: and ld.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
12582: ORDER BY ld.list_line_no; -- bug 6323362