COUNTER

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   COUNTER

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
CPT	number		NOT NULL		Column
TABLE_CPT	nvarchar2		NOT NULL		Column

Indexes

No Data

Check Constraints

No Data

Triggers

Name	ANSI Nulls On	Quoted Identifier On	On	Description
COUNTER_UPDATE				after ; update

References
     The items listed in the matrix below are called / used by the Table “COUNTER”

Name	Types	Description
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object

Impact Analysis
     The items listed in the matrix below are using / calling the Table “COUNTER”

Name	Types	Description
<DEFAULT SCHEMA>.COUNTER_UPDATE	Trigger	Simple Trigger of AFTER "UPDATE ON COUNTER"
<DEFAULT SCHEMA>.COUNTER_UPDATE.NEW	PseudoRecord	COUNTER
<DEFAULT SCHEMA>.COUNTER_UPDATE.OLD	PseudoRecord	COUNTER
w_sheet_sales_order.dw_master.pfc_updateprep.Select	SQL Select Statement	SELECT "counter"."cpt" INTO :ll_counter FROM "counter" WHERE "counter"."table_cpt" =
w_sheet_sales_order.dw_master.pfc_updateprep.Update	SQL Update Statement	UPDATE "counter" SET "cpt" = cpt + 1 WHERE "counter"."table_cpt" = 'sales_order'