VIEW: APPS.MST_DD_DELIVERY_DETAILS_V

Source

View Text - Preformatted

SELECT mdd.plan_id , mda.delivery_id , decode(mdd.container_flag,1,mda.delivery_detail_id,mda.parent_delivery_detail_id) , decode(mdd.split_from_delivery_detail_id,null,mdd.sr_delivery_detail_id,mdd.delivery_detail_id) , mdd.po_shipment_line_number , decode(mdd.container_flag,1,null,mdd.source_code) , mdd.source_header_number , mdd.source_line_number , mdd.tp_refer_header_number , mdd.reference_source_type , msikfv.concatenated_segments , msitl.description , substr(mst_wb_util.get_local_chardtzone(mdd.ship_from_location_id, mdd.earliest_pickup_date),1,40) , substr(mst_wb_util.get_local_chardtzone(mdd.ship_from_location_id, mdd.latest_pickup_date),1,40) , substr(mst_wb_util.get_local_chardtzone(mdd.ship_to_location_id, mdd.earliest_acceptable_date),1,40) , substr(mst_wb_util.get_local_chardtzone(mdd.ship_to_location_id, mdd.latest_acceptable_date),1,40) , mdd.earliest_pickup_date , mdd.latest_pickup_date , mdd.earliest_acceptable_date , mdd.latest_acceptable_date , nvl(mdd.gross_weight,0) , nvl(mdd.volume,0) , round(nvl(mdd.number_of_pallets,0)) , nvl(mdd.requested_quantity,0) , mp.weight_uom , mp.volume_uom from mst_plans mp , mst_delivery_assignments mda , mst_delivery_details mdd , mtl_system_items_kfv msikfv , mtl_system_items_tl msitl WHERE mdd.plan_id = mp.plan_id and mdd.plan_id = mda.plan_id and mdd.delivery_detail_id = mda.delivery_detail_id and (mdd.container_flag = 2 or mda.parent_delivery_detail_id is null) and mdd.inventory_item_id = msikfv.inventory_item_id and mdd.organization_id = msikfv.organization_id and mdd.inventory_item_id = msitl.inventory_item_id and mdd.organization_id = msitl.organization_id and msitl.language = userenv('LANG')

View Text - HTML Formatted

SELECT MDD.PLAN_ID
, MDA.DELIVERY_ID
, DECODE(MDD.CONTAINER_FLAG
, 1
, MDA.DELIVERY_DETAIL_ID
, MDA.PARENT_DELIVERY_DETAIL_ID)
, DECODE(MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, NULL
, MDD.SR_DELIVERY_DETAIL_ID
, MDD.DELIVERY_DETAIL_ID)
, MDD.PO_SHIPMENT_LINE_NUMBER
, DECODE(MDD.CONTAINER_FLAG
, 1
, NULL
, MDD.SOURCE_CODE)
, MDD.SOURCE_HEADER_NUMBER
, MDD.SOURCE_LINE_NUMBER
, MDD.TP_REFER_HEADER_NUMBER
, MDD.REFERENCE_SOURCE_TYPE
, MSIKFV.CONCATENATED_SEGMENTS
, MSITL.DESCRIPTION
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MDD.SHIP_FROM_LOCATION_ID
, MDD.EARLIEST_PICKUP_DATE)
, 1
, 40)
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MDD.SHIP_FROM_LOCATION_ID
, MDD.LATEST_PICKUP_DATE)
, 1
, 40)
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_ACCEPTABLE_DATE)
, 1
, 40)
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MDD.SHIP_TO_LOCATION_ID
, MDD.LATEST_ACCEPTABLE_DATE)
, 1
, 40)
, MDD.EARLIEST_PICKUP_DATE
, MDD.LATEST_PICKUP_DATE
, MDD.EARLIEST_ACCEPTABLE_DATE
, MDD.LATEST_ACCEPTABLE_DATE
, NVL(MDD.GROSS_WEIGHT
, 0)
, NVL(MDD.VOLUME
, 0)
, ROUND(NVL(MDD.NUMBER_OF_PALLETS
, 0))
, NVL(MDD.REQUESTED_QUANTITY
, 0)
, MP.WEIGHT_UOM
, MP.VOLUME_UOM
FROM MST_PLANS MP
, MST_DELIVERY_ASSIGNMENTS MDA
, MST_DELIVERY_DETAILS MDD
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, MTL_SYSTEM_ITEMS_TL MSITL
WHERE MDD.PLAN_ID = MP.PLAN_ID
AND MDD.PLAN_ID = MDA.PLAN_ID
AND MDD.DELIVERY_DETAIL_ID = MDA.DELIVERY_DETAIL_ID
AND (MDD.CONTAINER_FLAG = 2 OR MDA.PARENT_DELIVERY_DETAIL_ID IS NULL)
AND MDD.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MDD.INVENTORY_ITEM_ID = MSITL.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSITL.ORGANIZATION_ID
AND MSITL.LANGUAGE = USERENV('LANG')