APPS.OE_ADV_PRICE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 590: from qp_preq_ldets_tmp where

586: CREATED_FROM_LIST_TYPE_CODE,SUBSTITUTION_TYPE_CODE,
587: SUBSTITUTION_VALUE_FROM,SUBSTITUTION_VALUE_TO,PROCESSED_FLAG,
588: PRICING_STATUS_CODE,PRICING_PHASE_ID,APPLIED_FLAG,PROCESS_CODE,
589: UPDATED_FLAG
590: from qp_preq_ldets_tmp where
591: CREATED_FROM_LIST_LINE_TYPE = 'TSN';
592: Cursor test is
593: select Line_index,substitution_attribute,substitution_value_to,
594: process_code

Line 1802: qp_preq_ldets_tmp ldets

1798: select 1 into l_source_system_code from
1799: oe_order_headers_all oh,
1800: qp_list_headers qh,
1801: -- qp_preq_lines_tmp lines,
1802: qp_preq_ldets_tmp ldets
1803: where qh.currency_code = oh.transactional_curr_code
1804: and oh.header_id = l_header_id
1805: -- and lines.line_index = ldets.line_index
1806: and ldets.CREATED_FROM_LIST_HEADER_ID = qh.LIST_HEADER_ID

Line 2477: QP_PREQ_LDETS_TMP LDET,

2473: ,RLDET.PRICE_ADJUSTMENT_ID
2474: ,1
2475: FROM
2476: QP_PREQ_RLTD_LINES_TMP RLTD,
2477: QP_PREQ_LDETS_TMP LDET,
2478: QP_PREQ_LDETS_TMP RLDET,
2479: QP_PREQ_LINES_TMP RLINE
2480: WHERE
2481: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND

Line 2478: QP_PREQ_LDETS_TMP RLDET,

2474: ,1
2475: FROM
2476: QP_PREQ_RLTD_LINES_TMP RLTD,
2477: QP_PREQ_LDETS_TMP LDET,
2478: QP_PREQ_LDETS_TMP RLDET,
2479: QP_PREQ_LINES_TMP RLINE
2480: WHERE
2481: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
2482: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND