[Home] [Help] [Dependency Information]
Object Name: | WSH_CONSIGNEES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_CONSIGNEES_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | Customer or Vendor Id | ||
PARTY_NAME | VARCHAR2 | (50) | Customer or Supplier Name | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
TYPE_FLAG | CHAR | (1) | C or V | |
TYPE | CHAR | (8) | Customer or Supplier | |
CONSIGNEE_ID | VARCHAR2 | (42) | C-cust_acc_id or V-vendor_id |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_ID
, PARTY_NAME
, CUSTOMER_NUMBER
, TYPE_FLAG
, TYPE
, CONSIGNEE_ID
FROM APPS.WSH_CONSIGNEES_V;
APPS.WSH_CONSIGNEES_V is not referenced by any database object
|
|
|