DBA Data[Home] [Help]

APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 552: oe_order_headers_all a ,

548: conversion_type_code ,
549: conversion_rate ,
550: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
551: FROM
552: oe_order_headers_all a ,
553: oe_order_lines_all b
554: WHERE
555: a.header_id = b.header_id AND
556: b.line_id = v_source_line_id AND

Line 561: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;

557: a.header_id = v_source_header_id ;
558:
559: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
560: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
561: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
562: v_conv_rate NUMBER;
563: v_conv_date DATE;
564:
565: v_curr_conv_rate NUMBER;

Line 2938: oe_order_headers_all a ,

2934: conversion_type_code ,
2935: conversion_rate ,
2936: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
2937: FROM
2938: oe_order_headers_all a ,
2939: oe_order_lines_all b
2940: WHERE
2941: a.header_id = b.header_id AND
2942: b.line_id = v_source_line_id AND

Line 2947: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;

2943: a.header_id = v_source_header_id ;
2944:
2945: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
2946: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
2947: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
2948: v_conv_rate NUMBER;
2949: v_conv_date DATE;
2950: v_curr_conv_rate NUMBER;
2951: