FND Design Data [Home] [Help]

View: WSH_BIS_FILL_RATE_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.WSH_BIS_FILL_RATE_V
View Text

SELECT DETAILS.ORGANIZATION_ID WAREHOUSE_ID
, DELIVERIES.CREATION_DATE DATE_PRINTED
, DELIVERIES.INITIAL_PICKUP_DATE DATE_CLOSED
, DETAILS.DATE_REQUESTED REQUEST_DATE
, DETAILS.DATE_SCHEDULED SCHEDULE_DATE
, LINES.PROMISE_DATE PROMISE_DATE
, DECODE(LINES.ITEM_TYPE_CODE
, 'INCLUDED'
, 0
, NVL(DETAILS.SHIPPED_QUANTITY
, 0)*LINES.UNIT_SELLING_PRICE) SHIPMENT_VALUE
, DETAILS.CUSTOMER_ID CUSTOMER_ID
, DELIVERIES.CURRENCY_CODE LINE_CURRENCY
, LINES.ORG_ID OU_ID
, DETAILS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
FROM WSH_NEW_DELIVERIES DELIVERIES
, WSH_DELIVERY_DETAILS DETAILS
, OE_ORDER_LINES_ALL LINES
, WSH_DELIVERY_ASSIGNMENTS ASSIGNMENTS
WHERE DETAILS.SOURCE_CODE='OE'
AND DETAILS.SOURCE_LINE_ID=LINES.LINE_ID
AND DELIVERIES.DELIVERY_ID(+)=ASSIGNMENTS.DELIVERY_ID AND ASSIGNMENTS.DELIVERY_DETAIL_ID(+)=DETAILS.DELIVERY_DETAIL_ID
AND DETAILS.RELEASED_STATUS IN ('S'
, 'Y')

Columns

Name
WAREHOUSE_ID
DATE_PRINTED
DATE_CLOSED
REQUEST_DATE
SCHEDULE_DATE
PROMISE_DATE
SHIPMENT_VALUE
CUSTOMER_ID
LINE_CURRENCY
OU_ID
INVENTORY_ITEM_ID