APPS.OE_ORDER_ADJ_PVT dependencies on QP_PREQ_LINES_TMP

Line 99: From QP_PREQ_LINES_TMP

95: Select Unit_Price,
96: Adjusted_Unit_Price,
97: priced_quantity,
98: priced_uom_code
99: From QP_PREQ_LINES_TMP
100: Where Line_Id = p_line_id;
101:
102: Cursor c_line(p_line_id in Number) is
103: Select line_id,

Line 297: qp_preq_lines_tmp b,

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
301: And a.created_from_list_header_id = c.list_header_id

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