DBA Data[Home] [Help]

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 136: oe_order_headers_all

132: Cursor c_ordered_date_cur(v_header_id number) is
133: select
134: ordered_date
135: from
136: oe_order_headers_all
137: where
138: header_id = v_header_id;
139:
140: -- following cursor is used to get the ship confirm date based on the delivery detail id

Line 460: FROM oe_order_headers_all

456: v_vat_return_days := hr_rec.vat_return_days ;
457: END LOOP; -- hr_rec IN ......
458:
459: FOR date_rec IN (SELECT ordered_date
460: FROM oe_order_headers_all
461: WHERE header_id = p_header_id)
462: LOOP
463: v_date_ordered := date_rec.ordered_date;
464: END LOOP; -- date_rec IN ......

Line 742: FROM oe_order_headers_all

738:
739: END LOOP;
740:
741: FOR date_rec IN (SELECT ordered_date
742: FROM oe_order_headers_all
743: WHERE header_id = p_header_id)
744: LOOP
745: v_date_ordered := date_rec.ordered_date;
746: END LOOP;

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

811:
812: BEGIN
813: v_rma_quantity_uom := p_uom; --Ramananda for File.Sql.35
814:
815: ----------------------------- For picking order category from oe_order_headers_all ------------------
816: IF p_header_id IS NOT NULL
817: THEN
818: FOR order_rec IN(SELECT order_category_code,
819: order_number,

Line 821: FROM oe_order_headers_all

817: THEN
818: FOR order_rec IN(SELECT order_category_code,
819: order_number,
820: ROWID
821: FROM oe_order_headers_all
822: WHERE header_id = P_header_id)
823: LOOP
824: v_category := order_rec.order_category_code;
825: v_order_number := order_rec.order_number;