APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 488: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;

484:
485: /*
486: || Added by bgowrava for the forward porting bug 5631784
487: */
488: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
489: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
490: IS
491: SELECT
492: *

Line 489: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)

485: /*
486: || Added by bgowrava for the forward porting bug 5631784
487: */
488: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
489: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
490: IS
491: SELECT
492: *
493: FROM

Line 494: oe_order_headers_all

490: IS
491: SELECT
492: *
493: FROM
494: oe_order_headers_all
495: WHERE
496: header_id = cp_header_id ;
497: --Added cursor by JMEENA for bug#6731913
498: CURSOR cur_tot_shipped_quantity (cp_delivery_detail_id IN NUMBER)

Line 514: oe_order_headers_all oeh,

510: CURSOR c_ato_line_id IS
511: SELECT
512: oel.ato_line_id
513: FROM
514: oe_order_headers_all oeh,
515: oe_order_lines_all oel
516: WHERE
517: oeh.header_id = pr_new.source_header_id
518: AND oeh.header_id = oel.header_id

Line 1442: oe_order_headers_all a ,

1438: conversion_type_code ,
1439: conversion_rate ,
1440: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
1441: FROM
1442: oe_order_headers_all a ,
1443: oe_order_lines_all b
1444: WHERE
1445: a.header_id = b.header_id AND
1446: b.line_id = v_source_line_id AND

Line 1451: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;

1447: a.header_id = v_source_header_id ;
1448:
1449: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
1450: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
1451: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
1452: v_conv_rate NUMBER;
1453: v_conv_date DATE;
1454:
1455: v_curr_conv_rate NUMBER;

Line 1999: conversion_date from oe_order_headers_all.

1995:
1996: 17.24/09/2003 Aiyer Bug #3139718 File Version : 616.4
1997:
1998: Added the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
1999: conversion_date from oe_order_headers_all.
2000: As a sales order shipment date can be different from its creation date, hence the conversion rate
2001: applicable on the date of shipment should be considerd for all processing rather than the creation
2002: date of the Sales order.
2003: Added the procedure call jai_cmn_utils_pkg.currency_conversion to calculated the currency conversion rate.