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.

VIEW: JA.JAI_OPM_OSP_DTLS#

Source

View Text - Preformatted


select OSP_DETAIL_ID OSP_DETAIL_ID, OSP_HEADER_ID OSP_HEADER_ID, ITEM_ID ITEM_ID, TRANS_DATE TRANS_DATE, UOM_CODE UOM_CODE, PLAN_QUANTITY PLAN_QUANTITY, ACT_QUANTITY ACT_QUANTITY, UNIT_PRICE UNIT_PRICE, MODVAT_CLAIMED MODVAT_CLAIMED, EXCISE_PAYABLE EXCISE_PAYABLE, ISSUE_RECPT_FLAG ISSUE_RECPT_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROCESSING_CHARGE PROCESSING_CHARGE, MAIN_RCPT_FLAG MAIN_RCPT_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID from "JA"."JAI_OPM_OSP_DTLS"

View Text - HTML Formatted

SELECT OSP_DETAIL_ID OSP_DETAIL_ID
, OSP_HEADER_ID OSP_HEADER_ID
, ITEM_ID ITEM_ID
, TRANS_DATE TRANS_DATE
, UOM_CODE UOM_CODE
, PLAN_QUANTITY PLAN_QUANTITY
, ACT_QUANTITY ACT_QUANTITY
, UNIT_PRICE UNIT_PRICE
, MODVAT_CLAIMED MODVAT_CLAIMED
, EXCISE_PAYABLE EXCISE_PAYABLE
, ISSUE_RECPT_FLAG ISSUE_RECPT_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROCESSING_CHARGE PROCESSING_CHARGE
, MAIN_RCPT_FLAG MAIN_RCPT_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
FROM "JA"."JAI_OPM_OSP_DTLS"