eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 6603: UPDATE ASO_PRICE_ADJUSTMENTS apa

6599: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6600: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside of the Query_Price_Adj_All',1,'Y');
6601: END IF;
6602:
6603: UPDATE ASO_PRICE_ADJUSTMENTS apa
6604: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6605: 'LUMPSUM',operand,
6606: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6607: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)

Line 6620: UPDATE ASO_PRICE_ADJUSTMENTS

6616: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Operand per pqty updated rows - Line level: '||sql%ROWCOUNT,1,'Y');
6617: END IF;
6618:
6619: --Only support % at the header level
6620: UPDATE ASO_PRICE_ADJUSTMENTS
6621: SET OPERAND_PER_PQTY = operand
6622: WHERE quote_header_id = p_quote_header_id
6623: AND quote_line_id is null
6624: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 6744: FROM ASO_PRICE_ADJUSTMENTS adj

6740: G_LDET_UPDATED_FLAG_TBL,
6741: G_LDET_CALC_CODE_TBL,
6742: G_LDET_CHG_REASON_CODE_TBL,
6743: G_LDET_CHG_REASON_TEXT_TBL
6744: FROM ASO_PRICE_ADJUSTMENTS adj
6745: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
6746: AND (NVL(adj.updated_flag,'N') = 'Y' OR nvl(adj.automatic_flag,'N') = 'Y');
6747:
6748: x_adj_id_tbl := l_adj_id_tbl;

Line 6767: UPDATE ASO_PRICE_ADJUSTMENTS

6763: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Price_Adj_Header',1,'Y');
6764: END IF;
6765:
6766: --Only support % at the header level
6767: UPDATE ASO_PRICE_ADJUSTMENTS
6768: SET OPERAND_PER_PQTY = operand
6769: WHERE quote_header_id = p_quote_header_id
6770: AND quote_line_id is null
6771: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 6889: FROM ASO_PRICE_ADJUSTMENTS adj

6885: G_LDET_UPDATED_FLAG_TBL,
6886: G_LDET_CALC_CODE_TBL,
6887: G_LDET_CHG_REASON_CODE_TBL,
6888: G_LDET_CHG_REASON_TEXT_TBL
6889: FROM ASO_PRICE_ADJUSTMENTS adj
6890: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
6891: AND adj.QUOTE_LINE_ID IS NULL
6892: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N'
6893: AND NVL(updated_flag,'N') = 'Y';

Line 6913: UPDATE ASO_PRICE_ADJUSTMENTS apa

6909: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6910: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adj_line',1,'Y');
6911: END IF;
6912:
6913: UPDATE ASO_PRICE_ADJUSTMENTS apa
6914: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6915: 'LUMPSUM',operand,
6916: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6917: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)

Line 7052: FROM ASO_PRICE_ADJUSTMENTS adj,

7048: G_LDET_UPDATED_FLAG_TBL,
7049: G_LDET_CALC_CODE_TBL,
7050: G_LDET_CHG_REASON_CODE_TBL,
7051: G_LDET_CHG_REASON_TEXT_TBL
7052: FROM ASO_PRICE_ADJUSTMENTS adj,
7053: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7054: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7055: AND adj.QUOTE_LINE_ID = Lines.column_value
7056: AND adj.QUOTE_LINE_ID IS NOT NULL

Line 7062: FROM ASO_PRICE_ADJUSTMENTS adj2,

