[Home] [Help] [Dependency Information]
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|