表名: po.po_requisition_headers_all 说明: 采购请求 REQUISITION_HEADER_ID NUMBER PR头标识码 SEGMENT1 VARCHAR2(20) PR号 ENABLE_FLAG VARCHAR2(1) 使能标志(Y/N) AUTHORIZATION_STATUS VARCHAR2(25) 批准标志(APPROVED/) TYPE_LOOKUP_CODE VARCHAR2(25) 类型(PURCHASE) REQUIST_ID NUMBER 请求标识码 CANC...
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...
purchaseorder一请购订单poporequisitionheadersall请购单题头表poporequisitionlinesall请购单行表poporeqdistributionsall请购单分配表请购订单关联erpopoheadersall采购订单题头表popolinesall采购订单行明细表popolinelocationsall采购订单的发运表po科目的计算单价priceoverridepopodistributionsall采购订单的分配表poporeleasesall...
I was asked to find all "OPEN" requisitions in my company. I noticed in requisition header table PO_REQUISITION_HEADERS_ALL, the CLOSED_CODE column can be NULL, "OPEN" and "FINALLY CLOSED". What does NULL value for CLOSED_CODE mean? Is the requisition considered open if its CLOSED_CODE ...
REQUISITION_HEADER_ID是系统生成的唯一请购单编号,对用户不可见。SEGMENT1是申请单的编号。 image.png SEGMENT1:编号 AUTHORIZATION_STATUS:审批状态 (处理中、批准……) CREATION_DATE:创建日期 image.png person_id:编制人 (因EBS里是ID,需要在per_people_f表里查找person_id字段,可以找出编制人信息) ...
select * from po_requisition_headers_all请求头 select * from po_requisition_lines_all请求行 select * from po_headers_all订单头 select * from po_lines_all订单行 select * from po_line_locations_all select * from po_distributions_all分配 ...
6.Identifying all PO’s which does not have any PR’s PO without Requisition 7. Relation between Requisition and PO tables Here is link: PO_DISTRIBUTIONS_ALL =>PO_HEADER_ID, REQ_DISTRIBUTION_ID PO_HEADERS_ALL=>PO_HEADER_ID, SEGMENT1 ...
whereLIN.SOURCE_DOCUMENT_LINE_ID=RQL.REQUISITION_LINE_ID andLIN.SOURCE_DOCUMENT_TYPE_ID=10) orDERBYRQH.REQUISITION_HEADER_ID,RQL.LINE_NUM; 2.关联PR的PO 程序代码 ---RelationwithRequistionandPO selectr.segment1"ReqNum", p.segment1"PONum" frompo_headers_allp, po_distributions_alld, ...
PO_REQUISITION_HEADERS_ALL is one of three tables storing requisition information. PO_REQUISITION_HEADERS_ALL corresponds to the Header region of the Requisitions window. . SEGMENT1 provides unique values for each row in the table in addition to REQUISITION_HEADER_ID. ...
ID=RQL.REQUISITION_LINE_ID andLIN.SOURCE_DOCUMENT_TYPE_ID=10) orDERBYRQH.REQUISITION_HEADER_ID,RQL.LINE_NUM; 2.关联PR的PO 程序代码 ---RelationwithRequistionandPO selectr.segment1"ReqNum", p.segment1"PONum" frompo_headers_allp, po_distributions_alld, po_req_distributions_allrd, po_req...