7058:
7059: --We won't need this since in the second implicit call the only Adj record for free line
7060: --is the PRG related DIS record.
7061: /*AND EXISTS ( SELECT null
7062: FROM ASO_PRICE_ADJUSTMENTS adj2,
7063: ASO_PRICE_ADJ_RELATIONSHIPS rlt
7064: WHERE rlt.rltd_price_adj_id = adj.price_adjustment_id
7065: AND adj2.modifier_line_type_code = 'PRG'
7066: AND adj2.quote_header_id = adj.quote_header_id

Line 7092: UPDATE ASO_PRICE_ADJUSTMENTS apa

7088: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adjustments',1,'Y');
7089: END IF;
7090: --bug8599987 changed to operand from 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY
7091: --bug8599987 changed to operand from 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)
7092: UPDATE ASO_PRICE_ADJUSTMENTS apa
7093: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
7094: 'LUMPSUM',operand,
7095: 'AMT',operand,
7096: 'NEWPRICE',operand)

Line 7109: UPDATE ASO_PRICE_ADJUSTMENTS

7105: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Operand per pqty updated rows - Line level: '||sql%ROWCOUNT,1,'Y');
7106: END IF;
7107:
7108: --Only support % at the header level
7109: UPDATE ASO_PRICE_ADJUSTMENTS
7110: SET OPERAND_PER_PQTY = operand
7111: WHERE quote_header_id = p_quote_header_id
7112: AND quote_line_id is null
7113: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 7239: FROM ASO_PRICE_ADJUSTMENTS adj

7235: G_LDET_UPDATED_FLAG_TBL,
7236: G_LDET_CALC_CODE_TBL,
7237: G_LDET_CHG_REASON_CODE_TBL,
7238: G_LDET_CHG_REASON_TEXT_TBL
7239: FROM ASO_PRICE_ADJUSTMENTS adj
7240: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7241: AND NVL(adj.updated_flag,'N') = 'Y'
7242: AND adj.QUOTE_LINE_ID IS NULL
7243: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N'

Line 7302: FROM ASO_PRICE_ADJUSTMENTS adj,

7298: UPDATED_FLAG,
7299: MODIFIER_MECHANISM_TYPE_CODE,
7300: CHANGE_REASON_CODE,
7301: CHANGE_REASON_TEXT
7302: FROM ASO_PRICE_ADJUSTMENTS adj,
7303: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7304: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7305: AND adj.QUOTE_LINE_ID = Lines.column_value
7306: AND adj.QUOTE_LINE_ID IS NOT NULL

Line 7314: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,

7310: AND nvl(lines2.RECALCULATE_FLAG,'N') = 'N' )
7311: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N')
7312: OR ( adj.modifier_line_type_code = 'PRG'
7313: OR
7314: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,
7315: aso_price_adj_relationships rlt
7316: where rlt.rltd_price_adj_id = adj.price_adjustment_id
7317: and adj2.modifier_line_type_code = 'PRG'
7318: and adj2.quote_header_id = adj.quote_header_id

Line 7355: ASO_PRICE_ADJUSTMENTS dbadj,

7351: G_RLTD_RELATED_LINE_IND_TBL,
7352: G_RLTD_LST_LN_ID_DEF_TBL,
7353: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7354: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7355: ASO_PRICE_ADJUSTMENTS dbadj,
7356: ASO_PRICE_ADJUSTMENTS dbadjrel,
7357: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7358: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7359: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7356: ASO_PRICE_ADJUSTMENTS dbadjrel,

7352: G_RLTD_LST_LN_ID_DEF_TBL,
7353: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7354: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7355: ASO_PRICE_ADJUSTMENTS dbadj,
7356: ASO_PRICE_ADJUSTMENTS dbadjrel,
7357: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7358: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7359: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7360: AND adj_rel.price_adjustment_id = adj.column_value

Line 7431: ASO_PRICE_ADJUSTMENTS dbadj,

7427: G_RLTD_RELATED_LINE_IND_TBL,
7428: G_RLTD_LST_LN_ID_DEF_TBL,
7429: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7430: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7431: ASO_PRICE_ADJUSTMENTS dbadj,
7432: ASO_PRICE_ADJUSTMENTS dbadjrel,
7433: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7434: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7435: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7432: ASO_PRICE_ADJUSTMENTS dbadjrel,

7428: G_RLTD_LST_LN_ID_DEF_TBL,
7429: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7430: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7431: ASO_PRICE_ADJUSTMENTS dbadj,
7432: ASO_PRICE_ADJUSTMENTS dbadjrel,
7433: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7434: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7435: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7436: AND adj_rel.price_adjustment_id = adj.column_value

Line 8976: FROM aso_price_adjustments

8972:
8973:
8974: CURSOR C_get_adj_id_HdrH(l_quote_header_id NUMBER,l_price_attribute1 VARCHAR2) IS
8975: SELECT price_adjustment_id
8976: FROM aso_price_adjustments
8977: WHERE quote_header_id = l_quote_header_id
8978: AND quote_line_id is null
8979: AND modifier_header_id = to_number(l_price_attribute1);
8980:

Line 8983: FROM aso_price_adjustments

8979: AND modifier_header_id = to_number(l_price_attribute1);
8980:
8981: CURSOR C_get_adj_id_HdrL(l_quote_header_id NUMBER,l_price_attribute2 VARCHAR2) IS
8982: SELECT price_adjustment_id
8983: FROM aso_price_adjustments
8984: WHERE Quote_header_id = l_quote_header_id
8985: AND quote_line_id is null
8986: AND modifier_line_id = to_number(l_price_attribute2);
8987:

Line 8990: FROM aso_price_adjustments

8986: AND modifier_line_id = to_number(l_price_attribute2);
8987:
8988: CURSOR C_get_adj_id_LnH(l_quote_header_id NUMBER,l_quote_line_id NUMBER,l_price_attribute1 VARCHAR2) IS
8989: SELECT price_adjustment_id
8990: FROM aso_price_adjustments
8991: WHERE Quote_header_id = l_quote_header_id
8992: AND Quote_line_id = l_quote_line_id
8993: AND modifier_header_id = to_number(l_price_attribute1);
8994:

Line 8997: FROM aso_price_adjustments

8993: AND modifier_header_id = to_number(l_price_attribute1);
8994:
8995: CURSOR C_get_adj_id_LnL(l_quote_header_id NUMBER,l_quote_line_id NUMBER,l_price_attribute2 VARCHAR2)IS
8996: SELECT price_adjustment_id
8997: FROM aso_price_adjustments
8998: WHERE Quote_header_id = l_quote_header_id
8999: AND Quote_line_id = l_quote_line_id
9000: AND modifier_line_id = to_number(l_price_attribute2);
9001:

Line 9108: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9104: p_price_attr_tbl(i).pricing_attribute1);
9105: FETCH C_get_adj_id_HdrH INTO l_price_adjustment_id;
9106:
9107: While C_get_adj_id_HdrH%found LOOP
9108: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9109: FETCH C_get_adj_id_HdrH INTO l_price_adjustment_id;
9110: End Loop;
9111: CLOSE C_get_adj_id_HdrH;
9112:

Line 9130: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9126: aso_debug_pub.add('ASO_PRICING_CORE_PVT:No record in C_get_adj_id_HdrL:i - '||i,1,'Y');
9127: END IF;
9128: /*Do not error OUT do nothing*/
9129: ELSE
9130: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9131: END IF;
9132: CLOSE C_get_adj_id_HdrL;
9133: End If;-- IF (p_price_attr_tbl(i).pricing_attribute2 is null
9134:

Line 9156: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9152: );
9153: FETCH C_get_adj_id_LnH INTO l_price_adjustment_id;
9154:
9155: While C_get_adj_id_LnH%found LOOP
9156: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9157: FETCH C_get_adj_id_LnH INTO l_price_adjustment_id;
9158: End Loop;
9159:
9160: CLOSE C_get_adj_id_LnH;

