[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
INTO l_num_rows1
FROM OE_ORDER_LINES_ALL l,
OE_ORDER_HEADERS_ALL h
WHERE l.header_id = h.header_id
AND h.booked_date IS NOT NULL
AND (h.last_update_date between p_from_date and p_to_date
OR l.last_update_date between p_from_date and p_to_date);
SELECT count(*)
INTO l_num_rows2
FROM RA_CUSTOMER_TRX_LINES_ALL ra,
OE_ORDER_HEADERS_ALL h,
OE_ORDER_LINES_ALL l
WHERE l.line_id = ra.interface_line_attribute6
AND l.header_id = h.header_id
AND h.booked_date IS NOT NULL
AND ra.interface_line_context = 'ORDER ENTRY'
AND (ra.last_update_date between p_from_date and p_to_date
OR l.last_update_date between p_from_date and p_to_date
OR h.last_update_date between p_from_date and p_to_date);
SELECT count(*)
INTO l_num_rows3
FROM MTL_RESERVATIONS mtl,
OE_ORDER_HEADERS_ALL h,
OE_ORDER_LINES_ALL l
WHERE l.line_id = mtl.demand_source_line_id
AND l.header_id = h.header_id
AND h.booked_date IS NOT NULL
AND mtl.reservation_quantity is not null
AND mtl.reservation_quantity <> 0
AND (mtl.last_update_date between p_from_date and p_to_date
OR l.last_update_date between p_from_date and p_to_date
OR h.last_update_date between p_from_date and p_to_date);
SELECT count(*)
INTO l_num_rows4
FROM oe_order_lines_history hist,
OE_ORDER_HEADERS_ALL h,
OE_ORDER_LINES_ALL l
WHERE hist.line_id = l.line_id
AND l.header_id = h.header_id
AND h.booked_date IS NOT NULL
AND hist.hist_type_code = 'CANCELLATION'
AND (hist.last_update_date between p_from_date and p_to_date
OR l.last_update_date between p_from_date and p_to_date
OR h.last_update_date between p_from_date and p_to_date);
x_LAST_UPDATE_DATE NUMBER;
SELECT nvl(avg(nvl(vsize(agreement_id),0)),0),
nvl(avg(nvl(vsize(line_id),0)),0),
nvl(avg(nvl(vsize(sold_to_org_id),0)),0),
nvl(avg(nvl(vsize(cust_po_number),0)),0),
nvl(avg(nvl(vsize(demand_class_code),0)),0),
nvl(avg(nvl(vsize(fulfilled_flag),0)),0),
nvl(avg(nvl(vsize(ship_from_org_id),0)),0),
nvl(avg(nvl(vsize(inventory_item_id),0)),0) + nvl(avg(nvl(vsize(ship_from_org_id),0)),0),
nvl(avg(nvl(vsize(org_id),0)),0),
nvl(avg(nvl(vsize(line_category_code),0)),0),
nvl(avg(nvl(vsize(price_list_id),0)),0),
nvl(avg(nvl(vsize(cancelled_quantity),0)),0),
nvl(avg(nvl(vsize(fulfilled_quantity),0)),0),
nvl(avg(nvl(vsize(ordered_quantity),0)),0),
nvl(avg(nvl(vsize(shipped_quantity),0)),0),
nvl(avg(nvl(vsize(return_reason_code),0)),0),
nvl(avg(nvl(vsize(salesrep_id),0)),0) + nvl(avg(nvl(vsize(org_id),0)),0),
nvl(avg(nvl(vsize(shippable_flag),0)),0),
nvl(avg(nvl(vsize(ship_to_org_id),0)),0),
nvl(avg(nvl(vsize(task_id),0)),0),
nvl(avg(nvl(vsize(unit_list_price),0)),0),
nvl(avg(nvl(vsize(unit_selling_price),0)),0),
nvl(avg(nvl(vsize(fulfillment_date),0)),0),
nvl(avg(nvl(vsize(actual_shipment_date),0)),0),
nvl(avg(nvl(vsize(last_update_date),0)),0),
nvl(avg(nvl(vsize(promise_date),0)),0),
nvl(avg(nvl(vsize(request_date),0)),0),
nvl(avg(nvl(vsize(schedule_ship_date),0)),0),
nvl(avg(nvl(vsize(item_type_code),0)),0)
FROM OE_ORDER_LINES_ALL
WHERE last_update_date BETWEEN p_from_date AND p_to_date;
SELECT nvl(avg(nvl(vsize(agreement_type_code),0)),0)
FROM OE_AGREEMENTS_B;
SELECT nvl(avg(nvl(vsize(invoice_to_org_id),0)),0),
nvl(avg(nvl(vsize(conversion_type_code),0)),0),
nvl(avg(nvl(vsize(transactional_curr_code),0)),0),
nvl(avg(nvl(vsize(header_id),0)),0),
nvl(avg(nvl(vsize(order_number),0)),0),
nvl(avg(nvl(vsize(sales_channel_code),0)),0),
nvl(avg(nvl(vsize(sold_to_org_id),0)),0),
nvl(avg(nvl(vsize(booked_date),0)),0),
nvl(avg(nvl(vsize(ordered_date),0)),0)
FROM OE_ORDER_HEADERS_ALL;
SELECT nvl(avg(nvl(vsize(conversion_rate),0)),0)
FROM GL_DAILY_RATES;
SELECT nvl(avg(nvl(vsize(period_set_name),0)),0) + nvl(avg(nvl(vsize(accounted_period_type),0)),0)
FROM GL_SETS_OF_BOOKS;
SELECT nvl(avg(nvl(vsize(cell_code),0)),0)
FROM ams_cells_all_b;
SELECT nvl(avg(nvl(vsize(activity_offer_id),0)),0)
FROM ams_act_offers;
SELECT nvl(avg(nvl(vsize(name),0)),0)
FROM OE_ORDER_SOURCES;
SELECT nvl(avg(nvl(vsize(name),0)),0)
FROM OE_TRANSACTION_TYPES_TL;
SELECT nvl(avg(nvl(vsize(quantity_invoiced),0)),0)
FROM RA_CUSTOMER_TRX_LINES_ALL;
SELECT nvl(avg(nvl(vsize(reservation_quantity),0)),0)
FROM MTL_RESERVATIONS;
SELECT nvl(avg(nvl(vsize(set_of_books_id),0)),0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL;
SELECT nvl(avg(nvl(vsize(cell_code),0)),0)
FROM ams_list_entries;
SELECT nvl(avg(nvl(vsize(item_cost),0)),0)
FROM cst_item_costs;
SELECT nvl(avg(nvl(vsize(UOM_EDW_BASE_UOM),0)),0)
FROM EDW_MTL_LOCAL_UOM_M;
SELECT nvl(avg(nvl(vsize(user_status_id),0)),0)
FROM ams_campaigns_all_b;
x_LAST_UPDATE_DATE, x_PROMISED_DATE, x_REQUESTED_DATE,
x_SCHEDULED_DATE, x_ITEM_TYPE_CODE;
ceil(x_LAST_UPDATE_DATE + 1) + ceil(x_QTY_RETURNED + 1) +
ceil(x_TOP_MODEL_FK + 1) + ceil(x_UNIT_LIST_PRC_G + 1) +
ceil(x_UNIT_SELL_PRC_G + 1) + ceil(x_PROMISED_DATE + 1) +
ceil(x_REQUESTED_DATE + 1) + ceil(x_SCHEDULED_DATE + 1) +
ceil(x_ITEM_TYPE_CODE + 1);