APPS.OPI_EDW_COGS_F_SZ dependencies on WSH_DELIVERY_DETAILS

Line 15: wsh_delivery_details wdd,

11: FROM
12: oe_order_headers_all h,
13: oe_order_lines_all pl,
14: oe_order_lines_all l,
15: wsh_delivery_details wdd,
16: mtl_transaction_accounts mta,
17: mtl_material_transactions mmt
18: where mmt.transaction_source_type_id = 2
19: and mta.transaction_source_type_id = 2

Line 160: FROM wsh_delivery_details

156: CURSOR c_wdd IS
157: SELECT avg(nvl(vsize(lot_number), 0)) LOT,
158: avg(nvl(vsize(revision), 0)) REVISION,
159: avg(nvl(vsize(serial_number), 0)) SERIAL_NUMBER
160: FROM wsh_delivery_details
161: WHERE last_update_date between p_from_date and p_to_date;
162:
163: CURSOR c_wnd IS
164: SELECT avg(nvl(vsize(waybill), 0)) waybill