Line 9181: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9177: aso_debug_pub.add('ASO_PRICING_CORE_PVT:No record in C_get_adj_id_LnL:i'||i,1,'Y');
9178: END IF;
9179: /*Do not error OUT - do nothing*/
9180: ELSE
9181: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9182: END IF;
9183: CLOSE C_get_adj_id_LnL;
9184:
9185: End If;

Line 9560: INSERT INTO ASO_PRICE_ADJUSTMENTS

9556: END IF;
9557:
9558: If p_insert_type = 'HDR' then
9559:
9560: INSERT INTO ASO_PRICE_ADJUSTMENTS
9561: (price_adjustment_id,
9562: creation_date,
9563: created_by,
9564: last_update_date,

Line 9607: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

9603: operand_per_pqty,
9604: adjusted_amount_per_pqty
9605: )(
9606: SELECT
9607: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9608: sysdate
9609: ,fnd_global.user_id
9610: ,sysdate
9611: ,fnd_global.user_id

Line 9726: ASO_PRICE_ADJUSTMENTS ADJ,

9722: FROM
9723: QP_PREQ_RLTD_LINES_TMP RLTD,
9724: QP_PREQ_LINES_TMP LINE,
9725: QP_PREQ_LINES_TMP RLTD_LINE,
9726: ASO_PRICE_ADJUSTMENTS ADJ,
9727: ASO_PRICE_ADJUSTMENTS RADJ
9728: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9729: AND RLTD_LINE.line_index = RLTD.related_line_index
9730: AND RLTD.Relationship_Type_Code in

Line 9727: ASO_PRICE_ADJUSTMENTS RADJ

9723: QP_PREQ_RLTD_LINES_TMP RLTD,
9724: QP_PREQ_LINES_TMP LINE,
9725: QP_PREQ_LINES_TMP RLTD_LINE,
9726: ASO_PRICE_ADJUSTMENTS ADJ,
9727: ASO_PRICE_ADJUSTMENTS RADJ
9728: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9729: AND RLTD_LINE.line_index = RLTD.related_line_index
9730: AND RLTD.Relationship_Type_Code in
9731: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )

Line 9786: ASO_PRICE_ADJUSTMENTS ADJ,

9782: ,decode(QPLAT.ATTRIBUTE_TYPE,
9783: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
9784: 'QP_ATTR_DEFNS_PRICING')
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

