VIEW: APPS.WSH_OPSM_ASN_ITEMS_V

Source

View Text - Preformatted

SELECT  COMM.DELIVERY_ID              ,
        COMM.CONTAINER_INSTANCE_ID    ,
        COMM.ITEM_ID                  ,
        COMM.SOLDTO_CUSTOMER_ID       ,
        COMM.SOLDTO_CONTACT_ID        ,
        COMM.ORDER_HEADER_ID          ,
        COMM.ORDER_LINE_ID            ,
        COMM.SALES_ORDER_NUMBER       ,
        COMM.ORDERTYPE                ,
        SPEC.ORDER_LINE_NUMBER        ,
        COMM.DELIVERY_DETAIL_ID       ,
        COMM.CUSTOMER_ITEM_ID         ,
        COMM.REQUESTED_DATE           ,
        SPEC.PROMISE_DATE             ,
        COMM.ORDERED_QUANTITY         ,
        COMM.ORDER_QUANTITY_UOM_INT   ,
        COMM.CANCELLED_QUANTITY       ,
        COMM.SHIPPED_QUANTITY         ,
        COMM.ITEM_UOM_CODE_INT        ,
        COMM.HAZARD_CLASS_INT         ,
        COMM.ORGANIZATION_ID          ,
        COMM.DESTINATION_CONT_ID      ,
        SPEC.INVOICE_TO_ORG_ID        ,
        SPEC.INVOICE_TO_CONTACT_ID    ,
        COMM.CONCATENATED_SEGMENTS    ,
        COMM.DESCRIPTION              ,
        COMM.NET_WEIGHT               ,
        COMM.WEIGHT_UOM_CODE          ,
        COMM.VOLUME                   ,
        COMM.VOLUME_UOM_CODE          ,
        COMM.PACKING_INSTRUCTIONS     ,    
        COMM.ITEM_DESCRIPTION         ,    
        COMM.LOT_CONTROL_CODE         ,
        COMM.SERIAL_NUMBER_CONTROL_CODE,
        COMM.OPSM_INTEGRATED_FLAG     ,
        COMM.SERIAL_TYPE
  FROM  WSH_OPSM_ASN_ITEMS_COMM_V COMM     ,
        WSH_OPSM_ASN_ITEMS_SPECIFIC_V SPEC
 WHERE  COMM.ORDER_HEADER_ID     = SPEC.ORDER_HEADER_ID
   AND  COMM.SOURCE_CODE         = SPEC.SOURCE_CODE
   AND  COMM.ORDER_LINE_ID       = SPEC.ORDER_LINE_ID
ORDER BY ORDER_LINE_NUMBER
   

View Text - HTML Formatted

SELECT COMM.DELIVERY_ID
, COMM.CONTAINER_INSTANCE_ID
, COMM.ITEM_ID
, COMM.SOLDTO_CUSTOMER_ID
, COMM.SOLDTO_CONTACT_ID
, COMM.ORDER_HEADER_ID
, COMM.ORDER_LINE_ID
, COMM.SALES_ORDER_NUMBER
, COMM.ORDERTYPE
, SPEC.ORDER_LINE_NUMBER
, COMM.DELIVERY_DETAIL_ID
, COMM.CUSTOMER_ITEM_ID
, COMM.REQUESTED_DATE
, SPEC.PROMISE_DATE
, COMM.ORDERED_QUANTITY
, COMM.ORDER_QUANTITY_UOM_INT
, COMM.CANCELLED_QUANTITY
, COMM.SHIPPED_QUANTITY
, COMM.ITEM_UOM_CODE_INT
, COMM.HAZARD_CLASS_INT
, COMM.ORGANIZATION_ID
, COMM.DESTINATION_CONT_ID
, SPEC.INVOICE_TO_ORG_ID
, SPEC.INVOICE_TO_CONTACT_ID
, COMM.CONCATENATED_SEGMENTS
, COMM.DESCRIPTION
, COMM.NET_WEIGHT
, COMM.WEIGHT_UOM_CODE
, COMM.VOLUME
, COMM.VOLUME_UOM_CODE
, COMM.PACKING_INSTRUCTIONS
, COMM.ITEM_DESCRIPTION
, COMM.LOT_CONTROL_CODE
, COMM.SERIAL_NUMBER_CONTROL_CODE
, COMM.OPSM_INTEGRATED_FLAG
, COMM.SERIAL_TYPE
FROM WSH_OPSM_ASN_ITEMS_COMM_V COMM
, WSH_OPSM_ASN_ITEMS_SPECIFIC_V SPEC
WHERE COMM.ORDER_HEADER_ID = SPEC.ORDER_HEADER_ID
AND COMM.SOURCE_CODE = SPEC.SOURCE_CODE
AND COMM.ORDER_LINE_ID = SPEC.ORDER_LINE_ID ORDER BY ORDER_LINE_NUMBER