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 QP_PREQ_LINE_ATTRS_TMP

Line 4610: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4606: not in (select qplat.context
4607: , qplat.attribute
4608: , qplat.setup_value_from
4609: , qplat.setup_value_to
4610: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4611: -- , QP_PREQ_LDETS_TMP LDETS
4612: -- , OE_PRICE_ADJUSTMENTS ADJ
4613: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4614: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)

Line 4651: (SELECT /+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) /

4647: ,FLEX_TITLE
4648: ,PRICE_ADJ_ATTRIB_ID
4649: ,LOCK_CONTROL
4650: )
4651: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
4652: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4653: ,QPLAT.CONTEXT
4654: ,QPLAT.ATTRIBUTE
4655: ,sysdate

Line 4672: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

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
4675: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4676: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID

Line 4718: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4714: not in (select qplat.context
4715: , qplat.attribute
4716: , qplat.setup_value_from
4717: , qplat.setup_value_to
4718: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4719: -- , QP_LDETS_v LDETS
4720: -- , OE_PRICE_ADJUSTMENTS ADJ
4721: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4722: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)

Line 4757: (SELECT /+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) /

4753: ,FLEX_TITLE
4754: ,PRICE_ADJ_ATTRIB_ID
4755: ,LOCK_CONTROL
4756: )
4757: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
4758: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4759: ,QPLAT.CONTEXT
4760: ,QPLAT.ATTRIBUTE
4761: ,sysdate

Line 4778: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

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
4781: --, QP_PREQ_LINES_TMP QPL
4782: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

Line 4872: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

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
4875: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4876: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID

Line 4929: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

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
4932: , QP_PREQ_LINES_TMP QPLINE
4933: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

Line 5972: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;

5968: oe_debug_pub.add('Entering oe_order_price_pvt.calulate_adjustments', 1);
5969:
5970: reset_all_tbls;
5971: --DELETE FROM QP_PREQ_LINES_TMP;
5972: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
5973: --DELETE FROM QP_PREQ_LDETS_TMP;
5974: --DELETE FROM QP_PREQ_QUAL_TMP;
5975: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
5976: