[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DSNO_ITEMS_SPECIFIC_V

Object Details

Object Name:	WSH_DSNO_ITEMS_SPECIFIC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DSNO_ITEMS_SPECIFIC_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

Query Text

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

SELECT SOURCE_CODE
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      SPLIT_FROM_LINE_ID
,      LINK_TO_LINE_ID
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      ORDER_LINE_NUMBER
,      ORDER_DATE_TYPE_CODE
,      PROMISE_DATE
,      ITEM_TYPE_CODE_INT
,      UNIT_SELLING_PRICE
,      OPTION_FLAG
,      COMPONENT_CODE
,      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
,      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
,      CUST_PAYMENT_TERMS_INT
FROM APPS.WSH_DSNO_ITEMS_SPECIFIC_V;

Dependencies

[top of page]

APPS

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

OKC_K_LINES_B

OKE_K_DELIVERABLES_B

OKE_K_HEADERS

RLM_CUST_ITEM_CUM_KEYS_ALL

RLM_SCHEDULE_HEADERS_ALL

RLM_SCHEDULE_LINES_ALL

WSH_ECE_VIEWS_DEF - show dependent code

APPS

WSH_DSNO_ITEMS_V