APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 188: FROM oe_order_headers_all

184: source_document_id, order_number, price_list_id,
185: order_category_code, orig_sys_document_ref, transactional_curr_code,
186: conversion_type_code, conversion_rate, conversion_rate_date,
187: nvl(ordered_date, creation_date)
188: FROM oe_order_headers_all
189: WHERE header_id = p_header_id;
190:
191: CURSOR soure_doc_cur(p_header_id NUMBER) IS
192: SELECT order_category_code

Line 193: FROM oe_order_headers_all

189: WHERE header_id = p_header_id;
190:
191: CURSOR soure_doc_cur(p_header_id NUMBER) IS
192: SELECT order_category_code
193: FROM oe_order_headers_all
194: WHERE header_id = p_header_id;
195:
196: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
197: SELECT NVL(cust_acct_site_id, 0) address_id

Line 215: FROM po_requisition_headers_all a, oe_order_headers_all b

211: CURSOR po_reqn_lines_count(p_requisition_number VARCHAR2) IS
212: SELECT count(1)
213: FROM JAI_PO_REQ_LINES
214: WHERE requisition_header_id IN ( SELECT requisition_header_id
215: FROM po_requisition_headers_all a, oe_order_headers_all b
216: WHERE A.segment1 = b.orig_sys_document_ref
217: AND A.segment1 = p_requisition_number );
218:
219:

Line 295: FROM oe_order_headers_all

291: -- Web Stores Order's Import
292: -- by Amit Chopra on 7th June 2000
293: CURSOR get_original_source IS
294: SELECT NVL(orig_sys_document_ref,'NON_IMPORT')
295: FROM oe_order_headers_all
296: WHERE header_id = v_header_id ;
297:
298: v_source_id NUMBER;
299: CURSOR get_source_id IS

Line 301: FROM oe_order_headers_all

297:
298: v_source_id NUMBER;
299: CURSOR get_source_id IS
300: SELECT order_source_id
301: FROM oe_order_headers_all
302: WHERE header_id = v_header_id;
303:
304: ---------------------------------
305: /* Declarations for Copy Order */

Line 317: FROM oe_order_headers_all

313: --2001/10/01 Anuradha Parthasarathy
314: v_source_order_category_code VARCHAR2(30);
315: CURSOR source_order_doc_cur(P_Source_Document_Id NUMBER) IS
316: SELECT order_category_code
317: FROM oe_order_headers_all
318: WHERE header_id = p_source_document_id;
319:
320: --2001/10/01 Anuradha Parthasarathy
321: CURSOR get_order_source_type(p_source_document_type_id NUMBER) IS

Line 1300: oe_order_headers_all

1296: IS
1297: SELECT
1298: ordered_date
1299: FROM
1300: oe_order_headers_all
1301: WHERE
1302: header_id = pr_new.header_id ;
1303:
1304: -- added by Allen Yang for bug 9691880 10-May-2010, begin

Line 1879: /* get the new order number from oe_order_headers_all*/

1875: FROM JAI_OM_OE_RMA_LINES
1876: WHERE rma_header_id = cp_rma_header_id
1877: AND rma_line_id = cp_rma_line_id;
1878:
1879: /* get the new order number from oe_order_headers_all*/
1880: CURSOR c_rma_number(cp_rma_header_id number) is
1881: SELECT order_number
1882: FROM oe_order_headers_all
1883: WHERE header_id = cp_rma_header_id;

Line 1882: FROM oe_order_headers_all

1878:
1879: /* get the new order number from oe_order_headers_all*/
1880: CURSOR c_rma_number(cp_rma_header_id number) is
1881: SELECT order_number
1882: FROM oe_order_headers_all
1883: WHERE header_id = cp_rma_header_id;
1884:
1885: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1886: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

Line 1886: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

1882: FROM oe_order_headers_all
1883: WHERE header_id = cp_rma_header_id;
1884:
1885: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1886: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1887:
1888: BEGIN
1889: pv_return_code := jai_constants.successful ;
1890:

Line 2022: /* get the new order number from oe_order_headers_all*/

2018: --this script will execute only for the return order context.
2019: DECLARE
2020:
2021:
2022: /* get the new order number from oe_order_headers_all*/
2023: CURSOR c_rma_number(cp_rma_header_id number) is
2024: SELECT order_number
2025: FROM oe_order_headers_all
2026: WHERE header_id = cp_rma_header_id;

Line 2025: FROM oe_order_headers_all

2021:
2022: /* get the new order number from oe_order_headers_all*/
2023: CURSOR c_rma_number(cp_rma_header_id number) is
2024: SELECT order_number
2025: FROM oe_order_headers_all
2026: WHERE header_id = cp_rma_header_id;
2027:
2028: -- get the details from JAI_OM_WSH_LINES_ALL table
2029: CURSOR cur_get_picking_lines(

Line 2217: oe_order_headers_all

2213: IS
2214: SELECT
2215: ordered_date
2216: FROM
2217: oe_order_headers_all
2218: WHERE
2219: header_id = pr_new.header_id ;
2220:
2221: -- added by Allen Yang for bug 9691880 10-May-2010, begin

Line 4406: FROM oe_order_headers_all

4402: CURSOR cur_get_order_header_info
4403: IS
4404: SELECT order_type_id
4405: , order_number
4406: FROM oe_order_headers_all
4407: WHERE header_id = ln_order_header_id;
4408:
4409: --Added by Bo Li for bug#10043656 Begin
4410: --------------------------------------------------

Line 4977: FROM OE_ORDER_HEADERS_ALL

4973: CONVERSION_RATE_DATE,
4974: SOLD_TO_ORG_ID,
4975: price_list_id,
4976: NVL(ORDERED_DATE, creation_date)
4977: FROM OE_ORDER_HEADERS_ALL
4978: WHERE header_id = p_header_id;
4979:
4980: CURSOR address_cur(p_ship_to_org_id IN NUMBER) IS
4981: SELECT NVL(cust_acct_site_id, 0) address_id

Line 5613: oe_order_headers_all

5609: Cursor c_ordered_date_cur is
5610: select
5611: ordered_date
5612: from
5613: oe_order_headers_all
5614: where
5615: header_id = pr_new.header_id;
5616:
5617: -- following cursor is used to get the ship confirm date based on the delivery detail id

Line 5668: v_ordered_Date oe_order_headers_all.ordered_date%type;

5664: ln_inventory_item_id NUMBER;
5665: ln_item_exists NUMBER;
5666: /*bug#8485149,end*/
5667:
5668: v_ordered_Date oe_order_headers_all.ordered_date%type;
5669: v_confirm_date wsh_new_deliveries.confirm_date%type;
5670: v_excise_return_days Number;
5671: v_sales_return_days Number;
5672: