Standard WHO Columns
The following are the Standard WHO Columns in most of the Oracle tables:
created_by
creation_date
last_update_date
last_updated_by
last_update_login
Use fnd_profile.VALUE ('USER_ID') for retrieving the user_id which will be used by created_by column.
Creation date and last_update_date will be normally SYSDATE.
last_updated_by is same as created_by
Use USERENV ('SESSIONID') for getting the last_update_login id.
Subscribe to:
Post Comments (Atom)
-
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
The profile information available in the HZ_CUSTOMER_PROFILES can be created in three levels namely Party, Customer Account and Customer...
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo...
Thanks for sharing these ideas about using marble in interior design.French neoclassical architecture
ReplyDeletestone column restoration
Haussmann-style facades
custom carved pillars
heritage building renovation
marble and limestone columns
architectural elements France
interior column decoration
load-bearing stone structures
local stone suppliers France