[Home] [Help]
[Dependency Information]
VIEW: APPS.QA_CUSTOMERS_LOV_V
Object Details
Object Name: | QA_CUSTOMERS_LOV_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CUSTOMERS_LOV_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 |
CUSTOMER_ID |
NUMBER |
(15) |
Yes |
Customer ID |
PARTY_ID |
NUMBER |
(15) |
Yes |
|
CUSTOMER_NAME |
VARCHAR2 |
(360) |
Yes |
Customer name |
CUSTOMER_NUMBER |
VARCHAR2 |
(30) |
Yes |
Customer number |
STATUS |
VARCHAR2 |
(1) |
Yes |
Account status |
CUSTOMER_PROSPECT_CODE |
CHAR |
(8) |
|
Customer prospect code |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_ID
, PARTY_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, STATUS
, CUSTOMER_PROSPECT_CODE
FROM APPS.QA_CUSTOMERS_LOV_V;
Dependencies
[top of page]
APPS.QA_CUSTOMERS_LOV_V references the following:
-
APPS
-
HZ_CUST_ACCOUNTS
-
HZ_PARTIES
APPS.QA_CUSTOMERS_LOV_V is referenced by following:
-
APPS
-
QAFV_QUALITY_SPECIFICATIONS
-
QA_ERES_RCV_TRANS_INTERFACE_V
-
QA_ERES_SPECS_V
-
QA_ERES_WSH_NEW_DELIVERIES_V
-
QA_MQA_MWA_API
- show dependent code
-
QA_PLAN_ELEMENT_API
- show dependent code
-
QA_RESULTS_INTERFACE_PKG
- show dependent code
-
QA_SALES_ORDERS_LOV_V
-
QA_SPECS_PUB
- show dependent code