[Home] [Help]
9748: pricing_attr_value_from,
9749: pricing_attr_value_to,
9750: comparison_operator,
9751: flex_title)
9752: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9753: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9754: sysdate
9755: ,fnd_global.user_id
9756: ,sysdate
9768: FROM
9769: ASO_PRICE_ADJUSTMENTS ADJ,
9770: QP_PREQ_LINES_TMP LINES ,
9771: QP_PREQ_LDETS_TMP LDETS,
9772: QP_PREQ_LINE_ATTRS_TMP QPLAT
9773: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9774: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9775: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9776: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9800: pricing_attr_value_from,
9801: pricing_attr_value_to,
9802: comparison_operator,
9803: flex_title)
9804: (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,
9805: sysdate
9806: ,fnd_global.user_id
9807: ,sysdate
9808: ,fnd_global.user_id
9819: FROM
9820: ASO_PRICE_ADJUSTMENTS ADJ,
9821: QP_PREQ_LINES_TMP LINES ,
9822: QP_PREQ_LDETS_TMP LDETS,
9823: QP_PREQ_LINE_ATTRS_TMP QPLAT
9824: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9825: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9826: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9827: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10067: pricing_attr_value_from,
10068: pricing_attr_value_to,
10069: comparison_operator,
10070: flex_title)
10071: (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,
10072: sysdate
10073: ,fnd_global.user_id
10074: ,sysdate
10075: ,fnd_global.user_id
10086: FROM
10087: ASO_PRICE_ADJUSTMENTS ADJ,
10088: QP_PREQ_LINES_TMP LINES ,
10089: QP_PREQ_LDETS_TMP LDETS,
10090: QP_PREQ_LINE_ATTRS_TMP QPLAT
10091: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10092: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10093: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10094: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10233: pricing_attr_value_from,
10234: pricing_attr_value_to,
10235: comparison_operator,
10236: flex_title)
10237: (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,
10238: sysdate
10239: ,fnd_global.user_id
10240: ,sysdate
10241: ,fnd_global.user_id
10252: FROM
10253: ASO_PRICE_ADJUSTMENTS ADJ,
10254: QP_PREQ_LINES_TMP LINES ,
10255: QP_PREQ_LDETS_TMP LDETS,
10256: QP_PREQ_LINE_ATTRS_TMP QPLAT
10257: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10258: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10259: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10260: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10785: attrs.ATTRIBUTE ATTRIBUTE,
10786: attrs.CONTEXT CONTEXT,
10787: attrs.VALUE_FROM VALUE_FROM
10788: FROM QP_PREQ_LINES_TMP lines,
10789: QP_PREQ_LINE_ATTRS_TMP attrs
10790: --WHERE lines.PROCESSED_CODE = QP_PREQ_PUB.G_BY_ENGINE
10791: WHERE lines.process_status in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_DELETED)
10792: AND lines.line_index = attrs.line_index
10793: AND attrs.CONTEXT = 'ITEM'
10879: QPLAT.COMPARISON_OPERATOR_TYPE_CODE COMPARISON_OPERATOR,
10880: decode(QPLAT.ATTRIBUTE_TYPE,
10881: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10882: 'QP_ATTR_DEFNS_PRICING') FLEX_TITLE
10883: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
10884: WHERE QPLAT.LINE_INDEX = l_line_index
10885: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index;
10886:
10887: CURSOR C_Get_Parent_Adj_id(l_qte_line_id NUMBER, l_modifier_line_id NUMBER) IS