APPS.JAI_OM_RMA_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 39: v_category oe_order_headers_all.order_category_code % TYPE;

35: p_source_document_type_id NUMBER,
36: p_line_category_code OE_ORDER_LINES_ALL.LINE_CATEGORY_CODE%TYPE
37: )
38: IS
39: v_category oe_order_headers_all.order_category_code % TYPE;
40: v_order_number oe_order_headers_all.order_number % TYPE;
41: v_ord_inv_quantity oe_order_lines_all.ordered_quantity % TYPE;
42: v_old_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
43: v_new_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

Line 40: v_order_number oe_order_headers_all.order_number % TYPE;

36: p_line_category_code OE_ORDER_LINES_ALL.LINE_CATEGORY_CODE%TYPE
37: )
38: IS
39: v_category oe_order_headers_all.order_category_code % TYPE;
40: v_order_number oe_order_headers_all.order_number % TYPE;
41: v_ord_inv_quantity oe_order_lines_all.ordered_quantity % TYPE;
42: v_old_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
43: v_new_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
44: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

Line 118: oe_order_headers_all

114: Cursor c_ordered_date_cur(v_header_id number) is
115: select
116: ordered_date
117: from
118: oe_order_headers_all
119: where
120: header_id = v_header_id;
121:
122: -- following cursor is used to get the ship confirm date based on the delivery detail id

Line 506: FROM oe_order_headers_all

502:
503: END LOOP;
504:
505: FOR date_rec IN (SELECT ordered_date
506: FROM oe_order_headers_all
507: WHERE header_id = p_header_id)
508: LOOP
509: v_date_ordered := date_rec.ordered_date;
510: END LOOP;

Line 579: ----------------------------- For picking order category from oe_order_headers_all ------------------

575:
576: BEGIN
577: v_rma_quantity_uom := p_uom; --Ramananda for File.Sql.35
578:
579: ----------------------------- For picking order category from oe_order_headers_all ------------------
580: IF p_header_id IS NOT NULL
581: THEN
582: FOR order_rec IN(SELECT order_category_code,
583: order_number,

Line 585: FROM oe_order_headers_all

581: THEN
582: FOR order_rec IN(SELECT order_category_code,
583: order_number,
584: ROWID
585: FROM oe_order_headers_all
586: WHERE header_id = P_header_id)
587: LOOP
588: v_category := order_rec.order_category_code;
589: v_order_number := order_rec.order_number;