EBS: PO单据类型查询
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 | -- PO>>设置>>采购>>单据类型 ; SELECT pdt.document_type_code, pdt.org_id, pdt.document_subtype, pdt.document_template_code, pdt.contract_template_code, xtv1.template_name AS document_types_layout, xtv2.template_name AS contract_terms_layout, plc1.displayed_field || ' ' || plc2.displayed_field AS "类型" , --TYPE, decode(pdt.document_type_code, 'RFQ' , decode(pdt.document_subtype, 'STANDARD' , 'DeleteDisabled' , 'CATALOG' , 'DeleteDisabled' , 'BID' , 'DeleteDisabled' , 'DeleteEnabled' ), 'QUOTATION' , decode(pdt.document_subtype, 'STANDARD' , 'DeleteDisabled' , 'CATALOG' , 'DeleteDisabled' , 'BID' , 'DeleteDisabled' , 'DeleteEnabled' ), 'DeleteDisabled' ) AS delete_switcher, pdt.type_name, -- pdt.document_type_code, -- pdt.document_subtype, pdt.type_name as "单据名" , pdt.ARCHIVE_EXTERNAL_REVISION_CODE, pdt.CAN_PREPARER_APPROVE_FLAG AS "责任人可以审批" , pdt.CAN_APPROVER_MODIFY_DOC_FLAG AS "责任人可以修改" , DECODE(pdt.FORWARDING_MODE_CODE, 'HIERARCHY' , '层次结构' , 'DIRECT' , '直接' ,pdt.FORWARDING_MODE_CODE) AS "转发方式" , pdt.CAN_CHANGE_FORWARD_FROM_FLAG AS "可以更改转发人" , pdt.CAN_CHANGE_FORWARD_TO_FLAG AS "可以更改转发接收人" , pdt.CAN_CHANGE_APPROVAL_PATH_FLAG AS "可以更改审批层次结构" , pdt.QUOTATION_CLASS_CODE, pdt.DEFAULT_APPROVAL_PATH_ID AS "默认层次结构ID" , ( SELECT NAME FROM PER_POSITION_STRUCTURES_V PPS WHERE PPS.position_structure_id = pdt.DEFAULT_APPROVAL_PATH_ID AND ROWNUM= 1 ) AS "默认层次结构" , pdt.SECURITY_LEVEL_CODE AS "安全级别" , pdt.ACCESS_LEVEL_CODE AS "访问级别" , pdt.DISABLED_FLAG, DECODE(pdt.WF_APPROVAL_ITEMTYPE, 'REQAPPRV' , '申请' , 'POREQCHA' , '申请人更改订单审批' , 'PORPOCHA' , '申请人的PO更改审批' , pdt.WF_APPROVAL_ITEMTYPE ) AS "审批工作流" , DECODE(pdt.WF_APPROVAL_PROCESS, 'MAIN_REQAPPRV_PROCESS' , '主要申请审批' ,pdt.WF_APPROVAL_PROCESS) AS "工作流启动流程" , DECODE(pdt.WF_CREATEDOC_ITEMTYPE, 'CREATEPO' , 'PO 创建单据' ,pdt.WF_CREATEDOC_ITEMTYPE) AS "自动创建工作流" , DECODE(pdt.WF_CREATEDOC_PROCESS, 'OVERALL_AUTOCREATE_PROCESS' , '总体单据创建/启动审批' , pdt.WF_CREATEDOC_PROCESS ) AS "自创工作流启动流程" , --"自动创建工作流启动流程", pdt.AME_TRANSACTION_TYPE AS "审批事务处理类型" , pdt.USE_CONTRACT_FOR_SOURCING_FLAG, pdt.INCLUDE_NONCATALOG_FLAG, pdt.DOCUMENT_TEMPLATE_CODE, pdt.CONTRACT_TEMPLATE_CODE, ( SELECT HOU. NAME FROM HR_ORGANIZATION_UNITS HOU WHERE ORGANIZATION_ID = pdt.org_id ) AS "组织" , pdt.last_update_date FROM po_document_types_all_vl pdt, xdo_templates_vl xtv1, xdo_templates_vl xtv2, po_lookup_codes plc1, po_lookup_codes plc2 WHERE xtv1.template_code(+) = pdt.document_template_code AND xtv2.template_code(+) = pdt.contract_template_code AND pdt.document_type_code = plc1.lookup_code AND plc1.lookup_type = 'DOCUMENT TYPE' AND pdt.document_subtype = plc2.lookup_code AND plc2.lookup_type = decode(pdt.document_type_code, 'REQUISITION' , 'REQUISITION TYPE' , 'RFQ' , 'RFQ SUBTYPE' , 'QUOTATION' , 'QUOTATION SUBTYPE' , 'DOCUMENT SUBTYPE' ) -- AND pdt.org_id =281 ORDER BY pdt.org_id , pdt.last_update_date |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了