PLSQL
ERP
打开PLSQL
新建SQL窗口
输入代码(部要求自行修改):select prh.segment1 采购申请单号 ,trunc(prh.creation_date) 申请创建日期 ,trunc(prl.creation_date) 申请行创建日期 ,prl.line_num 申请行号 ,msi.segment1 物料 ,prl.item_description 说明 ,prl.quantity 数量 ,prl.unit_price 单价 ,prl.quantity * prl.unit_price 金额 ,trunc(prl.need_by_date) 需要日期 ,ppf1.full_name 申请人 ,gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7 || '.' || gcc.segment8 借记账户from po.po_requisition_headers_all prh ,po.po_requisition_lines_all prl ,po.po_req_distributions_all prd ,gl.gl_code_combinations gcc ,inv.mtl_system_items_b msi ,po_distributions_all pda ,apps.per_people_f ppf1where prh.requisition_header_id = prl.requisition_header_idand prh.preparer_id = ppf1.person_idand prh.creation_date between ppf1.effective_start_date and ppf1.effective_end_dateand prd.requisition_line_id = prl.requisition_line_idand prd.code_combination_id = gcc.code_combination_idand msi.inventory_item_id = prl.item_idand msi.organization_id = prl.destination_organization_idand pda.req_distribution_id(+) = prd.distribution_idand prh.authorization_status = 'APPROVED'and pda.po_distribution_id is nulland prl.closed_code is nulland nvl(prl.cancel_flag, 'N') <> 'Y'order by 1, 2, 3, 4
部分内容要自行修改,不要照搬哦。。。