POR_REQUISITION_HEADERS_ALL stores information about requisition headers. You need one row for each requisition header you create. Each row contains the requisition number, preparer, status, and description. . REQUISITION_HEADER_ID is the unique system-g
TASK_NUMBER FROM POR_REQUISITION_HEADERS_ALL PRH, POR_REQUISITION_LINES_ALL PRL, POR_REQ_DISTRIBUTIONS_ALL PRD, PJF_PROJECTS_ALL_VL PAP, PJF_TASKS_V PAT, PON_BACKING_REQUISITIONS PBR WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_ID AND PRL.REQUISITION_LINE_ID =PRD.REQUISITION_LINE_...
Schema: FUSION Object owner: POR Object type: VIEW Columns Name Query SQL_Statement
RequisitionLineEO.REQUISITION_HEADER_ID, PurchasingDocHeaderPEO.PO_HEADER_ID, PurchasingDocHeaderPEO.APPROVED_FLAG, PurchasingDocHeaderPEO.DOCUMENT_STATUS,PurchasingDocHeaderPEO.SEGMENT1 from POR_REQUISITION_LINES_ALL RequisitionLineEO, PO_HEADERS_ALL PurchasingDocHeaderPEO where RequisitionLineEO.PO_HEADER_...
PO_REQUISITIONS_INTERFACE_ALL表のほとんどの列は、PO_REQUISITIONS_HEADERS_ALL、PO_REQUISITION_LINES_ALLおよびPO_REQ_DISTRIBUTIONS_ALL表の対応する列と同じです。 さらに、INTERFACE_SOURCE_LINE_ID列に参照情報を入力できます。 スコープ: 公共製品: PO表示名: PO購買依頼インタフェース・カテゴリ...
調達の表およびビュー オブジェクト所有者: POR オブジェクト・タイプ: VIEW 列 名前 問合せ SQL_Statement
REQUISITION_HEADER_ID Query SQL_Statement SELECT distinct InvTransferOrderHeaderPEO.HEADER_NUMBER DOCUMENT_NUM, InvTransferOrderHeaderPEO.HEADER_ID, RequisitionLineEO.REQUISITION_HEADER_ID from POR_REQUISITION_LINES_ALL RequisitionLineEO, INV_TRANSFER_ORDER_HEADERS InvTransferOrderHeaderPEO where RequisitionLi...
POR_PUBLIC_LIST_HEADERS_ALL_VL PUBLICLISTHEADEREO, ( SELECT CZASSIGNMENTEO.ASSIGNMENT_ID, USERPREF.REQ_BU_ID, USERPREF.PERSON_ID FROM POR_CONTENT_ZONES_ALL_B CONTENTZONEEO, POR_CZ_SECURITY_ASSIGNMENTS CZSECURITYASSIGNMENTEO, POR_CZ_ASSIGNMENTS CZASSIGNMENTEO, POR_USER_PREFERENCES_ALL USERPREF,...