DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WSH_DSNO_ITEMS_V

Object Details
Object Name: WSH_DSNO_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_DSNO_ITEMS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER
Yes
CONTAINER_INSTANCE_ID NUMBER

ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER
Yes
DELIVERY_DETAIL_ID NUMBER
Yes
CUSTOMER_ITEM_ID NUMBER

SPLIT_FROM_LINE_ID NUMBER

ATO_LINE_ID NUMBER

LINK_TO_LINE_ID NUMBER

ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
ORDER_LINE_NUMBER VARCHAR2 (150)
CUSTOMER_PART_NUMBER VARCHAR2 (50)
SUPPLIER_PART_NUMBER VARCHAR2 (4000)
REQUESTED_DATE DATE

ORDER_DATE_TYPE_CODE VARCHAR2 (30)
PROMISE_DATE DATE

SHIPPED_QUANTITY NUMBER

ITEM_UOM_CODE_INT VARCHAR2 (3) Yes
CUSTOMER_MODEL_SERIAL_NUMBER VARCHAR2 (50)
COMMODITY_CODE_INT VARCHAR2 (30)
ITEM_TYPE_CODE_INT VARCHAR2 (30)
CONTAINER_ITEM_FLAG VARCHAR2 (1)
CONTAINER_TYPE_CODE_INT VARCHAR2 (30)
CUSTOMER_ORDER_FLAG VARCHAR2 (1) Yes
ORDERED_QUANTITY NUMBER

CANCELLED_QUANTITY NUMBER

PACKED_QUANTITY NUMBER

UNIT_LIST_PRICE NUMBER

UNIT_SELLING_PRICE NUMBER

OPTION_FLAG VARCHAR2 (1)
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
CUSTOMER_DOCK_CODE VARCHAR2 (50)
CUSTOMER_PRODUCTION_LINE VARCHAR2 (50)
CUSTOMER_JOB VARCHAR2 (50)
SHIPMENT_PRIORITY_CODE_INT VARCHAR2 (30)
SHIPMENT_CONFIRMED_DATE DATE

CUSTOMER_ITEM_DESCRIPTION VARCHAR2 (240)
COMPONENT_CODE VARCHAR2 (1000)
HAZARDOUS_MATERIAL_CODE_INT CHAR (2)
HAZARD_CLASS_INT VARCHAR2 (40)
HAZARD_CLASS_DESCRIPTION VARCHAR2 (240)
ORDER_LINE_PRICING_CONTEXT VARCHAR2 (30)
ORDER_LINE_PRICING_ATTRIBUTE1 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE2 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE3 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE4 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE5 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE6 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE7 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE8 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE9 VARCHAR2 (240)
ORDER_LINE_PRICING_ATTRIBUTE10 VARCHAR2 (240)
ORDER_LINE_CONTEXT VARCHAR2 (90)
ORDER_LINE_ATTRIBUTE1 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE2 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE3 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE4 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE5 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE6 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE7 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE8 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE9 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE10 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE11 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE12 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE13 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE14 VARCHAR2 (450)
ORDER_LINE_ATTRIBUTE15 VARCHAR2 (450)
OELINE_GLOBAL_ATTRIB_CATEGORY VARCHAR2 (30)
OELINE_GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
OELINE_GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
OELINE_INDUSTRY_CONTEXT VARCHAR2 (30)
OELINE_INDUSTRY_ATTRIBUTE1 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE2 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE3 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE4 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE5 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE6 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE7 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE8 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE9 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE10 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE11 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE12 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE13 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE14 VARCHAR2 (240)
OELINE_INDUSTRY_ATTRIBUTE15 VARCHAR2 (240)
DEL_DETAIL_ATTRIB_CATEGORY VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE1 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE2 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE3 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE4 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE5 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE6 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE7 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE8 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE9 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE10 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE11 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE12 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE13 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE14 VARCHAR2 (150)
DELIVERY_DETAIL_ATTRIBUTE15 VARCHAR2 (150)
LINE_PART_CATEGORY VARCHAR2 (30)
LINE_PART_ATTRIBUTE1 VARCHAR2 (240)
LINE_PART_ATTRIBUTE2 VARCHAR2 (240)
LINE_PART_ATTRIBUTE3 VARCHAR2 (240)
LINE_PART_ATTRIBUTE4 VARCHAR2 (240)
LINE_PART_ATTRIBUTE5 VARCHAR2 (240)
LINE_PART_ATTRIBUTE6 VARCHAR2 (240)
LINE_PART_ATTRIBUTE7 VARCHAR2 (240)
LINE_PART_ATTRIBUTE8 VARCHAR2 (240)
LINE_PART_ATTRIBUTE9 VARCHAR2 (240)
LINE_PART_ATTRIBUTE10 VARCHAR2 (240)
LINE_PART_ATTRIBUTE11 VARCHAR2 (240)
LINE_PART_ATTRIBUTE12 VARCHAR2 (240)
LINE_PART_ATTRIBUTE13 VARCHAR2 (240)
LINE_PART_ATTRIBUTE14 VARCHAR2 (240)
LINE_PART_ATTRIBUTE15 VARCHAR2 (240)
ORDER_LINE_TP_CONTEXT VARCHAR2 (30)
ORDER_LINE_TP_ATTRIBUTE1 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE2 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE3 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE4 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE5 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE6 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE7 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE8 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE9 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE10 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE11 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE12 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE13 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE14 VARCHAR2 (240)
ORDER_LINE_TP_ATTRIBUTE15 VARCHAR2 (240)
HEADER_REF_CODE_1 VARCHAR2 (3)
HEADER_REF_CODE_2 VARCHAR2 (3)
HEADER_REF_CODE_3 VARCHAR2 (3)
HEADER_REF_VALUE_1 VARCHAR2 (35)
HEADER_REF_VALUE_2 VARCHAR2 (35)
HEADER_REF_VALUE_3 VARCHAR2 (35)
SCHED_GENERATION_DATE DATE

