DBA Data[Home] [Help]

VIEW: APPS.MTL_CYCLE_COUNT_ENTRIES1_DFV

Source

View Text - Preformatted

SELECT ROWID, COUNT_DATE_CURRENT, COUNTED_BY_EMPLOYEE_ID_DUMMY, REFERENCE_CURRENT, TRANSACTION_REASON_ID,  
 COUNTED_BY_EMPLOYEE_ID_DUMMY || '.' || REFERENCE_CURRENT || '.' || TRANSACTION_REASON_ID 
 FROM MTL_CYCLE_COUNT_ENTRIES
View Text - HTML Formatted

SELECT ROWID
, COUNT_DATE_CURRENT
, COUNTED_BY_EMPLOYEE_ID_DUMMY
, REFERENCE_CURRENT
, TRANSACTION_REASON_ID
, COUNTED_BY_EMPLOYEE_ID_DUMMY || '.' || REFERENCE_CURRENT || '.' || TRANSACTION_REASON_ID
FROM MTL_CYCLE_COUNT_ENTRIES