[Home] [Help] [Dependency Information]
Object Name: | WSH_OPSM_ASN_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_OPSM_ASN_ITEMS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | Yes | ||
CONTAINER_INSTANCE_ID | NUMBER | |||
ITEM_ID | NUMBER | |||
SOLDTO_CUSTOMER_ID | NUMBER | |||
SOLDTO_CONTACT_ID | NUMBER | |||
ORDER_HEADER_ID | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
SALES_ORDER_NUMBER | VARCHAR2 | (150) | ||
ORDERTYPE | VARCHAR2 | (240) | ||
ORDER_LINE_NUMBER | VARCHAR2 | (40) | ||
DELIVERY_DETAIL_ID | NUMBER | Yes | ||
CUSTOMER_ITEM_ID | NUMBER | |||
REQUESTED_DATE | DATE | |||
PROMISE_DATE | DATE | |||
ORDERED_QUANTITY | NUMBER | |||
ORDER_QUANTITY_UOM | VARCHAR2 | (3) | ||
CANCELLED_QUANTITY | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | Yes | |
HAZARD_CLASS | VARCHAR2 | (40) | ||
ORGANIZATION_ID | NUMBER | |||
DESTINATION_CONT_ID | NUMBER | |||
INVOICE_TO_ORG_ID | NUMBER | |||
INVOICE_TO_CONTACT_ID | NUMBER | |||
ITEM | VARCHAR2 | (40) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
NET_WEIGHT | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (3) | ||
VOLUME | NUMBER | |||
VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
ITEM_DESCRIPTION | VARCHAR2 | (250) | ||
LOT_CONTROL_CODE | NUMBER | |||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
OPSM_INTEGRATED_FLAG | NUMBER | |||
SERIAL_TYPE | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, CONTAINER_INSTANCE_ID
, ITEM_ID
, SOLDTO_CUSTOMER_ID
, SOLDTO_CONTACT_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, SALES_ORDER_NUMBER
, ORDERTYPE
, ORDER_LINE_NUMBER
, DELIVERY_DETAIL_ID
, CUSTOMER_ITEM_ID
, REQUESTED_DATE
, PROMISE_DATE
, ORDERED_QUANTITY
, ORDER_QUANTITY_UOM
, CANCELLED_QUANTITY
, SHIPPED_QUANTITY
, SHIPPING_QUANTITY_UOM
, HAZARD_CLASS
, ORGANIZATION_ID
, DESTINATION_CONT_ID
, INVOICE_TO_ORG_ID
, INVOICE_TO_CONTACT_ID
, ITEM
, DESCRIPTION
, NET_WEIGHT
, WEIGHT_UOM
, VOLUME
, VOLUME_UOM_CODE
, PACKING_INSTRUCTIONS
, ITEM_DESCRIPTION
, LOT_CONTROL_CODE
, SERIAL_NUMBER_CONTROL_CODE
, OPSM_INTEGRATED_FLAG
, SERIAL_TYPE
FROM APPS.WSH_OPSM_ASN_ITEMS_V;
|
|
|