Search found 1 match

by cmagesh
Fri Feb 19, 2010 2:35 pm
Forum: Reports (Only Oracle Apps Reports)
Topic: GL--- SUBLEDGER ALL LINE DRILLDOW QUERY
Replies: 1
Views: 6275

Hi,
This is wuld fetch the line Details from sub ledgers

SELECT NVL(SRC.USER_JE_SOURCE_NAME, '**********') SOURCE,
NVL(CAT.USER_JE_CATEGORY_NAME, '**********') CATEGORY,
JEL.PERIOD_NAME PERIOD_NAME,
GJBH.BATCH_NAME BATCH_NAME,
GJBH.HEADER_NAME HEADER_NAME,
JEL.DESCRIPTION DESCRIPTION,
GJBH ...