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

TABLE: XTR.XTR_HEDGE_ITEMS_TEMP

Object Details
Object Name: XTR_HEDGE_ITEMS_TEMP
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_HEDGE_ITEMS_TEMP
Subobject Name:
Status: VALID


The XTR_HEDGE_ITEMS_TEMP table is used to generate the Positions - Forecast Hedge
Items Fulfillment report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
HEDGE_ATTRIBUTE_ID NUMBER (15) Yes Hedge identifier
TRX_INV_ID NUMBER (15) Yes Primary Identifier of the item
PAY_SCHEDULE_ID NUMBER (15) Yes Secondary Identifier of the item
SOURCE_NAME VARCHAR2 (2000)
Source name
TRX_TYPE_NAME VARCHAR2 (80)
Transaction type name
ORG_NAME VARCHAR2 (240)
Organization name
VEND_CUST_NAME VARCHAR2 (360)
Vendor or customer name
TRX_NUMBER VARCHAR2 (50)
Transaction number
TRX_DATE DATE

Transaction date
DUE_DATE DATE

Due date
CURRENCY_CODE VARCHAR2 (15)
Currency code of the transaction
AMOUNT NUMBER

Transaction amount
PCT_ALLOCATION NUMBER

Item % assigned to the hedge
REFERENCE_AMOUNT NUMBER

Amount of the item assigned to the hedge
REQUEST_ID NUMBER (15)
Concurrent program request id
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
Query Text

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


SELECT HEDGE_ATTRIBUTE_ID
,      TRX_INV_ID
,      PAY_SCHEDULE_ID
,      SOURCE_NAME
,      TRX_TYPE_NAME
,      ORG_NAME
,      VEND_CUST_NAME
,      TRX_NUMBER
,      TRX_DATE
,      DUE_DATE
,      CURRENCY_CODE
,      AMOUNT
,      PCT_ALLOCATION
,      REFERENCE_AMOUNT
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM XTR.XTR_HEDGE_ITEMS_TEMP;

Dependencies

[top of page]

XTR.XTR_HEDGE_ITEMS_TEMP does not reference any database object

XTR.XTR_HEDGE_ITEMS_TEMP is referenced by following:

SchemaAPPS
SynonymXTR_HEDGE_ITEMS_TEMP