Agenda The Relationship: FAS 52 and ASC 830 FAS 52, ASC 830, and IAS 21 are all accounting standards that deal with foreign currency translation and the effects of exchange rate changes on a company’s […]
First create a temp table to hold user responsibilities to be inactivated. 1 2 3 4 CREATE TABLE xxcb_user_resp ( user_name VARCHAR2(240), resp_name VARCHAR2(240) ) Then insert record into temp tables, you may prepare these […]
How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]
Enterprise Resource Planning and Integrations BlogSpot 