APPS.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 4725: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4721: not in (select qplat.context
4722: , qplat.attribute
4723: , qplat.setup_value_from
4724: , qplat.setup_value_to
4725: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4726: -- , QP_PREQ_LDETS_TMP LDETS
4727: -- , OE_PRICE_ADJUSTMENTS ADJ
4728: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4729: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)

Line 4766: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */

4762: ,FLEX_TITLE
4763: ,PRICE_ADJ_ATTRIB_ID
4764: ,LOCK_CONTROL
4765: )
4766: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
4767: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4768: ,QPLAT.CONTEXT
4769: ,QPLAT.ATTRIBUTE
4770: ,sysdate

Line 4787: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4783: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4784: 'QP_ATTR_DEFNS_PRICING')
4785: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4786: ,1
4787: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4788: -- , QP_LDETS_v LDETS
4789: -- , OE_PRICE_ADJUSTMENTS ADJ
4790: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4791: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID

Line 4833: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4829: not in (select qplat.context
4830: , qplat.attribute
4831: , qplat.setup_value_from
4832: , qplat.setup_value_to
4833: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4834: -- , QP_LDETS_v LDETS
4835: -- , OE_PRICE_ADJUSTMENTS ADJ
4836: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4837: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)

Line 4872: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */

4868: ,FLEX_TITLE
4869: ,PRICE_ADJ_ATTRIB_ID
4870: ,LOCK_CONTROL
4871: )
4872: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
4873: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4874: ,QPLAT.CONTEXT
4875: ,QPLAT.ATTRIBUTE
4876: ,sysdate

Line 4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4889: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4890: 'QP_ATTR_DEFNS_PRICING')
4891: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4892: ,1
4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4894: --, QP_LDETS_v LDETS
4895: --, OE_PRICE_ADJUSTMENTS ADJ
4896: --, QP_PREQ_LINES_TMP QPL
4897: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

Line 4987: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

4983: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
4984: 'QP_ATTR_DEFNS_PRICING')
4985: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4986: ,1
4987: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4988: , QP_LDETS_v LDETS
4989: , OE_PRICE_ADJUSTMENTS ADJ
4990: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4991: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID

Line 5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

5042: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
5043: 'QP_ATTR_DEFNS_PRICING')
5044: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5045: ,1
5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5047: , QP_LDETS_v LDETS
5048: , OE_PRICE_ADJUSTMENTS ADJ
5049: , QP_PREQ_LINES_TMP QPLINE
5050: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

Line 5085: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */

5081: ,FLEX_TITLE
5082: ,PRICE_ADJ_ATTRIB_ID
5083: ,LOCK_CONTROL
5084: )
5085: (SELECT /*+ index (QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
5086: ADJ.PRICE_ADJUSTMENT_ID
5087: ,QPLAT.CONTEXT
5088: ,QPLAT.ATTRIBUTE
5089: ,sysdate

Line 5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

5102: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
5103: 'QP_ATTR_DEFNS_PRICING')
5104: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5105: ,1
5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ
5109: , QP_PREQ_LINES_TMP QPLINE
5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

Line 6255: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;

6251: END IF;
6252:
6253: reset_all_tbls;
6254: --DELETE FROM QP_PREQ_LINES_TMP;
6255: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
6256: --DELETE FROM QP_PREQ_LDETS_TMP;
6257: --DELETE FROM QP_PREQ_QUAL_TMP;
6258: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
6259: