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: FV.FV_STATUS_OBLIG_TEMP#

Source

View Text - Preformatted


select REQNUM REQNUM, REQDATE REQDATE, REQAMT REQAMT, REQCCID REQCCID, OBLIGNUM OBLIGNUM, OBLIGDATE OBLIGDATE, OBLIGAMT OBLIGAMT, OBLIGCCID OBLIGCCID, OBLIGSTATUS OBLIGSTATUS, INVNUM INVNUM, INVDATE INVDATE, INVAMT INVAMT, INVCCID INVCCID, SEGVAL1 SEGVAL1, SEGVAL2 SEGVAL2, SEGVAL3 SEGVAL3, INV_PO_DISTRIBUTION_ID INV_PO_DISTRIBUTION_ID, PO_REQ_DISTRIBUTION_ID PO_REQ_DISTRIBUTION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID from "FV"."FV_STATUS_OBLIG_TEMP"

View Text - HTML Formatted

SELECT REQNUM REQNUM
, REQDATE REQDATE
, REQAMT REQAMT
, REQCCID REQCCID
, OBLIGNUM OBLIGNUM
, OBLIGDATE OBLIGDATE
, OBLIGAMT OBLIGAMT
, OBLIGCCID OBLIGCCID
, OBLIGSTATUS OBLIGSTATUS
, INVNUM INVNUM
, INVDATE INVDATE
, INVAMT INVAMT
, INVCCID INVCCID
, SEGVAL1 SEGVAL1
, SEGVAL2 SEGVAL2
, SEGVAL3 SEGVAL3
, INV_PO_DISTRIBUTION_ID INV_PO_DISTRIBUTION_ID
, PO_REQ_DISTRIBUTION_ID PO_REQ_DISTRIBUTION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
FROM "FV"."FV_STATUS_OBLIG_TEMP"