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]

TABLE: ONT.OE_EXPOSURE_INTERFACE

Object Details

Object Name:	OE_EXPOSURE_INTERFACE
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_EXPOSURE_INTERFACE
Subobject Name:
Status:	VALID

This table contains Credit Exposure Data to be imported into Oracle Order Management

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_EXPOSURE_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXPOSURE_SOURCE_CODE	VARCHAR2	(30)	Yes	A code that uniquely identifies the exposure source data. It maps to the EXPOSURE_SOURCE_CODE column in the OE_CREDIT_SUMMARIES table.
EXPOSURE_INTERFACE_ID	NUMBER			A number that uniquely identifies a row, in the interface table for the given exposure source.It is used to identify the error row in the exception report.The credit Exposure Import program automatically populates this number
BATCH_ID	NUMBER			A batch number that can be used by the Credit Exposure Import program to identify rows for import.
OPERATION_CODE	VARCHAR2	(30)	Yes	Indicates whether to refresh the exposure data or to incrementally update the existing exposure. VALUES: INSERT,UPDATE
EXPOSURE_AMOUNT	NUMBER		Yes	The Credit Exposure amount for a given bill-to site and currency. It maps to the BALANCE column in the OE_CREDIT_SUMMARIES table.
CURRENCY_CODE	VARCHAR2	(30)	Yes	The currency of the exposure amount. It maps to the CURRENCY_CODE column in the OE_CREDIT_SUMMARIES table.
BILL_TO_SITE_USE_ID	NUMBER			The site use id for the bill-to site. Either the name or the id should be provided.
BILL_TO_CUSTOMER_NAME	VARCHAR2	(50)		The name of the customer owning to bill-to state. Either the name or the id should be provided.
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		The number of the customer account owning the bill-to site. This along with the customer name helps to identify the customer in Oracle when the customer account id is not provided.
BILL_TO_CUSTOMER_ID	NUMBER			The id of the customer account owning the bil-to site. It maps to CUST_ACCOUNT_ID column in the OE_CREDIT_SUMMARIES table.
BILL_TO_ADDRESS1	VARCHAR2	(240)		The address of the Bill-to site. It is used in conjuction with the customer_account_id to derive the cust_acct_site_id when it is not provided.
BILL_TO_ADDRESS2	VARCHAR2	(240)		The address of the bill_to site.
BILL_TO_ADDRESS3	VARCHAR2	(240)		The address of the bill_to site.
BILL_TO_ADDRESS4	VARCHAR2	(240)		The address of the bill_to site.
BILL_TO_CITY	VARCHAR2	(60)		The address of the bill_to site.
BILL_TO_STATE	VARCHAR2	(60)		The address of the bill_to site.
BILL_TO_COUNTRY	VARCHAR2	(60)		The address of the bill_to site.
BILL_TO_POSTAL_CODE	VARCHAR2	(60)		The address of the bill_to site.
IMPORT_STATUS_CODE	VARCHAR2	(30)		The code identifying the status of the exposure during the import process.VALIES:NULL, PROCESSING, VALIDATED, ERROR, COMPLETE
EXPOSURE_DATE	DATE			Reserved for future use.
ORG_ID	NUMBER			It is the Operating unit id that is associated with bill-to site.The Credit Exposure Import program derives this column.
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)		Reference column,The value in this column will not be imported into Oracle Order Management.
CREATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Extended who column.
PROGRAM_APPLICATION_ID	NUMBER			Extended who column
PROGRAM_ID	NUMBER			Extended who column
PROGRAM_UPDATE_DATE	DATE			Extended who column
REQUEST_ID	NUMBER			Concurrent Request that last processed this row.
BILL_TO_PROVINCE	VARCHAR2	(60)		The address of the bill_to site.
BILL_TO_COUNTY	VARCHAR2	(60)		The address of the bill_to site.

Query Text

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


SELECT EXPOSURE_SOURCE_CODE
,      EXPOSURE_INTERFACE_ID
,      BATCH_ID
,      OPERATION_CODE
,      EXPOSURE_AMOUNT
,      CURRENCY_CODE
,      BILL_TO_SITE_USE_ID
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_COUNTRY
,      BILL_TO_POSTAL_CODE
,      IMPORT_STATUS_CODE
,      EXPOSURE_DATE
,      ORG_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      BILL_TO_PROVINCE
,      BILL_TO_COUNTY
FROM ONT.OE_EXPOSURE_INTERFACE;

Dependencies

[top of page]

ONT.OE_EXPOSURE_INTERFACE does not reference any database object

ONT.OE_EXPOSURE_INTERFACE is referenced by following:

ONT: OE_EXPOSURE_INTERFACE#