Web - ADI使用手册

File Ref: 190976029.doc

以下是一个案例

Field Name Default Value Default Type Category Category Parameter Source Source Parameter Currency sob.currencycode Environment Accounting Date select to_char(sysdate,'yyyy-mm-dd') SQL from gl_period_statuses gps where gps.set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and gps.closing_status='O' and gps.application_id=101 and gps.start_date<=sysdate and gps.end_date>=sysdate union all select MAX(to_char(gps.end_date,'yyyy-mm-dd')) from gl_period_statuses gps where gps.set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and gps.closing_status='O' and gps.application_id=101 and gps.end_date<=sysdate

对于Parameter的默认类型，需要在Form Functions的Parameters字段中添加变量及赋值，如：&Source=Spreadsheet&Category=ZTE JE，这样当调用此功能时就会自动将预先的赋值传入工作表。

15 of 22

Company Confidential - For internal use only

3. Open and Closed Issues for this Deliverable

Open Issues

ID Issue Resolution Responsibility Target Date Impact Date

Closed Issues

ID Issue Resolution Responsibility Target Date Impact Date

File Ref: 190976029.doc

Company Confidential - For internal use only

16 of 22