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.PMI_SALES_PKG dependencies on OE_PRICE_ADJUSTMENTS

Line 625: P_line_id oe_price_adjustments.line_id%TYPE)

621: IS
622: /* cur_line_charge returns line-level changes, in transactional currency */
623:
624: CURSOR cur_line_charge(P_Header_id oe_order_lines_all.header_id%TYPE,
625: P_line_id oe_price_adjustments.line_id%TYPE)
626: IS
627: /* Bug fix 2733400 SKARIMIS 01/10/2003 */
628: SELECT SUM(opa.adjusted_amount) * AVG(ool.ordered_quantity) line_level_discount
629: FROM oe_price_adjustments_v opa

Line 629: FROM oe_price_adjustments_v opa

625: P_line_id oe_price_adjustments.line_id%TYPE)
626: IS
627: /* Bug fix 2733400 SKARIMIS 01/10/2003 */
628: SELECT SUM(opa.adjusted_amount) * AVG(ool.ordered_quantity) line_level_discount
629: FROM oe_price_adjustments_v opa
630: , oe_order_lines_all ool
631: WHERE opa.line_id =p_line_id
632: and ool.line_id = p_line_id
633: and ool.header_id = p_header_id

Line 647: FROM oe_price_adjustments_v opa

643: '%', opa.operand*ool.unit_list_price/100,
644: 'AMT',opa.operand,
645: 'NEWPRICE',ool.unit_list_price - opa.operand) * ool.ordered_quantity
646: ) order_level_discount
647: FROM oe_price_adjustments_v opa
648: , oe_order_lines_all ool
649: WHERE opa.HEADER_ID = p_header_id
650: and opa.line_id is null
651: and ool.line_id = p_line_id