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_LDETS_V

Line 3588: AND list_line_id not in (select list_line_id from qp_ldets_v ld

3584: and b.pricing_phase_id = a.pricing_phase_id
3585: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3586: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3587: AND HEADER_ID = p_hdr_line_id
3588: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3589: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3590: QP_PREQ_GRP.G_STATUS_UPDATED,
3591: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3592: and ld.line_index = p_hdr_line_index

Line 3661: AND list_line_id not in (select list_line_id from qp_ldets_v ld

3657: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3658: and b.pricing_phase_id = a.pricing_phase_id
3659: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3660: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3661: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3662: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3663: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3664: QP_PREQ_PUB.G_STATUS_NEW)
3665: and ld.line_index = one_line.line_index

Line 3745: from qp_ldets_v ld

3741: = decode(l_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3742: AND LINE_ID = p_line_id
3743: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712
3744: AND list_line_id not in (select list_line_id
3745: from qp_ldets_v ld
3746: where ld.process_code in
3747: (QP_PREQ_GRP.G_STATUS_UPDATED,
3748: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3749: QP_PREQ_PUB.G_STATUS_NEW)

Line 3934: QP_LDETS_v ldets

3930: , fnd_global.user_id
3931: , fnd_global.LOGIN_ID
3932: --bug#7369643
3933: from
3934: QP_LDETS_v ldets
3935: where ldets.line_detail_index = p_line_detail_index
3936: )
3937: where adj.price_adjustment_id = p_price_adjustment_id
3938: returning adj.list_line_id bulk collect into px_debug_upd_adj_tbl;

Line 3965: ,QP_LDETS_V LDETS

3961: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
3962: adj.price_adjustment_id, ldets.line_detail_index
3963: From QP_PREQ_LINES_TMP QPLINES
3964: ,OE_PRICE_ADJUSTMENTS ADJ
3965: ,QP_LDETS_V LDETS
3966: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
3967: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
3968: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3969: -- where pricing_event_code = p_pricing_events)

Line 3983: ,QP_LDETS_V LDETS

3979: cursor del_attribs2(p_hdr_line_index in number, p_hdr_line_id in number) Is
3980: Select ADJ.PRICE_ADJUSTMENT_ID, LDETS.LINE_DETAIL_INDEX
3981: From
3982: OE_PRICE_ADJUSTMENTS ADJ
3983: ,QP_LDETS_V LDETS
3984: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
3985: AND LDETS.LINE_INDEX = p_hdr_line_index
3986: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3987: -- where pricing_event_code = p_pricing_events)

Line 4032: , QP_LDETS_v ldets

4028: ldets.proration_type_code,
4029: ldets.include_on_returns_flag,
4030: adj.lock_control + 1 adj_lock_control
4031: from OE_PRICE_ADJUSTMENTS adj
4032: , QP_LDETS_v ldets
4033: , QP_PREQ_LINES_TMP lines
4034: WHERE
4035: adj.header_id=oe_order_pub.g_hdr.header_id
4036: and lines.line_index = ldets.line_index

Line 4078: , QP_LDETS_v ldets

4074: ldets.proration_type_code,
4075: ldets.include_on_returns_flag,
4076: adj.lock_control + 1 adj_lock_control
4077: from OE_PRICE_ADJUSTMENTS adj
4078: , QP_LDETS_v ldets
4079: , QP_PREQ_LINES_TMP lines
4080: WHERE
4081: adj.header_id=oe_order_pub.g_hdr.header_id
4082: and lines.line_index = ldets.line_index

Line 4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

4091:
4092: --bug 3836854
4093: Cursor upd_adj(l_line_type IN Varchar2) Is
4094: select ldets2.price_adjustment_id, ldets2.line_detail_index
4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4096: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4097: AND lines2.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4098: and lines2.process_status <> 'NOT_VALID'
4099: and lines2.line_index = ldets2.line_index

Line 4465: QP_LDETS_v ldets

4461: , ldets.OPERAND_value
4462: , ldets.adjustment_amount
4463: , 1
4464: FROM
4465: QP_LDETS_v ldets
4466: , QP_PREQ_LINES_TMP lines
4467: , QP_LIST_HEADERS_B QH
4468: WHERE
4469: ldets.list_header_id=qh.list_header_id

Line 4673: -- , QP_LDETS_v LDETS

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
4677: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4719: -- , QP_LDETS_v LDETS

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)
4723: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4779: --, QP_LDETS_v LDETS

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
4783: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4809: From QP_LDETS_V LDETS

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
4811: ,QP_PREQ_LINES_TMP QPLINES
4812: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4813: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4822: From QP_LDETS_V LDETS

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
4824: ,QP_PREQ_LINES_TMP QPLINES
4825: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4826: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4873: , QP_LDETS_v LDETS

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
4877: AND ADJ.LINE_ID IS NULL

Line 4930: , QP_LDETS_v LDETS

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
4934: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)

Line 6842: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f

6838:
6839: Function get_formula(p_line_index In Number) Return Varchar2 IS
6840: Cursor Get_Formula Is
6841: Select f.formula
6842: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f
6843: Where ldet.line_index = p_line_index
6844: AND ldet.list_line_id = qpll.list_line_id
6845: AND f.price_formula_id = nvl(qpll.price_by_formula_id,qpll.generate_using_formula_id);
6846: l_formula_name Varchar2(2000);