eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKX_PO_HEADERS_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT POH.PO_HEADER_ID ID1
, '#' ID2
, POH.SEGMENT1 NAME
, POH.COMMENTS DESCRIPTION
, POH.ORG_ID ORG_ID
, POH.AGENT_ID AGENT_ID
, POH.TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE
, POH.ENABLED_FLAG ENABLED_FLAG
, POH.START_DATE_ACTIVE START_DATE_ACTIVE
, POH.END_DATE_ACTIVE END_DATE_ACTIVE
, POH.VENDOR_ID VENDOR_ID
, POH.VENDOR_SITE_ID VENDOR_SITE_ID
, POH.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, POH.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, POH.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, POH.TERMS_ID TERMS_ID
, POH.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, POH.STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, POH.CURRENCY_CODE CURRENCY_CODE
, POH.RATE_TYPE RATE_TYPE
, POH.RATE_DATE RATE_DATE
, POH.RATE RATE
, POH.START_DATE START_DATE
, POH.END_DATE END_DATE
, POH.AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, POH.REVISION_NUM REVISION_NUM
, POH.APPROVED_FLAG APPROVED_FLAG
, POH.APPROVED_DATE APPROVED_DATE
, POH.CLOSED_DATE CLOSED_DATE
, POH.CANCEL_FLAG CANCEL_FLAG
, POH.FROZEN_FLAG FROZEN_FLAG
FROM PO_HEADERS_ALL POH

Columns

Name
ID1
ID2
NAME
DESCRIPTION
ORG_ID
AGENT_ID
TYPE_LOOKUP_CODE
ENABLED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
VENDOR_ID
VENDOR_SITE_ID
VENDOR_CONTACT_ID
SHIP_TO_LOCATION_ID
BILL_TO_LOCATION_ID
TERMS_ID
FREIGHT_TERMS_LOOKUP_CODE
STATUS_LOOKUP_CODE
CURRENCY_CODE
RATE_TYPE
RATE_DATE
RATE
START_DATE
END_DATE
AUTHORIZATION_STATUS
REVISION_NUM
APPROVED_FLAG
APPROVED_DATE
CLOSED_DATE
CANCEL_FLAG
FROZEN_FLAG