purchaseorder一请购订单poporequisitionheadersall请购单题头表poporequisitionlinesall请购单行表poporeqdistributionsall请购单分配表请购订单关联erpopoheadersall采购订单题头表popolinesall采购订单行明细表popolinelocationsall采购订单的发运表po科目的计算单价priceoverridepopodistributionsall采购订单的分配表poporeleasesall...
PREPARER_ID NUMBER 准备人ID(可与HR.PER_PEOPLE_F.PERSON_ID关联) 表名: po.po_requisition_lines_all 说明: 采购请求明细 REQUISITION_LINE_ID NUMBER PR行ID REQUISITION_HEADER_ID NUMBER PR头ID LINE_NUM NUMBER 栏目 LINE_TYPE_ID NUMBER 行类别 CATEGORY_ID NUMBER 归类标识码 ITEM_DESCRIPTION VARCHAR2...
4. You need to list those PR which havn’t auto created to PO.(Purchase Requisition without a Purchase Order) PR without PO 5. You need to list all information form PR to PO …as a requisition moved from different stages till converting into PR. This query capture all details related to...
po_distributions_alld, po_req_distributions_allrd, po_requisition_lines_allrl, po_requisition_headers_allr wherep.po_header_id=d.po_header_id andd.req_distribution_id=rd.distribution_id andrd.requisition_line_id=rl.requisition_line_id andrl.requisition_header_id=r.requisition_header_id
BaseTable:PO_VENDOR_SITES_ALL 1-4 設定批准的供應商列表 • PO:SupplyBase→ApprovedSupplierList BaseTable:PO_APPROVED_SUPPLIER_LIST 1-5 設定來源補充規則 • PO:SupplyBase→SourcingRules BaseTable:MRP_SOURCING_RULES BaseTable:MRP_SR_RECEIPT_ORG BaseTable:MRP_SR_SOURCE_ORG 1-6 分配來源補充規則...
手工測試insert po_requisitions_interface_all,跑request(requisition import)(create release). 也可以自己寫一個request:先寫一個procedure,在里面調用包 fnd_request.submit_request。如: fnd_request.submit_request('PO', 'REQIMPORT', -- program short name of 'Requisition Import' null, sysdate, false, nu...
主键是REQUISITION_LINE_ID. PO_REQ_DISTRIBUTIONS_ALL 此表存储会计分录信息,与每条请购行相关。每条请 购行,必需至少有一条会计分录。每条记录包含会计 弹性域ID和请购行数量。是三个存储请购信息的表之 一一。。 主键是DISTRIBUTION_ID. MTL_SUPPLY表更新 – 批准申请或采购订单/在途发运时创建记录 接收接收/...
You need one row for each requisition distribution you create. Each row includes the Accounting Flexfield ID and requisition line quantity. . PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible...
EBAN Purchase requisition EBKN Purchase Requisition Account Assignment 8 Warehouse Management (WM) : 8.1 Transfer requirement LTBK Transfer requirement - header LTBP Transfer requirement - item 8.2 Transfer order LTAK Transfer order - header LTAP Transfer order - item 8.3 Master data - stock positions...
cost distribution TM 1 Cost Estimate for Sales order Item 3 Cost plan 1 CPI 1 CRM_PRICING_CUSTOMER_USER_EXIT 1 Custom Table Creation 1 Customer Consignment stock 3 Customer Screen in Production Order 1 Customizing 1 cyber security 1 Data Analytics 1 Data Analytics & AI 1 ...