[Home] [Help] [Dependency Information]
Object Name: | POR_FEED_RECORDS |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.POR_FEED_RECORDS |
Subobject Name: | |
Status: | VALID |
This table stores temporary data to generate PO History feed output file
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POR_FEED_RECORDS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
CONCURRENT_REQUEST_ID
PO_HEADER_ID PO_NUMBER |
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 |
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;
ICX.POR_FEED_RECORDS does not reference any database object
ICX.POR_FEED_RECORDS is referenced by following:
|
|
|