VIEW: APPS.MST_AD_DELIVERY_DETAILS_V

Source

View Text - Preformatted

SELECT mad.DELIVERY_DETAIL_ID ,mdd.SPLIT_FROM_DELIVERY_DETAIL_ID ,mdd.CONTAINER_FLAG ,mdd.SUPPLIER_ID VENDOR_ID ,mdd.ORGANIZATION_ID ,mdd.SHIP_FROM_LOCATION_ID ,mdd.DESTINATION_ORGANIZATION_ID ,mdd.CUSTOMER_ID ,mdd.SHIP_TO_LOCATION_ID ,mdd.EARLIEST_PICKUP_DATE EARLIEST_AVAILABLE_TO_SHIP ,mdd.LATEST_PICKUP_DATE LATEST_AVAILABLE_TO_SHIP ,mdd.EARLIEST_ACCEPTABLE_DATE EARLIEST_DELIVERY_DATE ,mdd.LATEST_ACCEPTABLE_DATE LATEST_DELIVERY_DATE ,mdd.NET_WEIGHT ,mdd.GROSS_WEIGHT ,mdd.VOLUME ,mdd.INVENTORY_ITEM_ID ,mdd.SHIP_SET_ID ,mdd.ARRIVAL_SET_ID ,mdd.SHIP_MODEL_COMPLETE_FLAG ,mdd.TOP_MODEL_LINE_ID ,mdd.ORG_ID ,mdd.FREIGHT_CLASS_CAT_ID ,mdd.COMMODITY_CODE_CAT_ID ,mdd.SOURCE_HEADER_NUMBER ,mdd.SOURCE_LINE_NUMBER ,mdd.TP_REFER_HEADER_NUMBER REFERENCE_HEADER_NUMBER ,mdd.TP_REFERENCE_LINE_NUMBER REFERENCE_LINE_NUMBER ,mdd.REFERENCE_SOURCE_TYPE ,mdd.REQUESTED_QUANTITY TP_QUANTITY ,mdd.SOURCE_CODE ,mdd.RELEASED_STATUS ,mdd.CONTAINER_TYPE_CODE ,mdd.CREATED_BY ,to_char(null) weight_uom_code ,to_char(null) volume_uom_code ,mdd.line_direction ,mdd.UNIT_PRICE ,to_char(null) CURRENCY_CODE ,mdd.PO_SHIPMENT_LINE_NUMBER ,mad.REFRESH_NUMBER ,mdd.ALLOCATED_COST ,mdd.plan_id PLAN_ID ,mdd.src_requested_quantity src_requested_quantity ,mdd.src_requested_quantity_uom src_requested_quantity_uom ,mdd.delivery_detail_id TP_DELIVERY_DETAIL_ID FROM MST_AD_DELIVERY_DETAILS mad ,MST_DELIVERY_DETAILS mdd WHERE mad.delivery_Detail_id = mdd.sr_delivery_detail_id

View Text - HTML Formatted

SELECT MAD.DELIVERY_DETAIL_ID
, MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, MDD.CONTAINER_FLAG
, MDD.SUPPLIER_ID VENDOR_ID
, MDD.ORGANIZATION_ID
, MDD.SHIP_FROM_LOCATION_ID
, MDD.DESTINATION_ORGANIZATION_ID
, MDD.CUSTOMER_ID
, MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_PICKUP_DATE EARLIEST_AVAILABLE_TO_SHIP
, MDD.LATEST_PICKUP_DATE LATEST_AVAILABLE_TO_SHIP
, MDD.EARLIEST_ACCEPTABLE_DATE EARLIEST_DELIVERY_DATE
, MDD.LATEST_ACCEPTABLE_DATE LATEST_DELIVERY_DATE
, MDD.NET_WEIGHT
, MDD.GROSS_WEIGHT
, MDD.VOLUME
, MDD.INVENTORY_ITEM_ID
, MDD.SHIP_SET_ID
, MDD.ARRIVAL_SET_ID
, MDD.SHIP_MODEL_COMPLETE_FLAG
, MDD.TOP_MODEL_LINE_ID
, MDD.ORG_ID
, MDD.FREIGHT_CLASS_CAT_ID
, MDD.COMMODITY_CODE_CAT_ID
, MDD.SOURCE_HEADER_NUMBER
, MDD.SOURCE_LINE_NUMBER
, MDD.TP_REFER_HEADER_NUMBER REFERENCE_HEADER_NUMBER
, MDD.TP_REFERENCE_LINE_NUMBER REFERENCE_LINE_NUMBER
, MDD.REFERENCE_SOURCE_TYPE
, MDD.REQUESTED_QUANTITY TP_QUANTITY
, MDD.SOURCE_CODE
, MDD.RELEASED_STATUS
, MDD.CONTAINER_TYPE_CODE
, MDD.CREATED_BY
, TO_CHAR(NULL) WEIGHT_UOM_CODE
, TO_CHAR(NULL) VOLUME_UOM_CODE
, MDD.LINE_DIRECTION
, MDD.UNIT_PRICE
, TO_CHAR(NULL) CURRENCY_CODE
, MDD.PO_SHIPMENT_LINE_NUMBER
, MAD.REFRESH_NUMBER
, MDD.ALLOCATED_COST
, MDD.PLAN_ID PLAN_ID
, MDD.SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY
, MDD.SRC_REQUESTED_QUANTITY_UOM SRC_REQUESTED_QUANTITY_UOM
, MDD.DELIVERY_DETAIL_ID TP_DELIVERY_DETAIL_ID
FROM MST_AD_DELIVERY_DETAILS MAD
, MST_DELIVERY_DETAILS MDD
WHERE MAD.DELIVERY_DETAIL_ID = MDD.SR_DELIVERY_DETAIL_ID