ACA_REPORT_PARAMETER_B

Table to store the report parameter scope and parameter names for mapping object context column names.

Details

• Schema: FUSION

• Object owner: ACA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ACA_REPORT_PARAMETER_B_PK	PARAMETER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARAMETER_ID	NUMBER		18	Yes	Primary Key. Internally generated ID which can be used as a foreign key.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REPORT_PATH_ID	NUMBER		18	Yes	Foreign key referenced from ACA_REPORT_PATH_B
PARAMETER_SCOPE	VARCHAR2	32		Yes	Refers to the lookup code from fnd lookup type ORA_ACA_REPORT_PARAMETER_SCOPE.
PARAMETER_CODE	VARCHAR2	100			This column type is dependent on Parameter_Scope LOV. If scope is ???Context Based???, this column displays Drop down LOV from fnd lookup type based on Report_Object_Code value in master table. If scope is ???User Entered???, this column is just input text field.
PARAMETER_OPERATOR	VARCHAR2	20			Refers the operator values like eq,neq,gt,lt etc., used to store the logical operations like equal, not equal, greater than,less than.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
PARAM_TYPE	VARCHAR2	50			Holds the report parameter type like EFF or DFF for Additional Info scope
PARAM1	VARCHAR2	100			Holds the attribute group code name for EFF or Context name for DFF
PARAM2	VARCHAR2	100			Holds attribute code name for EFF or Segment name for DFF
PARAM3	VARCHAR2	100			Holds item class code for EFF param type
PARAM4	VARCHAR2	100			Defines the usage level of EFF for Item eff, Rev item eff, supplier eff
PARAM5	VARCHAR2	100			Defined to hold any additional data required for report parameter value

Foreign Keys

Table	Foreign Table	Foreign Key Column
ACA_REPORT_PARAMETER_B	aca_report_path_b	REPORT_PATH_ID
aca_report_parameter_tl	aca_report_parameter_b	PARAMETER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ACA_REPORT_PARAMETER_B_N1	Non Unique	Default	REPORT_PATH_ID, PARAMETER_SCOPE, PARAMETER_CODE
ACA_REPORT_PARAMETER_B_U1	Unique	Default	PARAMETER_ID