EBS-请求

1. CUX_AP_应付付款导入

   
   请求定义
   

   参数： P_PERIOD_NAME、 P_ORG_ID、 P_LEDGER_ID
   值集： CUX_AP_PERIOD

   
   值集
   值集定义

select *
from gl_period_statuses
where application_id = 200
and set_of_books_id = 2023
and closing_status not in ('F', 'C', 'N')
order by period_year desc, period_num desc;

默认参数
SELECT gps.PERIOD_NAME FROM gl_period_statuses gps WHERE gps.application_id = 200 AND gps.ledger_id = fnd_profile.value('GL_SET_OF_BKS_ID') AND nvl(gps.adjustment_period_flag, 'N') = 'N' AND trunc(SYSDATE) BETWEEN gps.start_date AND gps.end_date

CUX_AP_应付付款导入 ，2023, , 2020-03

2. 期间
   【财务管理员】-应付期间、总账期间打开或者关闭