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

TABLE: ICX.POR_FEED_RECORDS

Object Details
Object Name: POR_FEED_RECORDS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.POR_FEED_RECORDS
Subobject Name:
Status: VALID


This table stores temporary data to generate PO History feed output file


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POR_FEED_RECORDS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCONCURRENT_REQUEST_ID
ColumnPO_HEADER_ID
ColumnPO_NUMBER
Columns
Name Datatype Length Mandatory Comments
CONCURRENT_REQUEST_ID NUMBER

Internal Concurrent Request Id
PO_NUMBER VARCHAR2 (20)
Purchase Order Document Number
RELEASE_NUMBER NUMBER

Release Document Number
PO_HEADER_ID NUMBER

Purchase Order Header Id
PO_RELEASE_ID NUMBER

Release Header Id
CARD_NUMBER VARCHAR2 (80)
PCard Number
CARD_MEMBER_NAME VARCHAR2 (80)
Card Member Name
CARD_BRAND_LOOKUP_CODE VARCHAR2 (25)
Card Brand
CARD_TYPE_LOOKUP_CODE VARCHAR2 (25)
Card Type
REQUESTER_ID NUMBER

Requester Id
VENDOR_NAME VARCHAR2 (80)
Supplier Name
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier Site Name
VENDOR_ID NUMBER

Supplier Id
VENDOR_SITE_ID NUMBER

Supplier Site Id
ORDER_DATE DATE

Purchase Order Last Update Date
BASE_CURRENCY_CODE VARCHAR2 (15)
Functional Currency Code
LOCAL_CURRENCY_CODE VARCHAR2 (15)
Purchase Order Currency Code
UNIT_OF_MEASURE VARCHAR2 (25)
Unit
ITEM_NUMBER VARCHAR2 (40)
Inventory Item Number
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
QUANTITY NUMBER

Quantity
UNIT_PRICE NUMBER

Unit Price
AMOUNT NUMBER

Amount
PO_HEADER_AMOUNT NUMBER

Purchase Order Amount
CHART_OF_ACCOUNTS_ID NUMBER

Account Id
ACCOUNTING_CODE VARCHAR2 (207)
Account Code
APPROVAL_STATUS VARCHAR2 (25)
Purchase Order Approval Status
APPROVED_DATE DATE

Purchase Order Approve Date
CONTROL_STATUS VARCHAR2 (25)
Purchases Order Closed Status
CANCEL_FLAG VARCHAR2 (1)
Purchase Order Cancel Flag
HOLD_FLAG VARCHAR2 (1)
Purchase Order Hold Flag
LINE_CANCEL_FLAG VARCHAR2 (1)
Purchase Line Cancel Flag
SHIPMENT_CANCEL_FLAG VARCHAR2 (1)
Shipment Cancel Flag
ERROR_FLAG VARCHAR2 (1)
Indicates whether record has an error or not
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 does not reference any database object

ICX.POR_FEED_RECORDS is referenced by following:

SchemaAPPS
SynonymPOR_FEED_RECORDS