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: WIP.WIP_EAM_PO_REQ_INTERFACE#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, PROCESS_FLAG PROCESS_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, REQUISITION_TYPE REQUISITION_TYPE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY QUANTITY, UNIT_PRICE UNIT_PRICE, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, PREPARER_ID PREPARER_ID, AUTOSOURCE_FLAG AUTOSOURCE_FLAG, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME, NEED_BY_DATE NEED_BY_DATE, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, NOTE_TO_BUYER NOTE_TO_BUYER, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, ITEM_ID ITEM_ID, ITEM_SEGMENT1 ITEM_SEGMENT1, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, CATEGORY_ID CATEGORY_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, UOM_CODE UOM_CODE, LINE_TYPE_ID LINE_TYPE_ID, REFERENCE_NUM REFERENCE_NUM, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_ORGANIZATION_CODE DESTINATION_ORGANIZATION_CODE, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID, CURRENCY_CODE CURRENCY_CODE, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SYNCHED_UP SYNCHED_UP from "WIP"."WIP_EAM_PO_REQ_INTERFACE"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PROCESS_FLAG PROCESS_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, REQUISITION_TYPE REQUISITION_TYPE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY QUANTITY
, UNIT_PRICE UNIT_PRICE
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, PREPARER_ID PREPARER_ID
, AUTOSOURCE_FLAG AUTOSOURCE_FLAG
, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, NEED_BY_DATE NEED_BY_DATE
, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, NOTE_TO_BUYER NOTE_TO_BUYER
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, ITEM_ID ITEM_ID
, ITEM_SEGMENT1 ITEM_SEGMENT1
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, CATEGORY_ID CATEGORY_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, UOM_CODE UOM_CODE
, LINE_TYPE_ID LINE_TYPE_ID
, REFERENCE_NUM REFERENCE_NUM
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE DESTINATION_ORGANIZATION_CODE
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID
, CURRENCY_CODE CURRENCY_CODE
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SYNCHED_UP SYNCHED_UP
FROM "WIP"."WIP_EAM_PO_REQ_INTERFACE"