eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WSH_OPSM_ASN_ITEMS_SPECIFIC_V

Object Details

Object Name:	WSH_OPSM_ASN_ITEMS_SPECIFIC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_OPSM_ASN_ITEMS_SPECIFIC_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SOURCE_CODE	CHAR	(2)
ORDER_HEADER_ID	NUMBER		Yes
ORDER_LINE_ID	NUMBER		Yes
SPLIT_FROM_LINE_ID	NUMBER
LINK_TO_LINE_ID	NUMBER
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)
ORDER_LINE_NUMBER	VARCHAR2	(40)
ORDER_DATE_TYPE_CODE	VARCHAR2	(30)
PROMISE_DATE	DATE
ITEM_TYPE_CODE_INT	VARCHAR2	(30)
UNIT_SELLING_PRICE	NUMBER
INVOICE_TO_ORG_ID	NUMBER
INVOICE_TO_CONTACT_ID	NUMBER
OPTION_FLAG	VARCHAR2	(1)
COMPONENT_CODE	VARCHAR2	(1000)
SCHED_GENERATION_DATE	DATE
SCHEDULE_REFERENCE_NUM	VARCHAR2	(35)
CUSTOMER_ITEM_REVISION	VARCHAR2	(3)
LETTER_CREDIT_EXPDT_EXT	DATE
LETTER_CREDIT_EXT	VARCHAR2	(35)
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

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
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      OPTION_FLAG
,      COMPONENT_CODE
,      SCHED_GENERATION_DATE
,      SCHEDULE_REFERENCE_NUM
,      CUSTOMER_ITEM_REVISION
,      LETTER_CREDIT_EXPDT_EXT
,      LETTER_CREDIT_EXT
,      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
FROM APPS.WSH_OPSM_ASN_ITEMS_SPECIFIC_V;

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ITEMS_SPECIFIC_V references the following:

APPS: OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; RLM_CUST_ITEM_CUM_KEYS_ALL; RLM_SCHEDULE_HEADERS_ALL; RLM_SCHEDULE_LINES_ALL

APPS.WSH_OPSM_ASN_ITEMS_SPECIFIC_V is referenced by following:

APPS: WSH_OPSM_ASN_ITEMS_V