VIEW: APPS.QA_ERES_WSH_DELIVERABLES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)