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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ICX.POR_FEED_RECORDS#

Object Details

Object Name:	POR_FEED_RECORDS#
Object Type:	VIEW
Owner:	ICX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
CONCURRENT_REQUEST_ID	NUMBER
PO_NUMBER	VARCHAR2	(20)
RELEASE_NUMBER	NUMBER
PO_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER
CARD_NUMBER	VARCHAR2	(80)
CARD_MEMBER_NAME	VARCHAR2	(80)
CARD_BRAND_LOOKUP_CODE	VARCHAR2	(25)
CARD_TYPE_LOOKUP_CODE	VARCHAR2	(25)
REQUESTER_ID	NUMBER
VENDOR_NAME	VARCHAR2	(80)
VENDOR_SITE_CODE	VARCHAR2	(15)
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
ORDER_DATE	DATE
BASE_CURRENCY_CODE	VARCHAR2	(15)
LOCAL_CURRENCY_CODE	VARCHAR2	(15)
UNIT_OF_MEASURE	VARCHAR2	(25)
ITEM_NUMBER	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
QUANTITY	NUMBER
UNIT_PRICE	NUMBER
AMOUNT	NUMBER
PO_HEADER_AMOUNT	NUMBER
CHART_OF_ACCOUNTS_ID	NUMBER
ACCOUNTING_CODE	VARCHAR2	(207)
APPROVAL_STATUS	VARCHAR2	(25)
APPROVED_DATE	DATE
CONTROL_STATUS	VARCHAR2	(25)
CANCEL_FLAG	VARCHAR2	(1)
HOLD_FLAG	VARCHAR2	(1)
LINE_CANCEL_FLAG	VARCHAR2	(1)
SHIPMENT_CANCEL_FLAG	VARCHAR2	(1)
ERROR_FLAG	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

ICX.POR_FEED_RECORDS# references the following:

ICX: POR_FEED_RECORDS

ICX.POR_FEED_RECORDS# is referenced by following:

APPS: POR_FEED_RECORDS