Alias: MFN#

(P2K_AM_FUNCTIONS)

Unique Keys: FUNCTION_NAME

ERD: ERD-AM15

A component of a product - can be screens, report

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
FUNCTION_NAME	Varchar2(30)	VARCHAR30	Y
MPD_ID	Number(10)	ID	Y	part of P2K_AM_PRODUCTS
MFN_ID	Number(10)	ID		extended by another P2K_AM_FUNCTIONS
DCR_ID	Number(10)	ID		default P2K_CM_CHANGE_REASONS
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CREATE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
DESCRIPTION	Varchar2(50)	DESCRIPTION	Y
FUNCTION_TYPE	Varchar2(2)	X_FUNCTION_TYPE	Y
FUNCTION_USAGE	Varchar2(2)	X_FUNCTION_USAGE	Y
FUNCTION_LEVEL	Varchar2(2)	X_FUNCTION_LEVEL
IMPLEMENTATION_NAME	Varchar2(200)	VARCHAR200
COMPUTER_LANGUAGE	Varchar2(2)	X_COMPUTER_LANGUAGE
PLSQL_BLOCK	Varchar2(30)	VARCHAR30
MENU_SEQUENCE	Number(5)	NUMBER5
CREATE_ALLOWED	Varchar2(1)	TOGGLE
RETRIEVE_ALLOWED	Varchar2(1)	TOGGLE
UPDATE_ALLOWED	Varchar2(1)	TOGGLE
DELETE_ALLOWED	Varchar2(1)	TOGGLE
WHERE_RUN	Varchar2(2)	X_WHERE_RUN
PRINT_ORIENTATION	Varchar2(9)	X_PRINT_ORIENTATION
PURPOSE	Varchar2(2000)	VARCHAR2000
ONLINE_OFFLINE	Varchar2(2)	X_ONLINE_OFFLINE
REPORT_MODE	Varchar2(10)	X_REPORT_MODE
FUNCTION_STYLE	Varchar2(2)	X_FUNCTION_STYLE
PA_ALLOWED	Varchar2(1)	TOGGLE
WEB_ADDRESS	Varchar2(200)	URL
MTD_ID	Number(10)	ID		maintains P2K_AM_TABLE_DETAILS
SPY_ID	Number(10)	ID		associated to P2K_SA_PA_TYPES
MLOV_ID	Number(10)	ID		link to P2K_AM_LIST_OF_VALUES
DESTINATION_FORMAT	Varchar2(10)	X_DESFORMAT
PROCESS_CANCEL_ALLOWED	Varchar2(1)	TOGGLE
REQUIRES_LOGIN	Varchar2(1)	TOGGLE

Derived Fields#

Column Name
DRV_COPY_AS_USER_DEFINED

User Fields: Not Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page