DBA Data[Home] [Help]

APPS.PMI_SALES_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 257: OE_ORDER_HEADERS_ALL orderhdr,

253: orderhdr.conversion_rate,
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,

Line 343: OE_ORDER_HEADERS_ALL orderhdr,

339: orderhdr.conversion_rate,
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,

Line 615: p_Billing_Currency IN oe_order_headers_all.transactional_curr_code%TYPE,

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
619: )

Line 617: p_exchange_Rate IN oe_order_headers_all.conversion_rate%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
619: )
620: RETURN NUMBER
621: IS