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

VIEW: APPS.PA_CUSTOMER_LOV_V

Object Details
Object Name: PA_CUSTOMER_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CUSTOMER_LOV_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360) Yes Customer Name
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer Number
CUSTOMER_ID NUMBER (15) Yes Identifier of Customer
LOCATION VARCHAR2 (40)
Site use identifier
ADDRESS1 VARCHAR2 (240)
First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
DETAILS VARCHAR2 (307)
STATUS VARCHAR2 (1)
Customer Status flag
SITE_USE_CODE VARCHAR2 (30)
PARTY_ID NUMBER (15) Yes
PARTY_TYPE VARCHAR2 (30) Yes
CUST_NAME_AND_NUMBER VARCHAR2 (392)
Customer Name and Number
BILL_TO_LOCATION VARCHAR2 (40)
Bill To Location
Query Text

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


SELECT CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_ID
,      LOCATION
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      DETAILS
,      STATUS
,      SITE_USE_CODE
,      PARTY_ID
,      PARTY_TYPE
,      CUST_NAME_AND_NUMBER
,      BILL_TO_LOCATION
FROM APPS.PA_CUSTOMER_LOV_V;

Dependencies

[top of page]

APPS.PA_CUSTOMER_LOV_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
ViewPA_CUSTOMERS_V

APPS.PA_CUSTOMER_LOV_V is not referenced by any database object