APPS.OE_ORDER_ADJ_PVT dependencies on QP_PREQ_LINES_TMP

Line 100: From QP_PREQ_LINES_TMP

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

Line 298: qp_preq_lines_tmp b,

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

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