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 177: || conversion_date from oe_order_headers_all.

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

Line 184: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,

180: || date of the Sales order.
181: */
182:
183: CURSOR get_conv_detail_cur(
184: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,
185: cp_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE
186: ) IS
187: SELECT
188: order_number ,

Line 194: oe_order_headers_all a ,

190: conversion_type_code ,
191: conversion_rate ,
192: b.actual_shipment_date
193: FROM
194: oe_order_headers_all a ,
195: oe_order_lines_all b
196: WHERE
197: a.header_id = b.header_id AND
198: b.line_id = cp_line_id AND

Line 358: FROM oe_order_headers_all

354: AND A.quantity_applied > 0;
355:
356: CURSOR ship_bill_cur (p_order_header_id NUMBER) IS
357: SELECT INVOICE_TO_ORG_ID,SHIP_TO_ORG_ID
358: FROM oe_order_headers_all
359: WHERE header_id = p_order_header_id;
360:
361: CURSOR qty_to_adjust_cur (p_receipt_id NUMBER) IS
362: SELECT qty_to_adjust,excise_duty_rate,rate_per_unit

Line 445: v_ord_num oe_order_headers_all.order_number%type;

441: /* Ramananda for File.Sql.35 */
442:
443: v_ref_26 gl_interface.reference26%type ; -- holds the column value -- eg -- 13645
444:
445: v_ord_num oe_order_headers_all.order_number%type;
446:
447: CURSOR c_order_num(p_hdr_id number) is
448: SELECT order_number
449: FROM oe_order_headers_all

Line 449: FROM oe_order_headers_all

445: v_ord_num oe_order_headers_all.order_number%type;
446:
447: CURSOR c_order_num(p_hdr_id number) is
448: SELECT order_number
449: FROM oe_order_headers_all
450: WHERE header_id = p_hdr_id;
451:
452: -- additions by sriram ends here
453:

Line 742: conversion_date from oe_order_headers_all.

738:
739: 31. 2003/09/24 Aiyer - Bug#3139718, File Version 616.5
740:
741: Modified the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
742: conversion_date from oe_order_headers_all.
743: As a Sales order shipment date can be different from its creation date, hence the conversion rate
744: applicable on the date of shipment should be considered for all processing rather than the creation
745: date of the Sales order.
746: Added a call to jai_cmn_utils_pkg.currency_conversion procedure to get the conversion rate based on the actual shipment date.