APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 9769: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */

9765: pricing_attr_value_from,
9766: pricing_attr_value_to,
9767: comparison_operator,
9768: flex_title)
9769: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9770: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9771: sysdate
9772: ,fnd_global.user_id
9773: ,sysdate

Line 9789: QP_PREQ_LINE_ATTRS_TMP QPLAT

9785: FROM
9786: ASO_PRICE_ADJUSTMENTS ADJ,
9787: QP_PREQ_LINES_TMP LINES ,
9788: QP_PREQ_LDETS_TMP LDETS,
9789: QP_PREQ_LINE_ATTRS_TMP QPLAT
9790: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9791: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9792: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9793: AND LDETS.LINE_INDEX = LINES.LINE_INDEX

Line 9821: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

9817: pricing_attr_value_from,
9818: pricing_attr_value_to,
9819: comparison_operator,
9820: flex_title)
9821: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9822: sysdate
9823: ,fnd_global.user_id
9824: ,sysdate
9825: ,fnd_global.user_id

Line 9840: QP_PREQ_LINE_ATTRS_TMP QPLAT

9836: FROM
9837: ASO_PRICE_ADJUSTMENTS ADJ,
9838: QP_PREQ_LINES_TMP LINES ,
9839: QP_PREQ_LDETS_TMP LDETS,
9840: QP_PREQ_LINE_ATTRS_TMP QPLAT
9841: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9842: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9843: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9844: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 10088: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

10084: pricing_attr_value_from,
10085: pricing_attr_value_to,
10086: comparison_operator,
10087: flex_title)
10088: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10089: sysdate
10090: ,fnd_global.user_id
10091: ,sysdate
10092: ,fnd_global.user_id

Line 10107: QP_PREQ_LINE_ATTRS_TMP QPLAT

10103: FROM
10104: ASO_PRICE_ADJUSTMENTS ADJ,
10105: QP_PREQ_LINES_TMP LINES ,
10106: QP_PREQ_LDETS_TMP LDETS,
10107: QP_PREQ_LINE_ATTRS_TMP QPLAT
10108: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10109: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10110: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10111: AND LDETS.LINE_INDEX = LINES.LINE_INDEX

Line 10254: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

10250: pricing_attr_value_from,
10251: pricing_attr_value_to,
10252: comparison_operator,
10253: flex_title)
10254: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10255: sysdate
10256: ,fnd_global.user_id
10257: ,sysdate
10258: ,fnd_global.user_id

Line 10273: QP_PREQ_LINE_ATTRS_TMP QPLAT

10269: FROM
10270: ASO_PRICE_ADJUSTMENTS ADJ,
10271: QP_PREQ_LINES_TMP LINES ,
10272: QP_PREQ_LDETS_TMP LDETS,
10273: QP_PREQ_LINE_ATTRS_TMP QPLAT
10274: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10275: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10276: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10277: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 10806: QP_PREQ_LINE_ATTRS_TMP attrs

10802: attrs.ATTRIBUTE ATTRIBUTE,
10803: attrs.CONTEXT CONTEXT,
10804: attrs.VALUE_FROM VALUE_FROM
10805: FROM QP_PREQ_LINES_TMP lines,
10806: QP_PREQ_LINE_ATTRS_TMP attrs
10807: --WHERE lines.PROCESSED_CODE = QP_PREQ_PUB.G_BY_ENGINE
10808: WHERE lines.process_status in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_DELETED)
10809: AND lines.line_index = attrs.line_index
10810: AND attrs.CONTEXT = 'ITEM'

Line 10900: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

10896: QPLAT.COMPARISON_OPERATOR_TYPE_CODE COMPARISON_OPERATOR,
10897: decode(QPLAT.ATTRIBUTE_TYPE,
10898: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10899: 'QP_ATTR_DEFNS_PRICING') FLEX_TITLE
10900: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
10901: WHERE QPLAT.LINE_INDEX = l_line_index
10902: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index;
10903:
10904: CURSOR C_Get_Parent_Adj_id(l_qte_line_id NUMBER, l_modifier_line_id NUMBER) IS