1. Tables and Views for Procurement
  2. POR_PURCHASE_ORDERS_V

POR_PURCHASE_ORDERS_V

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: VIEW

Columns

Name

REQUISITION_HEADER_ID

PO_HEADER_ID

APPROVED_FLAG

DOCUMENT_STATUS

SEGMENT1

Query

SQL_Statement

select distinct

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_ID = PurchasingDocHeaderPEO.PO_HEADER_ID