APPS.OE_ADV_PRICE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 659: from qp_preq_ldets_tmp where

655: CREATED_FROM_LIST_TYPE_CODE,SUBSTITUTION_TYPE_CODE,
656: SUBSTITUTION_VALUE_FROM,SUBSTITUTION_VALUE_TO,PROCESSED_FLAG,
657: PRICING_STATUS_CODE,PRICING_PHASE_ID,APPLIED_FLAG,PROCESS_CODE,
658: UPDATED_FLAG
659: from qp_preq_ldets_tmp where
660: CREATED_FROM_LIST_LINE_TYPE = 'TSN';
661: Cursor test is
662: select Line_index,substitution_attribute,substitution_value_to,
663: process_code

Line 2229: qp_preq_ldets_tmp ldets

2225: select 1 into l_source_system_code from
2226: oe_order_headers_all oh,
2227: qp_list_headers qh,
2228: -- qp_preq_lines_tmp lines,
2229: qp_preq_ldets_tmp ldets
2230: where qh.currency_code = oh.transactional_curr_code
2231: and oh.header_id = l_header_id
2232: -- and lines.line_index = ldets.line_index
2233: and ldets.CREATED_FROM_LIST_HEADER_ID = qh.LIST_HEADER_ID

Line 2950: QP_PREQ_LDETS_TMP LDET,

2946: ,RLDET.PRICE_ADJUSTMENT_ID
2947: ,1
2948: FROM
2949: QP_PREQ_RLTD_LINES_TMP RLTD,
2950: QP_PREQ_LDETS_TMP LDET,
2951: QP_PREQ_LDETS_TMP RLDET,
2952: QP_PREQ_LINES_TMP RLINE
2953: WHERE
2954: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND

Line 2951: QP_PREQ_LDETS_TMP RLDET,

2947: ,1
2948: FROM
2949: QP_PREQ_RLTD_LINES_TMP RLTD,
2950: QP_PREQ_LDETS_TMP LDET,
2951: QP_PREQ_LDETS_TMP RLDET,
2952: QP_PREQ_LINES_TMP RLINE
2953: WHERE
2954: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
2955: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND