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: JA.JAI_PO_OSP_HDRS#

Source

View Text - Preformatted


select FORM_ID FORM_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, FORM_NUMBER FORM_NUMBER, PO_HEADER_ID PO_HEADER_ID, OTH_DOC_ID OTH_DOC_ID, PROCESS_TIME PROCESS_TIME, ISSUE_APPROVED ISSUE_APPROVED, ISSUE_DATE ISSUE_DATE, RECEIPT_APPROVED RECEIPT_APPROVED, RECEIPT_DATE RECEIPT_DATE, DR_REGISTER DR_REGISTER, DR_REG_REGISTER_ID DR_REG_REGISTER_ID, DR_REG_SLNO DR_REG_SLNO, DR_REG_ENTRY_DATE DR_REG_ENTRY_DATE, CR_REGISTER CR_REGISTER, CR_REG_REGISTER_ID CR_REG_REGISTER_ID, CR_REG_SLNO CR_REG_SLNO, CR_REG_ENTRY_DATE CR_REG_ENTRY_DATE, CANCEL_FLAG CANCEL_FLAG, SOURCE SOURCE, OSP_SI OSP_SI, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PRIMARY_FLAG PRIMARY_FLAG, PRIMARY_FORM_ID PRIMARY_FORM_ID, FIN_YEAR FIN_YEAR, PRINT_ORIGINAL PRINT_ORIGINAL, PRINT_DUPLICATE PRINT_DUPLICATE, PRINT_CNT PRINT_CNT, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_PO_OSP_HDRS"

View Text - HTML Formatted

SELECT FORM_ID FORM_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, FORM_NUMBER FORM_NUMBER
, PO_HEADER_ID PO_HEADER_ID
, OTH_DOC_ID OTH_DOC_ID
, PROCESS_TIME PROCESS_TIME
, ISSUE_APPROVED ISSUE_APPROVED
, ISSUE_DATE ISSUE_DATE
, RECEIPT_APPROVED RECEIPT_APPROVED
, RECEIPT_DATE RECEIPT_DATE
, DR_REGISTER DR_REGISTER
, DR_REG_REGISTER_ID DR_REG_REGISTER_ID
, DR_REG_SLNO DR_REG_SLNO
, DR_REG_ENTRY_DATE DR_REG_ENTRY_DATE
, CR_REGISTER CR_REGISTER
, CR_REG_REGISTER_ID CR_REG_REGISTER_ID
, CR_REG_SLNO CR_REG_SLNO
, CR_REG_ENTRY_DATE CR_REG_ENTRY_DATE
, CANCEL_FLAG CANCEL_FLAG
, SOURCE SOURCE
, OSP_SI OSP_SI
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRIMARY_FLAG PRIMARY_FLAG
, PRIMARY_FORM_ID PRIMARY_FORM_ID
, FIN_YEAR FIN_YEAR
, PRINT_ORIGINAL PRINT_ORIGINAL
, PRINT_DUPLICATE PRINT_DUPLICATE
, PRINT_CNT PRINT_CNT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_PO_OSP_HDRS"