	ALL_CUSTOMERS

Item Location

ALL_CUSTOMERS

Columns

Name
ID
LNAME

Source Code

CREATE VIEW ALL_CUSTOMERS (ID, LNAME)
	AS SELECT ID, LNAME
	FROM CUSTOMER

References
The items listed in the matrix below are called / used by the View “ALL_CUSTOMERS”

Name	Types	Description
CUSTOMER	Table	Table
LNAME	Column	Virtual column

Impact Analysis
The items listed in the matrix below are using / calling the View “ALL_CUSTOMERS”

Name	Types	Description
<DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers.c1	Cursor	PLSQL Cursor defined in CUSTOMERS.GetAllCustomers
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname,lname, all_products.name, all_products.prod_size, all_products.id, product.n
<DEFAULT SCHEMA>.TRG_ORDER.Select	Select Statement	select fname, lname, name, prod_size into cust_fname, cust_lname, prod_name, prod_size
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname, all_products.name, all_products.prod_size, all_products.id,
<DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers.c1.Select	Select Statement	SELECT ID FROM ALL_CUSTOMERS
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname, name, prod_size into cust_fname, cust_lname, prod_name, prod_size fro