Product: | QA - Quality |
---|---|
Description: | shipping electronic record |
Implementation/DBA Data: | APPS.QA_ERES_WSH_DELIVERABLES_V |
SELECT WDDV.DELIVERY_ID
, WDDV.DELIVERY_DETAIL_ID
, WDDV.DELIVERY_LINE_ID
, DECODE(WDDV.TYPE
, 'C'
, WDDV.CONTAINER_NAME
, WDDV.DELIVERY_LINE_ID)
, QA_ERES_PKG.DECODE_WSH_RELEASED_STATUS( WDDV.SOURCE_CODE
, WDDV.RELEASED_STATUS
, WDDV.RELEASED_STATUS_NAME
, WDDV.INV_INTERFACED_FLAG
, WDDV.OE_INTERFACED_FLAG)
, WDDV.ORGANIZATION_ID
, WDDV.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, WDDV.ITEM_DESCRIPTION
, WDDV.REVISION
, WDDV.TRACKING_NUMBER
, WDDV.REQUESTED_QUANTITY
, WDDV.PICKED_QUANTITY
, WDDV.SHIPPED_QUANTITY
, WDDV.REQUESTED_QUANTITY_UOM
, WDDV.REQUESTED_QUANTITY2
, WDDV.SHIPPED_QUANTITY2
, WDDV.REQUESTED_QUANTITY_UOM2
, WDDV.MAXIMUM_LOAD_WEIGHT
, WDDV.GROSS_WEIGHT
, WDDV.TARE_WEIGHT
, WDDV.NET_WEIGHT
, WDDV.WEIGHT_UOM_CODE
, WDDV.MAXIMUM_VOLUME
, WDDV.VOLUME
, WDDV.VOLUME_UOM_CODE
, WSH_CONTAINER_UTILITIES.GET_CONT_NAME(WDDV.PARENT_CONTAINER_INSTANCE_ID)
, WSH_CONTAINER_UTILITIES.GET_CONT_NAME( WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID(WDDV.CONTAINER_INSTANCE_ID))
, WDDV.MASTER_SERIAL_NUMBER
, WDDV.SHIPPING_INSTRUCTIONS
, WDDV.PACKING_INSTRUCTIONS
, MP.ORGANIZATION_CODE
, HRORG.NAME
, WDDV.SUBINVENTORY
, QA_FLEX_UTIL.LOCATOR(WDDV.ORGANIZATION_ID
, WDDV.LOCATOR_ID)
, WDDV.LOT_NUMBER
, WDDV.CUSTOMER_REQUESTED_LOT_FLAG
, NULL
, WDDV.SERIAL_NUMBER
, WDDV.TO_SERIAL_NUMBER
, WDDV.PREFERRED_GRADE
, WL1.MEANING
, WDDV.SEAL_CODE
, WDDV.SOURCE_NAME
, WDDV.SOURCE_HEADER_NUMBER
, WDDV.SOURCE_HEADER_TYPE_NAME
, WDDV.SOURCE_LINE_NUMBER
, WDDV.SRC_REQUESTED_QUANTITY
, WDDV.SRC_REQUESTED_QUANTITY_UOM
, WDDV.SRC_REQUESTED_QUANTITY2
, WDDV.SRC_REQUESTED_QUANTITY_UOM2
, PPA.NAME
, PT.TASK_NUMBER
, WDDV.UNIT_NUMBER
, WDDV.DATE_REQUESTED
, WDDV.DATE_SCHEDULED
, MCI.CUSTOMER_ITEM_NUMBER
, MCI.CUSTOMER_ITEM_DESC
, WDDV.CUSTOMER_PROD_SEQ
, WDDV.CUSTOMER_DOCK_CODE
, WDDV.ATTRIBUTE1
, WDDV.ATTRIBUTE2
, WDDV.ATTRIBUTE3
, WDDV.ATTRIBUTE4
, WDDV.ATTRIBUTE5
, WDDV.ATTRIBUTE6
, WDDV.ATTRIBUTE7
, WDDV.ATTRIBUTE8
, WDDV.ATTRIBUTE9
, WDDV.ATTRIBUTE10
, WDDV.ATTRIBUTE11
, WDDV.ATTRIBUTE12
, WDDV.ATTRIBUTE13
, WDDV.ATTRIBUTE14
, WDDV.ATTRIBUTE15
, WDDV.ATTRIBUTE_CATEGORY
, WDDV.LAST_UPDATE_DATE
, WDDV.LAST_UPDATED_BY
, WDDV.LAST_UPDATE_LOGIN
, WDDV.CREATION_DATE
, WDDV.CREATED_BY
FROM WSH_DLVY_DELIVERABLES_V WDDV
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HRORG
, MTL_CUSTOMER_ITEMS MCI
, MTL_SYSTEM_ITEMS_KFV MSIK
, WSH_LOOKUPS WL1
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
WHERE WDDV.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND WDDV.ORGANIZATION_ID = HRORG.ORGANIZATION_ID(+)
AND USERENV('LANG') = HRORG.LANGUAGE(+)
AND WDDV.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID(+)
AND WDDV.ORGANIZATION_ID = MSIK.ORGANIZATION_ID(+)
AND WDDV.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID(+)
AND 'INSPECTION_STATUS' = WL1.LOOKUP_TYPE(+)
AND WDDV.INSPECTION_FLAG = WL1.LOOKUP_CODE(+)
AND WDDV.PROJECT_ID = PPA.PROJECT_ID(+)
AND WDDV.TASK_ID = PT.TASK_ID(+)