SCHEDULE_REFERENCE_NUM VARCHAR2 (35)
COMMODITY_EXT VARCHAR2 (35)
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
CUST_MANUFACTURER_EXT VARCHAR2 (35)
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
RLM_INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
CUST_ORDER_NUM_EXT VARCHAR2 (35)
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
CUST_SET_NUM_EXT VARCHAR2 (35)
EQUIPMENT_CODE_EXT VARCHAR2 (3)
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
HANDLING_CODE_EXT VARCHAR2 (3)
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
HAZARD_CODE_EXT VARCHAR2 (10)
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
IMPORT_LICENSE_DATE_EXT DATE

IMPORT_LICENSE_EXT VARCHAR2 (35)
ITEM_DETAIL_REF_CODE_1 VARCHAR2 (3)
ITEM_DETAIL_REF_CODE_2 VARCHAR2 (3)
ITEM_DETAIL_REF_CODE_3 VARCHAR2 (3)
ITEM_DETAIL_REF_VALUE_1 VARCHAR2 (35)
ITEM_DETAIL_REF_VALUE_2 VARCHAR2 (35)
ITEM_DETAIL_REF_VALUE_3 VARCHAR2 (35)
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
TRANSPORT_METHOD_EXT VARCHAR2 (3)
ITEM_REF_CODE_1 VARCHAR2 (3)
ITEM_REF_CODE_2 VARCHAR2 (3)
ITEM_REF_CODE_3 VARCHAR2 (3)
ITEM_REF_VALUE_1 VARCHAR2 (35)
ITEM_REF_VALUE_2 VARCHAR2 (35)
ITEM_REF_VALUE_3 VARCHAR2 (35)
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
LETTER_CREDIT_EXPDT_EXT DATE

LETTER_CREDIT_EXT VARCHAR2 (35)
RLM_ATTRIBUTE_CATEGORY VARCHAR2 (30)
RLM_ATTRIBUTE1 VARCHAR2 (150)
RLM_ATTRIBUTE2 VARCHAR2 (150)
RLM_ATTRIBUTE3 VARCHAR2 (150)
RLM_ATTRIBUTE4 VARCHAR2 (150)
RLM_ATTRIBUTE5 VARCHAR2 (150)
RLM_ATTRIBUTE6 VARCHAR2 (150)
RLM_ATTRIBUTE7 VARCHAR2 (150)
RLM_ATTRIBUTE8 VARCHAR2 (150)
RLM_ATTRIBUTE9 VARCHAR2 (150)
RLM_ATTRIBUTE10 VARCHAR2 (150)
RLM_ATTRIBUTE11 VARCHAR2 (150)
RLM_ATTRIBUTE12 VARCHAR2 (150)
RLM_ATTRIBUTE13 VARCHAR2 (150)
RLM_ATTRIBUTE14 VARCHAR2 (150)
RLM_ATTRIBUTE15 VARCHAR2 (150)
PACKAGING_CODE_EXT VARCHAR2 (10)
PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
PULLSIGNAL_REF_NUM VARCHAR2 (150)
PULLSIGNAL_START_SERIAL VARCHAR2 (150)
PULLSIGNAL_END_SERIAL VARCHAR2 (150)
CUST_PO_RELEASE_NUM VARCHAR2 (35)
CUST_PO_DATE DATE

