DBA Data[Home] [Help]

APPS.PMI_SALES_PKG dependencies on OE_ORDER_LINES_ALL

Line 258: OE_ORDER_LINES_ALL orderdetail,

254: orderdetail.ordered_quantity)
255: ) line_Margin
256: FROM
257: OE_ORDER_HEADERS_ALL orderhdr,
258: OE_ORDER_LINES_ALL orderdetail,
259: OE_SYSTEM_PARAMETERS_ALL masterorg,
260: MTL_SYSTEM_ITEMS msi,
261: IC_ITEM_MST itemmst,
262: HR_OPERATING_UNITS ou,

Line 344: OE_ORDER_LINES_ALL orderdetail,

340: orderdetail.ordered_quantity)
341: ) line_Margin
342: FROM
343: OE_ORDER_HEADERS_ALL orderhdr,
344: OE_ORDER_LINES_ALL orderdetail,
345: OE_SYSTEM_PARAMETERS_ALL masterorg,
346: MTL_SYSTEM_ITEMS msi,
347: IC_ITEM_MST itemmst,
348: HR_OPERATING_UNITS ou,

Line 612: FUNCTION PMIOM_GET_CHARGE (p_Header_id IN oe_order_lines_all.header_id%TYPE,

608:
609:
610: /* Function to calculate Charges for a given OM order line */
611:
612: FUNCTION PMIOM_GET_CHARGE (p_Header_id IN oe_order_lines_all.header_id%TYPE,
613: p_Line_id IN oe_order_lines_all.line_id%TYPE,
614: p_extended_price IN oe_order_lines_all.unit_selling_price%TYPE,
615: p_Billing_Currency IN oe_order_headers_all.transactional_curr_code%TYPE,
616: p_Base_Currency IN gl_sets_of_books.currency_code%TYPE,

Line 613: p_Line_id IN oe_order_lines_all.line_id%TYPE,

609:
610: /* Function to calculate Charges for a given OM order line */
611:
612: FUNCTION PMIOM_GET_CHARGE (p_Header_id IN oe_order_lines_all.header_id%TYPE,
613: p_Line_id IN oe_order_lines_all.line_id%TYPE,
614: p_extended_price IN oe_order_lines_all.unit_selling_price%TYPE,
615: p_Billing_Currency IN oe_order_headers_all.transactional_curr_code%TYPE,
616: p_Base_Currency IN gl_sets_of_books.currency_code%TYPE,
617: p_exchange_Rate IN oe_order_headers_all.conversion_rate%TYPE,

Line 614: p_extended_price IN oe_order_lines_all.unit_selling_price%TYPE,

610: /* Function to calculate Charges for a given OM order line */
611:
612: FUNCTION PMIOM_GET_CHARGE (p_Header_id IN oe_order_lines_all.header_id%TYPE,
613: p_Line_id IN oe_order_lines_all.line_id%TYPE,
614: p_extended_price IN oe_order_lines_all.unit_selling_price%TYPE,
615: p_Billing_Currency IN oe_order_headers_all.transactional_curr_code%TYPE,
616: p_Base_Currency IN gl_sets_of_books.currency_code%TYPE,
617: p_exchange_Rate IN oe_order_headers_all.conversion_rate%TYPE,
618: p_ordered_quantity IN oe_order_lines_all.ordered_quantity%TYPE

Line 618: p_ordered_quantity IN oe_order_lines_all.ordered_quantity%TYPE

614: p_extended_price IN oe_order_lines_all.unit_selling_price%TYPE,
615: p_Billing_Currency IN oe_order_headers_all.transactional_curr_code%TYPE,
616: p_Base_Currency IN gl_sets_of_books.currency_code%TYPE,
617: p_exchange_Rate IN oe_order_headers_all.conversion_rate%TYPE,
618: p_ordered_quantity IN oe_order_lines_all.ordered_quantity%TYPE
619: )
620: RETURN NUMBER
621: IS
622: /* cur_line_charge returns line-level changes, in transactional currency */

Line 624: CURSOR cur_line_charge(P_Header_id oe_order_lines_all.header_id%TYPE,

620: RETURN NUMBER
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

Line 630: , oe_order_lines_all ool

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
634: and nvl(opa.applied_flag,'Y') = 'Y'

Line 648: , oe_order_lines_all ool

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
652: and ool.header_id = p_header_id