Tuesday, October 24, 2017

Query behind User Status in Oracle User Form



 SELECT v.lookup_code, v.meaning
  FROM fnd_lookup_values_vl v
 WHERE v.lookup_type = 'FND_USRDEF_STATUS';

No comments:

Post a Comment

Query to get Unposted Journals in Oracle APPS R12

SELECT gjh.accrual_rev_flag accrual_rev_flag       ,gjh.accrual_rev_period_name accrual_rev_period_name   ,gjh.creation_date journal_creat...