APPS.JAI_OM_WSH_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 42: v_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE ;

38: v_oth_ed_amt NUMBER ;
39: v_excise_exempt_type JAI_OM_WSH_LINES_ALL.EXCISE_EXEMPT_TYPE%TYPE ;
40: v_selling_price NUMBER ;
41: v_set_of_books_id NUMBER ;
42: v_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE ;
43: v_conv_type_code OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE ;
44: v_conv_rate NUMBER ;
45: v_conv_date DATE ;
46: v_customer_id NUMBER ;

Line 43: v_conv_type_code OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE ;

39: v_excise_exempt_type JAI_OM_WSH_LINES_ALL.EXCISE_EXEMPT_TYPE%TYPE ;
40: v_selling_price NUMBER ;
41: v_set_of_books_id NUMBER ;
42: v_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE ;
43: v_conv_type_code OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE ;
44: v_conv_rate NUMBER ;
45: v_conv_date DATE ;
46: v_customer_id NUMBER ;
47: v_ship_to_org_id NUMBER ;

Line 182: || conversion_date from oe_order_headers_all.

178:
179: /*
180: || Code changed by aiyer for the bug #3090371.
181: || Modified the cursor to get the actual_shipment_date from oe_order_lines_all instead of the
182: || conversion_date from oe_order_headers_all.
183: || As a Sales order shipment date can be different from its creation date, hence the conversion rate
184: || applicable on the date of shipment should be considerd for all processing rather than the creation
185: || date of the Sales order.
186: */

Line 189: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,

185: || date of the Sales order.
186: */
187:
188: CURSOR get_conv_detail_cur(
189: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,
190: cp_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE
191: ) IS
192: SELECT
193: order_number ,

Line 199: oe_order_headers_all a ,

195: conversion_type_code ,
196: conversion_rate ,
197: b.actual_shipment_date
198: FROM
199: oe_order_headers_all a ,
200: oe_order_lines_all b
201: WHERE
202: a.header_id = b.header_id AND
203: b.line_id = cp_line_id AND

Line 363: FROM oe_order_headers_all

359: AND A.quantity_applied > 0;
360:
361: CURSOR ship_bill_cur (p_order_header_id NUMBER) IS
362: SELECT INVOICE_TO_ORG_ID,SHIP_TO_ORG_ID
363: FROM oe_order_headers_all
364: WHERE header_id = p_order_header_id;
365:
366: CURSOR qty_to_adjust_cur (p_receipt_id NUMBER) IS
367: SELECT qty_to_adjust,excise_duty_rate,rate_per_unit,quantity_received --added quantity_received for bug#5735284

Line 458: v_ord_num oe_order_headers_all.order_number%type;

454: /* Ramananda for File.Sql.35 */
455:
456: v_ref_26 gl_interface.reference26%type ; -- holds the column value -- eg -- 13645
457:
458: v_ord_num oe_order_headers_all.order_number%type;
459:
460: CURSOR c_order_num(p_hdr_id number) is
461: SELECT order_number
462: FROM oe_order_headers_all

Line 462: FROM oe_order_headers_all

458: v_ord_num oe_order_headers_all.order_number%type;
459:
460: CURSOR c_order_num(p_hdr_id number) is
461: SELECT order_number
462: FROM oe_order_headers_all
463: WHERE header_id = p_hdr_id;
464:
465: -- additions by sriram ends here
466:

Line 770: conversion_date from oe_order_headers_all.

766:
767: 31. 2003/09/24 Aiyer - Bug#3139718, File Version 616.5
768:
769: Modified the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
770: conversion_date from oe_order_headers_all.
771: As a Sales order shipment date can be different from its creation date, hence the conversion rate
772: applicable on the date of shipment should be considered for all processing rather than the creation
773: date of the Sales order.
774: Added a call to jai_cmn_utils_pkg.currency_conversion procedure to get the conversion rate based on the actual shipment date.