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.OZF_ACCRUAL_ENGINE dependencies on QP_LIST_LINES

Line 1104: --query it from qp_list_lines table

1100: WHERE org_id = p_org_id;
1101:
1102: --kdass - bug 9470625
1103: --if formula is specified on offer line, then operand in oe_price_adjustments is not correct,
1104: --query it from qp_list_lines table
1105: CURSOR c_sd_offer_discount (p_price_adjustment_id IN NUMBER) IS
1106: SELECT NVL2(qpll.price_by_formula_id, qpll.operand, oe.operand),
1107: oe.arithmetic_operator
1108: FROM oe_price_adjustments oe, qp_list_lines qpll

Line 1108: FROM oe_price_adjustments oe, qp_list_lines qpll

1104: --query it from qp_list_lines table
1105: CURSOR c_sd_offer_discount (p_price_adjustment_id IN NUMBER) IS
1106: SELECT NVL2(qpll.price_by_formula_id, qpll.operand, oe.operand),
1107: oe.arithmetic_operator
1108: FROM oe_price_adjustments oe, qp_list_lines qpll
1109: WHERE oe.price_adjustment_id = p_price_adjustment_id
1110: AND oe.list_line_id = qpll.list_line_id;
1111:
1112: --fix for bug 13742169

Line 2866: FROM qp_list_lines

2862: -- Catch Weight ER - end
2863:
2864: CURSOR c_list_line_info (p_list_line_id IN NUMBER) IS
2865: SELECT estim_gl_value
2866: FROM qp_list_lines
2867: WHERE list_line_id = p_list_line_id;
2868:
2869: CURSOR c_old_adjustment_amount (p_price_adjustment_id IN NUMBER) IS
2870: SELECT SUM (plan_curr_amount)