DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on QP_PREQ_LDETS_TMP

Line 436: QP_PREQ_LDETS_TMP LDET,

432: ,RLDET.PRICE_ADJUSTMENT_ID
433: ,1
434: FROM
435: QP_PREQ_RLTD_LINES_TMP RLTD,
436: QP_PREQ_LDETS_TMP LDET,
437: QP_PREQ_LDETS_TMP RLDET
438: WHERE
439: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
440: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND

Line 437: QP_PREQ_LDETS_TMP RLDET

433: ,1
434: FROM
435: QP_PREQ_RLTD_LINES_TMP RLTD,
436: QP_PREQ_LDETS_TMP LDET,
437: QP_PREQ_LDETS_TMP RLDET
438: WHERE
439: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
440: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND
441: LDET.PRICING_STATUS_CODE = 'N' AND

Line 856: From qp_preq_ldets_tmp a,

852: Function Get_List_Lines (p_line_id Number) Return Varchar2 As
853: Cursor list_lines_no is
854: Select c.name,
855: a.list_line_no
856: From qp_preq_ldets_tmp a,
857: qp_preq_lines_tmp b,
858: qp_list_headers_vl c
859: Where b.line_id = p_line_id
860: And b.line_index = a.line_index