1. Tables and Views for Financials
  2. AP_OFR_PO_HEADERS_V

AP_OFR_PO_HEADERS_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

PO_HEADER_ID

PO_NUMBER

VENDOR_INDEX

VENDOR_ID

VENDOR_SITE_ID

STATUS

APPROVED_FLAG

CURRENCY_CODE

PO_TYPE

CREATION_DATE

ORG_ID

ORG_NAME

Query

SQL_Statement

SELECT

poh.po_header_id

, poh.segment1 po_number

, TO_CHAR ( poh.vendor_id)|| CHR(126)|| TO_CHAR (poh.vendor_site_id) vendor_index

, poh.vendor_id

, poh.vendor_site_id

, poh.document_status status

, poh.approved_flag

, poh.currency_code

,(CASE

WHEN

(

(SELECT count(*)

FROM po_lines_all pol

WHERE pol.po_header_id = poh.po_header_id) = 1

AND

(SELECT NVL(pol.matching_basis, 'QUANTITY')

FROM po_lines_all pol

WHERE pol.po_header_id = poh.po_header_id) = 'AMOUNT') THEN 'SERVICE'

ELSE poh.type_lookup_code

END) po_type

, poh.creation_date

, poh.billto_bu_id org_id

, hou.NAME org_name

FROM

fusion.po_headers_all poh

, fusion.hr_all_organization_units hou

WHERE poh.billto_bu_id = hou.organization_id

AND poh.type_lookup_code IN ('STANDARD')

AND NVL(poh.document_status, 'INCOMPLETE') IN ('OPEN', 'CLOSED FOR INVOICING','CLOSED FOR RECEIVING','CLOSED','CANCELED')

AND poh.vendor_id IS NOT NULL

AND poh.vendor_site_id IS NOT NULL