[Home] [Help]
View: JAI_OE_MATCH_LINES_V
View Text
SELECT WDD.ORGANIZATION_ID
, WDD.CUSTOMER_ID
, WDD.INVENTORY_ITEM_ID
, WDD.DELIVERY_DETAIL_ID
, WDD.SUBINVENTORY
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.REQUESTED_QUANTITY_UOM
, NVL(WDD.PICKED_QUANTITY
, WDD.REQUESTED_QUANTITY)
, WND.DELIVERY_ID
, WDD.SOURCE_HEADER_TYPE_ID
, WDD.ORG_ID
, WDD.SHIP_FROM_LOCATION_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_ASSIGNMENTS WDA
, JAI_INV_SUBINV_DTLS JSUBINV
, JAI_INV_ITM_SETUPS JAMSI
WHERE WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WND.ORGANIZATION_ID = WDD.ORGANIZATION_ID
AND WDD.SOURCE_CODE = 'OE'
AND WND.STATUS_CODE NOT IN ( 'CO'
, 'CL'
, 'IT' )
AND JSUBINV.SUB_INVENTORY_NAME = WDD.SUBINVENTORY
AND JSUBINV.LOCATION_ID = WDD.SHIP_FROM_LOCATION_ID
AND JSUBINV.TRADING = 'Y'
AND JAMSI.ORGANIZATION_ID = WDD.ORGANIZATION_ID
AND JAMSI.INVENTORY_ITEM_ID = WDD.INVENTORY_ITEM_ID
AND JAMSI.ITEM_TRADING_FLAG = 'Y'
AND JAMSI.EXCISE_FLAG = 'Y'
AND /* CBABU FOR BUG#2504343 */ NOT EXISTS ( SELECT 1
FROM JAI_CMN_MATCH_RECEIPTS
WHERE REF_LINE_ID = WDD.DELIVERY_DETAIL_ID
AND ORDER_INVOICE ='O'
AND SHIP_STATUS IS NULL )
Columns
Name |
ORGANIZATION_ID |
CUSTOMER_ID |
INVENTORY_ITEM_ID |
PICKING_LINE_ID |
SUBINVENTORY |
ORDER_NO |
ORDER_HEADER_ID |
LINE_ID |
UOM |
RELEASE_QTY |
DELIVERY_ID |
ORDER_TYPE_ID |
ORG_ID |
LOCATION_ID |