View: WSH_OPSM_ASN_ITEMS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_OPSM_ASN_ITEMS_V

View Text

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