账户别名杂项接收发放接口处理

《账户别名杂项接收发放接口处理》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、【账户别名杂项接收发放接口处理】【查找请求相关程序的方】处理事务处理接口【切换职责】：【A公司库存】【说明】：菜单栏位-----【查看】---【请求】----【查找】出现如下：工具栏：【帮助】----【历史记录】得到视图名称：FND_CONC_REQ_SUMMARY_V【通过PL/SQL工具】查看到视图的创建语句：SELECTR.ROWIDROW_ID,R.REQUEST_ID,R.PHASE_CODE,R.STATUS_CODE,R.PRIORITY_REQUEST_ID,R.PRIORITY,R.REQUEST

2、_DATE,R.REQUESTED_BY,R.REQUESTED_START_DATE,R.HOLD_FLAG,R.HAS_SUB_REQUEST,R.IS_SUB_REQUEST,R.UPDATE_PROTECTED,R.QUEUE_METHOD_CODE,R.RESPONSIBILITY_APPLICATION_ID,R.RESPONSIBILITY_ID,R.SAVE_OUTPUT_FLAG,R.LAST_UPDATE_DATE,R.LAST_UPDATED_BY,R.LAST_UPDATE_LOGIN,R.

3、PRINTER,R.PRINT_STYLE,R.PARENT_REQUEST_ID,R.CONTROLLING_MANAGER,R.ACTUAL_START_DATE,R.ACTUAL_COMPLETION_DATE,R.COMPLETION_TEXT,R.ARGUMENT_TEXT,R.IMPLICIT_CODE,R.REQUEST_TYPE,R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID,PB.CONCURRENT_PROGRAM_NAMEPROGRAM_SHO

4、RT_NAME,PB.EXECUTION_METHOD_CODE,PB.ENABLED_FLAGENABLED,DECODE(R.DESCRIPTION,NULL,PT.USER_CONCURRENT_PROGRAM_NAME,R.DESCRIPTION

5、

6、'('

7、

8、PT.USER_CONCURRENT_PROGRAM_NAME

9、

10、')')PROGRAM,PB.PRINTER_NAMEFCP_PRINTER,PB.OUTPUT_PRINT_STYLEFCP_PRINT_STYLE,PB.REQUIRED_STYLE

11、FCP_REQUIRED_STYLE,U.USER_NAMEREQUESTOR,S.USER_PRINTER_STYLE_NAMEUSER_PRINT_STYLE,R.DESCRIPTIONDESCRIPTION,PT.USER_CONCURRENT_PROGRAM_NAMEUSER_CONCURRENT_PROGRAM_NAMEFROMFND_CONCURRENT_PROGRAMS_TLPT,FND_CONCURRENT_PROGRAMSPB,FND_USERU,FND_PRINTER_STYLES_TLS,FN

12、D_CONCURRENT_REQUESTSRWHEREPB.APPLICATION_ID=R.PROGRAM_APPLICATION_IDANDPB.CONCURRENT_PROGRAM_ID=R.CONCURRENT_PROGRAM_IDANDPB.APPLICATION_ID=PT.APPLICATION_IDANDPB.CONCURRENT_PROGRAM_ID=PT.CONCURRENT_PROGRAM_IDANDPT.LANGUAGE=USERENV('LANG')ANDU.USER_ID=R.REQUE

13、STED_BYANDS.PRINTER_STYLE_NAME(+)=R.PRINT_STYLEANDS.LANGUAGE(+)=USERENV('LANG');这个两个表要用到：FND_CONCURRENT_PROGRAMS_TLFND_CONCURRENT_PROGRAMS根据文档得知处理请求名称为：并发请求ProcesstransactioninterfaceN:INV/Setup/Transactions/InterfaceManagers/Processtransactioninterface/Tools/

14、LaunchManager在PL/SQL中：select*fromFND_CONCURRENT_PROGRAMS_TLtwheret.user_concurrent_program_name='Processtransactioninterface';select*fromFND_CONCURRENT_PROGRAMStwheret.concurrent_p