[Home] [Help]
262: ,OH.SOLD_TO_ORG_ID
263: ,OH.SHIP_TO_ORG_ID
264: ,OH.HEADER_ID
265: ,OH.ORDER_NUMBER
266: FROM OE_ORDER_HEADERS OH
267: WHERE OH.HEADER_ID between NVL(trim(pn_header_id_from),OH.HEADER_ID)
268: and NVL(trim(pn_header_id_to),OH.HEADER_ID)
269: AND OH.SOLD_TO_ORG_ID = NVL(pn_customer_id,OH.SOLD_TO_ORG_ID)
270: AND OH.order_type_id = NVL(pn_order_type_id,OH.order_type_id)
274: -- The status should not be cancelled or closed.
275: CURSOR get_process_order_lock_cur ( pn_so_header_id IN NUMBER)
276: IS
277: SELECT OH.HEADER_ID
278: FROM OE_ORDER_HEADERS OH
279: WHERE OH.HEADER_ID = pn_so_header_id
280: FOR UPDATE;
281:
282: -- Cursor used to get the details of open order lines by header id.
328: lb_need_update BOOLEAN;
329: ln_jai_line_tax_amount NUMBER;
330: lv_tax_difference_flag VARCHAR2(1) ;
331: lv_credit_setup_flag VARCHAR2(1) ;
332: lv_header_id OE_ORDER_HEADERS.HEADER_ID%TYPE;
333:
334: --Main Block
335: BEGIN
336:
502: ,LINE.LINE_ID LINE_ID
503: ,TAX.TAX_ID TAX_ID
504: ,TAX.TAX_AMOUNT TAX_AMOUNT
505: ,TAX.TAX_RATE TAX_RATE
506: FROM OE_ORDER_HEADERS HDR
507: ,OE_ORDER_LINES LINE
508: ,JAI_OM_OE_SO_TAXES TAX
509: ,JAI_CMN_TAXES_ALL JCTA
510: WHERE HDR.HEADER_ID = LINE.HEADER_ID
528: ,LINE.LINE_ID LINE_ID
529: ,TAX.TAX_ID TAX_ID
530: ,TAX.TAX_AMOUNT TAX_AMOUNT
531: ,TAX.TAX_RATE TAX_RATE
532: FROM OE_ORDER_HEADERS HDR
533: ,OE_ORDER_LINES LINE
534: ,JAI_OM_OE_RMA_TAXES TAX
535: ,JAI_CMN_TAXES_ALL JCTA
536: WHERE HDR.HEADER_ID = LINE.HEADER_ID
710: BEGIN
711: SELECT COUNT(wdd.delivery_detail_id)
712: INTO ln_count
713: FROM wsh_delivery_details wdd,
714: OE_ORDER_HEADERS oh,
715: OE_ORDER_LINES ol
716: WHERE wdd.source_header_number = oh.ORDER_NUMBER
717: AND wdd.source_header_id = oh.header_id
718: AND oh.header_id = ol.header_id