VIEW: APPS.WSH_BIS_FILL_RATE_V

Source

View Text - Preformatted

SELECT ph.warehouse_id warehouse_id, ph.creation_date date_printed, dep.date_closed date_closed, l.date_requested_current request_date, pl.schedule_date schedule_date, l.promise_date promise_date, decode(pl.included_item_flag, 'Y', 0, nvl(pld.shipped_quantity,0) * l.selling_price) shipment_value, h.customer_id customer_id, h.currency_code line_currency, l.org_id ou_id from so_picking_batches_all pb, so_picking_headers_all ph, so_picking_lines_all pl, so_picking_line_details pld, so_lines_all l, so_headers_all h, wsh_departures dep, mtl_system_items si where pb.batch_id = ph.batch_id and ph.picking_header_id = pl.picking_header_id and pl.picking_line_id = pld.picking_line_id and pl.order_line_id = l.line_id and pld.departure_id = dep.departure_id(+) and pld.pick_slip_number is not null and pl.inventory_item_id = si.inventory_item_id and ph.warehouse_id = si.organization_id and l.header_id = h.header_id

View Text - HTML Formatted

SELECT PH.WAREHOUSE_ID WAREHOUSE_ID
, PH.CREATION_DATE DATE_PRINTED
, DEP.DATE_CLOSED DATE_CLOSED
, L.DATE_REQUESTED_CURRENT REQUEST_DATE
, PL.SCHEDULE_DATE SCHEDULE_DATE
, L.PROMISE_DATE PROMISE_DATE
, DECODE(PL.INCLUDED_ITEM_FLAG
, 'Y'
, 0
, NVL(PLD.SHIPPED_QUANTITY
, 0) * L.SELLING_PRICE) SHIPMENT_VALUE
, H.CUSTOMER_ID CUSTOMER_ID
, H.CURRENCY_CODE LINE_CURRENCY
, L.ORG_ID OU_ID
FROM SO_PICKING_BATCHES_ALL PB
, SO_PICKING_HEADERS_ALL PH
, SO_PICKING_LINES_ALL PL
, SO_PICKING_LINE_DETAILS PLD
, SO_LINES_ALL L
, SO_HEADERS_ALL H
, WSH_DEPARTURES DEP
, MTL_SYSTEM_ITEMS SI
WHERE PB.BATCH_ID = PH.BATCH_ID
AND PH.PICKING_HEADER_ID = PL.PICKING_HEADER_ID
AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
AND PL.ORDER_LINE_ID = L.LINE_ID
AND PLD.DEPARTURE_ID = DEP.DEPARTURE_ID(+)
AND PLD.PICK_SLIP_NUMBER IS NOT NULL
AND PL.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND PH.WAREHOUSE_ID = SI.ORGANIZATION_ID
AND L.HEADER_ID = H.HEADER_ID