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.OE_ORDER_PRICE_PVT dependencies on OE_PRICE_ADJ_ATTRIBS

Line 3525: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_adj_id_tbl(i);

3521: --END IF;
3522: END IF;
3523:
3524: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3525: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_adj_id_tbl(i);
3526: IF l_debug_level > 0 THEN
3527: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ATTRIBS' , 3 ) ;
3528: END IF;
3529:

Line 4601: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)

4597:
4598: If l_adj_id_tbl.count > 0 Then
4599: l_stmt:=9;
4600: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4601: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)
4602: AND ( pricing_context
4603: , pricing_attribute
4604: , pricing_attr_value_from
4605: , pricing_attr_value_to)

Line 4631: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4627: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||' ATTRIBUTES' ) ;
4628: END IF;
4629: l_stmt:=10;
4630: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4631: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4632: ( PRICE_ADJUSTMENT_ID
4633: ,PRICING_CONTEXT
4634: ,PRICING_ATTRIBUTE
4635: ,CREATION_DATE

Line 4670: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4666: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4667: ,decode(QPLAT.ATTRIBUTE_TYPE,
4668: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4669: 'QP_ATTR_DEFNS_PRICING')
4670: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4671: ,1
4672: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4673: -- , QP_LDETS_v LDETS
4674: -- , OE_PRICE_ADJUSTMENTS ADJ

Line 4692: FROM OE_PRICE_ADJ_ATTRIBS

4688: not in (select pricing_context
4689: , pricing_attribute
4690: , pricing_attr_value_from
4691: , pricing_attr_value_to
4692: FROM OE_PRICE_ADJ_ATTRIBS
4693: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4694: ));
4695: IF l_debug_level > 0 THEN
4696: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' CHANGED ATTRIBS' ) ;

Line 4709: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)

4705: fetch del_attribs2 Bulk Collect into l_adj_id_tbl, l_line_detail_index_tbl;
4706:
4707: If l_adj_id_tbl.count > 0 Then
4708: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4709: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = l_adj_id_tbl(i)
4710: AND ( pricing_context
4711: , pricing_attribute
4712: , pricing_attr_value_from
4713: , pricing_attr_value_to)

Line 4737: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4733: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||'ORDER ADJ LEVEL ATTRIBUTES' ) ;
4734: END IF;
4735: l_stmt:=12;
4736: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
4737: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4738: ( PRICE_ADJUSTMENT_ID
4739: ,PRICING_CONTEXT
4740: ,PRICING_ATTRIBUTE
4741: ,CREATION_DATE

Line 4776: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4772: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4773: ,decode(QPLAT.ATTRIBUTE_TYPE,
4774: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4775: 'QP_ATTR_DEFNS_PRICING')
4776: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4777: ,1
4778: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4779: --, QP_LDETS_v LDETS
4780: --, OE_PRICE_ADJUSTMENTS ADJ

Line 4799: FROM OE_PRICE_ADJ_ATTRIBS

4795: not in (select pricing_context
4796: , pricing_attribute
4797: , pricing_attr_value_from
4798: , pricing_attr_value_to
4799: FROM OE_PRICE_ADJ_ATTRIBS
4800: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4801: ));
4802: End If;
4803: close del_attribs2;

Line 4806: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs

4802: End If;
4803: close del_attribs2;
4804: l_stmt:=13;
4805: /* Delete price_adj_attribs for order level adj*/
4806: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4807: WHERE exists
4808: (Select ADJ.PRICE_ADJUSTMENT_ID
4809: From QP_LDETS_V LDETS
4810: ,OE_PRICE_ADJUSTMENTS ADJ

Line 4819: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs

4815: AND QPLINES.LINE_ID = ADJ.HEADER_ID
4816: AND ADJ.price_adjustment_id = adjattrs.price_adjustment_id);*/
4817:
4818: /* Delete price_adj_attribs for line level adj*/
4819: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4820: WHERE exists
4821: (Select ADJ.PRICE_ADJUSTMENT_ID
4822: From QP_LDETS_V LDETS
4823: ,OE_PRICE_ADJUSTMENTS ADJ

Line 4832: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4828: AND QPLINES.LINE_TYPE_CODE = 'LINE'
4829: AND ADJ.price_adjustment_id = adjattrs.price_adjustment_id);*/
4830:
4831: /* insert header level adjustment attributes */
4832: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4833: ( PRICE_ADJUSTMENT_ID
4834: ,PRICING_CONTEXT
4835: ,PRICING_ATTRIBUTE
4836: ,CREATION_DATE

Line 4870: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4866: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4867: ,decode(QPLAT.ATTRIBUTE_TYPE,
4868: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4869: 'QP_ATTR_DEFNS_PRICING')
4870: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4871: ,1
4872: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4873: , QP_LDETS_v LDETS
4874: , OE_PRICE_ADJUSTMENTS ADJ

Line 4889: INSERT INTO OE_PRICE_ADJ_ATTRIBS

4885: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4887: );
4888: l_stmt:=14;
4889: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4890: ( PRICE_ADJUSTMENT_ID
4891: ,PRICING_CONTEXT
4892: ,PRICING_ATTRIBUTE
4893: ,CREATION_DATE

Line 4927: ,OE_PRICE_ADJ_ATTRIBS_S.nextval

4923: ,QPLAT.COMPARISON_OPERATOR_TYPE_CODE
4924: ,decode(QPLAT.ATTRIBUTE_TYPE,
4925: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4926: 'QP_ATTR_DEFNS_PRICING')
4927: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4928: ,1
4929: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4930: , QP_LDETS_v LDETS
4931: , OE_PRICE_ADJUSTMENTS ADJ