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: ICX.POR_FEED_RECORDS#

Source

View Text - Preformatted


select CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, PO_NUMBER PO_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, CARD_NUMBER CARD_NUMBER, CARD_MEMBER_NAME CARD_MEMBER_NAME, CARD_BRAND_LOOKUP_CODE CARD_BRAND_LOOKUP_CODE, CARD_TYPE_LOOKUP_CODE CARD_TYPE_LOOKUP_CODE, REQUESTER_ID REQUESTER_ID, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ORDER_DATE ORDER_DATE, BASE_CURRENCY_CODE BASE_CURRENCY_CODE, LOCAL_CURRENCY_CODE LOCAL_CURRENCY_CODE, UNIT_OF_MEASURE UNIT_OF_MEASURE, ITEM_NUMBER ITEM_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY QUANTITY, UNIT_PRICE UNIT_PRICE, AMOUNT AMOUNT, PO_HEADER_AMOUNT PO_HEADER_AMOUNT, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, ACCOUNTING_CODE ACCOUNTING_CODE, APPROVAL_STATUS APPROVAL_STATUS, APPROVED_DATE APPROVED_DATE, CONTROL_STATUS CONTROL_STATUS, CANCEL_FLAG CANCEL_FLAG, HOLD_FLAG HOLD_FLAG, LINE_CANCEL_FLAG LINE_CANCEL_FLAG, SHIPMENT_CANCEL_FLAG SHIPMENT_CANCEL_FLAG, ERROR_FLAG ERROR_FLAG from "ICX"."POR_FEED_RECORDS"

View Text - HTML Formatted

SELECT CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, PO_NUMBER PO_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, CARD_NUMBER CARD_NUMBER
, CARD_MEMBER_NAME CARD_MEMBER_NAME
, CARD_BRAND_LOOKUP_CODE CARD_BRAND_LOOKUP_CODE
, CARD_TYPE_LOOKUP_CODE CARD_TYPE_LOOKUP_CODE
, REQUESTER_ID REQUESTER_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ORDER_DATE ORDER_DATE
, BASE_CURRENCY_CODE BASE_CURRENCY_CODE
, LOCAL_CURRENCY_CODE LOCAL_CURRENCY_CODE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, ITEM_NUMBER ITEM_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY QUANTITY
, UNIT_PRICE UNIT_PRICE
, AMOUNT AMOUNT
, PO_HEADER_AMOUNT PO_HEADER_AMOUNT
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, ACCOUNTING_CODE ACCOUNTING_CODE
, APPROVAL_STATUS APPROVAL_STATUS
, APPROVED_DATE APPROVED_DATE
, CONTROL_STATUS CONTROL_STATUS
, CANCEL_FLAG CANCEL_FLAG
, HOLD_FLAG HOLD_FLAG
, LINE_CANCEL_FLAG LINE_CANCEL_FLAG
, SHIPMENT_CANCEL_FLAG SHIPMENT_CANCEL_FLAG
, ERROR_FLAG ERROR_FLAG
FROM "ICX"."POR_FEED_RECORDS"