Line 9837: ASO_PRICE_ADJUSTMENTS ADJ,

9833: ,decode(QPLAT.ATTRIBUTE_TYPE,
9834: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
9835: 'QP_ATTR_DEFNS_PRICING')
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

Line 9878: INSERT INTO ASO_PRICE_ADJUSTMENTS

9874: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9875: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Only insert line level adjustments and relationships and attribs',1,'Y');
9876: END IF;
9877:
9878: INSERT INTO ASO_PRICE_ADJUSTMENTS
9879: (price_adjustment_id,
9880: creation_date,
9881: created_by,
9882: last_update_date,

Line 9925: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

9921: operand_per_pqty,
9922: adjusted_amount_per_pqty
9923: )(
9924: SELECT
9925: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9926: sysdate
9927: ,fnd_global.user_id
9928: ,sysdate
9929: ,fnd_global.user_id

Line 10046: ASO_PRICE_ADJUSTMENTS ADJ,

10042: FROM
10043: QP_PREQ_RLTD_LINES_TMP RLTD,
10044: QP_PREQ_LINES_TMP LINE,
10045: QP_PREQ_LINES_TMP RLTD_LINE,
10046: ASO_PRICE_ADJUSTMENTS ADJ,
10047: ASO_PRICE_ADJUSTMENTS RADJ
10048: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10049: AND RLTD_LINE.line_index = RLTD.related_line_index
10050: AND RLTD.Relationship_Type_Code in

Line 10047: ASO_PRICE_ADJUSTMENTS RADJ

10043: QP_PREQ_RLTD_LINES_TMP RLTD,
10044: QP_PREQ_LINES_TMP LINE,
10045: QP_PREQ_LINES_TMP RLTD_LINE,
10046: ASO_PRICE_ADJUSTMENTS ADJ,
10047: ASO_PRICE_ADJUSTMENTS RADJ
10048: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10049: AND RLTD_LINE.line_index = RLTD.related_line_index
10050: AND RLTD.Relationship_Type_Code in
10051: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )

Line 10104: ASO_PRICE_ADJUSTMENTS ADJ,

10100: ,decode(QPLAT.ATTRIBUTE_TYPE,
10101: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10102: 'QP_ATTR_DEFNS_PRICING')
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

Line 10133: INSERT INTO ASO_PRICE_ADJUSTMENTS

10129: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_insert_type: '||p_insert_type,1,'Y');
10130: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inserting only header level adjustments',1,'Y');
10131: END IF;
10132:
10133: INSERT INTO ASO_PRICE_ADJUSTMENTS
10134: (price_adjustment_id,
10135: creation_date,
10136: created_by,
10137: last_update_date,

Line 10180: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

10176: operand_per_pqty,
10177: adjusted_amount_per_pqty
10178: )(
10179: SELECT
10180: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10181: sysdate,
10182: fnd_global.user_id,
10183: sysdate,
10184: fnd_global.user_id,

Line 10270: ASO_PRICE_ADJUSTMENTS ADJ,

10266: ,decode(QPLAT.ATTRIBUTE_TYPE,
10267: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10268: 'QP_ATTR_DEFNS_PRICING')
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

Line 10297: --Just Insert ASO_PRICE_ADJUSTMENTS only.

10293:
10294: End if;--If p_control_rec.price_mode = 'BATCH'
10295: Else
10296: --l_db_line_counter is zero.
10297: --Just Insert ASO_PRICE_ADJUSTMENTS only.
10298:
10299: INSERT INTO ASO_PRICE_ADJUSTMENTS
10300: (price_adjustment_id,
10301: creation_date,

Line 10299: INSERT INTO ASO_PRICE_ADJUSTMENTS

10295: Else
10296: --l_db_line_counter is zero.
10297: --Just Insert ASO_PRICE_ADJUSTMENTS only.
10298:
10299: INSERT INTO ASO_PRICE_ADJUSTMENTS
10300: (price_adjustment_id,
10301: creation_date,
10302: created_by,
10303: last_update_date,

Line 10346: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

10342: operand_per_pqty,
10343: adjusted_amount_per_pqty
10344: )(
10345: SELECT
10346: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10347: sysdate
10348: ,fnd_global.user_id
10349: ,sysdate
10350: ,fnd_global.user_id

Line 10906: FROM ASO_PRICE_ADJUSTMENTS

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
10905: SELECT PRICE_ADJUSTMENT_ID
10906: FROM ASO_PRICE_ADJUSTMENTS
10907: WHERE quote_line_id = l_qte_line_id
10908: AND modifier_line_id = l_modifier_line_id;
10909:
10910: BEGIN