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: POS.POS_PRODUCT_SERVICE_INT#

Source

View Text - Preformatted


select SDH_BATCH_ID SDH_BATCH_ID, PS_INTERFACE_ID PS_INTERFACE_ID, SOURCE_SYSTEM SOURCE_SYSTEM, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, VENDOR_INTERFACE_ID VENDOR_INTERFACE_ID, VENDOR_ID VENDOR_ID, MAPPING_ID MAPPING_ID, SEGMENT_DEFINITION SEGMENT_DEFINITION, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, REQUEST_STATUS REQUEST_STATUS, REQUEST_TYPE REQUEST_TYPE, STATUS STATUS, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IMPORT_REQUEST_ID IMPORT_REQUEST_ID, PARTY_ID PARTY_ID from "POS"."POS_PRODUCT_SERVICE_INT"

View Text - HTML Formatted

SELECT SDH_BATCH_ID SDH_BATCH_ID
, PS_INTERFACE_ID PS_INTERFACE_ID
, SOURCE_SYSTEM SOURCE_SYSTEM
, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
, VENDOR_INTERFACE_ID VENDOR_INTERFACE_ID
, VENDOR_ID VENDOR_ID
, MAPPING_ID MAPPING_ID
, SEGMENT_DEFINITION SEGMENT_DEFINITION
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, REQUEST_STATUS REQUEST_STATUS
, REQUEST_TYPE REQUEST_TYPE
, STATUS STATUS
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IMPORT_REQUEST_ID IMPORT_REQUEST_ID
, PARTY_ID PARTY_ID
FROM "POS"."POS_PRODUCT_SERVICE_INT"