Line 32: -- Get the header_id from mtl_sales_orders using the ccid (dem_src_header)
28: (config_item_id = -1) THEN
29: RAISE parameter_error;
30: END IF;
31: 32: -- Get the header_id from mtl_sales_orders using the ccid (dem_src_header) 33:
34: stmt_number := 1;
35:
36: SELECT OEORD.HEADER_ID
Line 38: FROM MTL_SALES_ORDERS MTLSO,
34: stmt_number := 1;
35:
36: SELECT OEORD.HEADER_ID
37: INTO header_id 38: FROM MTL_SALES_ORDERS MTLSO, 39: SO_ORDER_TYPES_ALL OETYP,
40: SO_HEADERS_ALL OEORD
41: WHERE MTLSO.SALES_ORDER_ID = dem_src_header
42: AND OETYP.NAME = MTLSO.SEGMENT2
[Home] [Help]