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