CUST_PO_LINE_NUM VARCHAR2 (50)
SUPPLIER_ITEM_EXT VARCHAR2 (35)
CUM_START_DATE DATE

ORDER_QUANTITY_UOM_INT VARCHAR2 (3)
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (50)
CUST_PO_NUMBER VARCHAR2 (50)
CUST_PAYMENT_TERMS_INT VARCHAR2 (4000)
FREIGHT_TERMS_CODE_INT VARCHAR2 (30)
FOB_POINT_CODE_INT VARCHAR2 (30)
ORGANIZATION_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DELIVERY_ID
,      CONTAINER_INSTANCE_ID
,      ITEM_ID
,      ITEM_DESCRIPTION
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      DELIVERY_DETAIL_ID
,      CUSTOMER_ITEM_ID
,      SPLIT_FROM_LINE_ID
,      ATO_LINE_ID
,      LINK_TO_LINE_ID
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      ORDER_LINE_NUMBER
,      CUSTOMER_PART_NUMBER
,      SUPPLIER_PART_NUMBER
,      REQUESTED_DATE
,      ORDER_DATE_TYPE_CODE
,      PROMISE_DATE
,      SHIPPED_QUANTITY
,      ITEM_UOM_CODE_INT
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      COMMODITY_CODE_INT
,      ITEM_TYPE_CODE_INT
,      CONTAINER_ITEM_FLAG
,      CONTAINER_TYPE_CODE_INT
,      CUSTOMER_ORDER_FLAG
,      ORDERED_QUANTITY
,      CANCELLED_QUANTITY
,      PACKED_QUANTITY
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      OPTION_FLAG
,      SHIP_MODEL_COMPLETE_FLAG
,      CUSTOMER_DOCK_CODE
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_JOB
,      SHIPMENT_PRIORITY_CODE_INT
,      SHIPMENT_CONFIRMED_DATE
,      CUSTOMER_ITEM_DESCRIPTION
,      COMPONENT_CODE
,      HAZARDOUS_MATERIAL_CODE_INT
,      HAZARD_CLASS_INT
,      HAZARD_CLASS_DESCRIPTION
,      ORDER_LINE_PRICING_CONTEXT
,      ORDER_LINE_PRICING_ATTRIBUTE1
,      ORDER_LINE_PRICING_ATTRIBUTE2
,      ORDER_LINE_PRICING_ATTRIBUTE3
,      ORDER_LINE_PRICING_ATTRIBUTE4
,      ORDER_LINE_PRICING_ATTRIBUTE5
,      ORDER_LINE_PRICING_ATTRIBUTE6
,      ORDER_LINE_PRICING_ATTRIBUTE7
,      ORDER_LINE_PRICING_ATTRIBUTE8
,      ORDER_LINE_PRICING_ATTRIBUTE9
,      ORDER_LINE_PRICING_ATTRIBUTE10
,      ORDER_LINE_CONTEXT
,      ORDER_LINE_ATTRIBUTE1
,      ORDER_LINE_ATTRIBUTE2
,      ORDER_LINE_ATTRIBUTE3
,      ORDER_LINE_ATTRIBUTE4
,      ORDER_LINE_ATTRIBUTE5
,      ORDER_LINE_ATTRIBUTE6
,      ORDER_LINE_ATTRIBUTE7
,      ORDER_LINE_ATTRIBUTE8
,      ORDER_LINE_ATTRIBUTE9
,      ORDER_LINE_ATTRIBUTE10
,      ORDER_LINE_ATTRIBUTE11
,      ORDER_LINE_ATTRIBUTE12
,      ORDER_LINE_ATTRIBUTE13
,      ORDER_LINE_ATTRIBUTE14
,      ORDER_LINE_ATTRIBUTE15
,      OELINE_GLOBAL_ATTRIB_CATEGORY
,      OELINE_GLOBAL_ATTRIBUTE1
,      OELINE_GLOBAL_ATTRIBUTE2
,      OELINE_GLOBAL_ATTRIBUTE3
,      OELINE_GLOBAL_ATTRIBUTE4
,      OELINE_GLOBAL_ATTRIBUTE5
,      OELINE_GLOBAL_ATTRIBUTE6
,      OELINE_GLOBAL_ATTRIBUTE7
,      OELINE_GLOBAL_ATTRIBUTE8
,      OELINE_GLOBAL_ATTRIBUTE9
,      OELINE_GLOBAL_ATTRIBUTE10
,      OELINE_GLOBAL_ATTRIBUTE11
,      OELINE_GLOBAL_ATTRIBUTE12
,      OELINE_GLOBAL_ATTRIBUTE13
,      OELINE_GLOBAL_ATTRIBUTE14
,      OELINE_GLOBAL_ATTRIBUTE15
,      OELINE_GLOBAL_ATTRIBUTE16
,      OELINE_GLOBAL_ATTRIBUTE17
,      OELINE_GLOBAL_ATTRIBUTE18
,      OELINE_GLOBAL_ATTRIBUTE19
,      OELINE_GLOBAL_ATTRIBUTE20
,      OELINE_INDUSTRY_CONTEXT
,      OELINE_INDUSTRY_ATTRIBUTE1
,      OELINE_INDUSTRY_ATTRIBUTE2
,      OELINE_INDUSTRY_ATTRIBUTE3
,      OELINE_INDUSTRY_ATTRIBUTE4
,      OELINE_INDUSTRY_ATTRIBUTE5
,      OELINE_INDUSTRY_ATTRIBUTE6
,      OELINE_INDUSTRY_ATTRIBUTE7
,      OELINE_INDUSTRY_ATTRIBUTE8
,      OELINE_INDUSTRY_ATTRIBUTE9
,      OELINE_INDUSTRY_ATTRIBUTE10
,      OELINE_INDUSTRY_ATTRIBUTE11
,      OELINE_INDUSTRY_ATTRIBUTE12
,      OELINE_INDUSTRY_ATTRIBUTE13
,      OELINE_INDUSTRY_ATTRIBUTE14
,      OELINE_INDUSTRY_ATTRIBUTE15
,      DEL_DETAIL_ATTRIB_CATEGORY
,      DELIVERY_DETAIL_ATTRIBUTE1
,      DELIVERY_DETAIL_ATTRIBUTE2
,      DELIVERY_DETAIL_ATTRIBUTE3
,      DELIVERY_DETAIL_ATTRIBUTE4
,      DELIVERY_DETAIL_ATTRIBUTE5
,      DELIVERY_DETAIL_ATTRIBUTE6
,      DELIVERY_DETAIL_ATTRIBUTE7
,      DELIVERY_DETAIL_ATTRIBUTE8
,      DELIVERY_DETAIL_ATTRIBUTE9
,      DELIVERY_DETAIL_ATTRIBUTE10
,      DELIVERY_DETAIL_ATTRIBUTE11
,      DELIVERY_DETAIL_ATTRIBUTE12
,      DELIVERY_DETAIL_ATTRIBUTE13
,      DELIVERY_DETAIL_ATTRIBUTE14
,      DELIVERY_DETAIL_ATTRIBUTE15
,      LINE_PART_CATEGORY
,      LINE_PART_ATTRIBUTE1
,      LINE_PART_ATTRIBUTE2
,      LINE_PART_ATTRIBUTE3
,      LINE_PART_ATTRIBUTE4
,      LINE_PART_ATTRIBUTE5
,      LINE_PART_ATTRIBUTE6
,      LINE_PART_ATTRIBUTE7
,      LINE_PART_ATTRIBUTE8
,      LINE_PART_ATTRIBUTE9
,      LINE_PART_ATTRIBUTE10
,      LINE_PART_ATTRIBUTE11
,      LINE_PART_ATTRIBUTE12
,      LINE_PART_ATTRIBUTE13
,      LINE_PART_ATTRIBUTE14
,      LINE_PART_ATTRIBUTE15
,      ORDER_LINE_TP_CONTEXT
,      ORDER_LINE_TP_ATTRIBUTE1
,      ORDER_LINE_TP_ATTRIBUTE2
,      ORDER_LINE_TP_ATTRIBUTE3
,      ORDER_LINE_TP_ATTRIBUTE4
,      ORDER_LINE_TP_ATTRIBUTE5
,      ORDER_LINE_TP_ATTRIBUTE6
,      ORDER_LINE_TP_ATTRIBUTE7
,      ORDER_LINE_TP_ATTRIBUTE8
,      ORDER_LINE_TP_ATTRIBUTE9
,      ORDER_LINE_TP_ATTRIBUTE10
,      ORDER_LINE_TP_ATTRIBUTE11
,      ORDER_LINE_TP_ATTRIBUTE12
,      ORDER_LINE_TP_ATTRIBUTE13
,      ORDER_LINE_TP_ATTRIBUTE14
,      ORDER_LINE_TP_ATTRIBUTE15
,      HEADER_REF_CODE_1
,      HEADER_REF_CODE_2
,      HEADER_REF_CODE_3
,      HEADER_REF_VALUE_1
,      HEADER_REF_VALUE_2
,      HEADER_REF_VALUE_3
,      SCHED_GENERATION_DATE
,      SCHEDULE_REFERENCE_NUM
,      COMMODITY_EXT
,      COUNTRY_OF_ORIGIN_EXT
,      CUST_ASSIGNED_ID_EXT
,      CUST_CONTRACT_NUM_EXT
,      CUST_MANUFACTURER_EXT
,      CUST_MODEL_NUMBER_EXT
,      RLM_INDUSTRY_ATTRIBUTE1
,      CUST_ORDER_NUM_EXT
,      CUST_PROCESS_NUM_EXT
,      CUST_SET_NUM_EXT
,      EQUIPMENT_CODE_EXT
,      EQUIPMENT_NUMBER_EXT
,      HANDLING_CODE_EXT
,      HAZARD_CODE_QUAL_EXT
,      HAZARD_CODE_EXT
,      HAZARD_DESCRIPTION_EXT
,      IMPORT_LICENSE_DATE_EXT
,      IMPORT_LICENSE_EXT
,      ITEM_DETAIL_REF_CODE_1
,      ITEM_DETAIL_REF_CODE_2
,      ITEM_DETAIL_REF_CODE_3
,      ITEM_DETAIL_REF_VALUE_1
,      ITEM_DETAIL_REF_VALUE_2
,      ITEM_DETAIL_REF_VALUE_3
,      ITEM_ENG_CNG_LVL_EXT
,      TRANSPORT_METHOD_EXT
,      ITEM_REF_CODE_1
,      ITEM_REF_CODE_2
,      ITEM_REF_CODE_3
,      ITEM_REF_VALUE_1
,      ITEM_REF_VALUE_2
,      ITEM_REF_VALUE_3
,      CUSTOMER_ITEM_REVISION
,      LETTER_CREDIT_EXPDT_EXT
,      LETTER_CREDIT_EXT
,      RLM_ATTRIBUTE_CATEGORY
,      RLM_ATTRIBUTE1
,      RLM_ATTRIBUTE2
,      RLM_ATTRIBUTE3
,      RLM_ATTRIBUTE4
,      RLM_ATTRIBUTE5
,      RLM_ATTRIBUTE6
,      RLM_ATTRIBUTE7
,      RLM_ATTRIBUTE8
,      RLM_ATTRIBUTE9
,      RLM_ATTRIBUTE10
,      RLM_ATTRIBUTE11
,      RLM_ATTRIBUTE12
,      RLM_ATTRIBUTE13
,      RLM_ATTRIBUTE14
,      RLM_ATTRIBUTE15
,      PACKAGING_CODE_EXT
,      PRIME_CONTRCTR_PART_EXT
,      PULLSIGNAL_REF_NUM
,      PULLSIGNAL_START_SERIAL
,      PULLSIGNAL_END_SERIAL
,      CUST_PO_RELEASE_NUM
,      CUST_PO_DATE
,      CUST_PO_LINE_NUM
,      SUPPLIER_ITEM_EXT
,      CUM_START_DATE
,      ORDER_QUANTITY_UOM_INT
,      CUST_PRODUCTION_SEQ_NUM
,      CUST_PO_NUMBER
,      CUST_PAYMENT_TERMS_INT
,      FREIGHT_TERMS_CODE_INT
,      FOB_POINT_CODE_INT
,      ORGANIZATION_ID
FROM APPS.WSH_DSNO_ITEMS_V;

Dependencies

[top of page]

APPS.WSH_DSNO_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageWMS_DEPLOY - show dependent code
ViewWSH_DSNO_ITEMS_COMM_V
ViewWSH_DSNO_ITEMS_SPECIFIC_V
PL/SQL PackageWSH_ECE_VIEWS_DEF - show dependent code

APPS.WSH_DSNO_ITEMS_V is not referenced by any database object