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: AP.AP_PREPAY_APP_DISTS

Object Details

Object Name:	AP_PREPAY_APP_DISTS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_PREPAY_APP_DISTS
Subobject Name:
Status:	VALID

This table details the distribution of prepayment application invoice distributions to the recipient invoice distribution. Records in this table will be created during the data extraction pre-processing from AP to SLA. The records in this table will not otherwise be deleted by transactions, except for the Purge process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_PREPAY_APP_DISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PREPAY_APP_DIST_ID
AP_PREPAY_APP_DISTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREPAY_HISTORY_ID
AP_PREPAY_APP_DISTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
AP_PREPAY_APP_DISTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
AP_PREPAY_APP_DISTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_ADDITION_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PREPAY_APP_DIST_ID	NUMBER	(15)	Yes	Unique Identifier of the prepayment application distribution.
PREPAY_DIST_LOOKUP_CODE	VARCHAR2	(30)	Yes	The name of the distribution type.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Unique Identifier of the recipient Invoice Distribution.
PREPAY_APP_DISTRIBUTION_ID	NUMBER	(15)	Yes	Unique Identifier of the Prepay Invoice Distribution.
ACCOUNTING_EVENT_ID	NUMBER	(15)		Unique Identifier for the Accounting Event.
PREPAY_HISTORY_ID	NUMBER	(15)		Prepayment History Unique Identifier
PREPAY_EXCHANGE_DATE	DATE			Prepayment Invoice Exchange Date
PREPAY_PAY_EXCHANGE_DATE	DATE			Prepayment Invoices Payment Exchange Date
PREPAY_CLR_EXCHANGE_DATE	DATE			Prepayment Invoices Payment Clearing Exchange Date
PREPAY_EXCHANGE_RATE	NUMBER			Prepayment Invoice Exchange Rate
PREPAY_PAY_EXCHANGE_RATE	NUMBER			Prepayment Invoice Payment Exchange Rate
PREPAY_CLR_EXCHANGE_RATE	NUMBER			Prepayment Invoice Payment Clearing Exchange Rate
PREPAY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Prepayment Invoice Exchange Rate Type
PREPAY_PAY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Prepayment Invoice Payment Exchange Rate Type
PREPAY_CLR_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Prepayment Invoice Payment Clearing Exchange Rate Type
REVERSED_PREPAY_APP_DIST_ID	NUMBER	(15)		Prepay Invoice Distribution Id of prepayment application payment distribution being reversed
AMOUNT	NUMBER			Prorated Invoice Distribution Amount affected by Prepayment Event.
BASE_AMT_AT_PREPAY_XRATE	NUMBER			Prorated Invoice distribution amount in functional currency at prepayment invoice exchange rate.
BASE_AMT_AT_PREPAY_PAY_XRATE	NUMBER			Prorated Invoice distribution amount in functional currency at prepayment payment exchange rate.
BASE_AMOUNT	NUMBER			Prorated Invoice Distribution Amount in the functional at recipient invoice exchange rate.
BASE_AMT_AT_PREPAY_CLR_XRATE	NUMBER			Prorated Invoice distribution amount in functional currency at prepayment payment clearing exchange rate.
ROUNDING_AMT	NUMBER			Rounding amount resulting from proration using the recipient invoice exchange rate.
ROUND_AMT_AT_PREPAY_XRATE	NUMBER			Rounding amount resulting from proration using the prepayment invoice exchange rate
ROUND_AMT_AT_PREPAY_PAY_XRATE	NUMBER			Rounding amount resulting from proration using the prepayment payment exchange rate
ROUND_AMT_AT_PREPAY_CLR_XRATE	NUMBER			Rounding amount resulting from proration using the prepayment payment clearing exchange rate
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Enhanced Who column
PROGRAM_ID	NUMBER	(15)		Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
REQUEST_ID	NUMBER	(15)		Enhanced Who column
AWT_RELATED_ID	NUMBER	(15)		Distribution identifier of AWT related distribution
RELEASE_INV_DIST_DERIVED_FROM	NUMBER	(15)		Retainage release invoice distribution identifier used for subledger accounting business flows
PA_ADDITION_FLAG	VARCHAR2	(1)		Flag that indicates if project related invoice distributions have been transferred into Oracle Projects in cash basis accounting
BC_EVENT_ID	NUMBER	(15)		Identifier of Accounting Event raised for Encumbrance accounting
AMOUNT_VARIANCE	NUMBER			Amount variance in entered currency for invoice distributions matched to service shipment or receipt
INVOICE_BASE_AMT_VARIANCE	NUMBER			Amount variance in functional currency for invoice distributions matched to service shipment or receipt
QUANTITY_VARIANCE	NUMBER			Quantity variance amount for invoice distribution lines matched to purchase order or receipt
INVOICE_BASE_QTY_VARIANCE	NUMBER			Quantity variance amount in functional currency for invoice distribution lines matched to purchase order or receipt

Query Text

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


SELECT PREPAY_APP_DIST_ID
,      PREPAY_DIST_LOOKUP_CODE
,      INVOICE_DISTRIBUTION_ID
,      PREPAY_APP_DISTRIBUTION_ID
,      ACCOUNTING_EVENT_ID
,      PREPAY_HISTORY_ID
,      PREPAY_EXCHANGE_DATE
,      PREPAY_PAY_EXCHANGE_DATE
,      PREPAY_CLR_EXCHANGE_DATE
,      PREPAY_EXCHANGE_RATE
,      PREPAY_PAY_EXCHANGE_RATE
,      PREPAY_CLR_EXCHANGE_RATE
,      PREPAY_EXCHANGE_RATE_TYPE
,      PREPAY_PAY_EXCHANGE_RATE_TYPE
,      PREPAY_CLR_EXCHANGE_RATE_TYPE
,      REVERSED_PREPAY_APP_DIST_ID
,      AMOUNT
,      BASE_AMT_AT_PREPAY_XRATE
,      BASE_AMT_AT_PREPAY_PAY_XRATE
,      BASE_AMOUNT
,      BASE_AMT_AT_PREPAY_CLR_XRATE
,      ROUNDING_AMT
,      ROUND_AMT_AT_PREPAY_XRATE
,      ROUND_AMT_AT_PREPAY_PAY_XRATE
,      ROUND_AMT_AT_PREPAY_CLR_XRATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      AWT_RELATED_ID
,      RELEASE_INV_DIST_DERIVED_FROM
,      PA_ADDITION_FLAG
,      BC_EVENT_ID
,      AMOUNT_VARIANCE
,      INVOICE_BASE_AMT_VARIANCE
,      QUANTITY_VARIANCE
,      INVOICE_BASE_QTY_VARIANCE
FROM AP.AP_PREPAY_APP_DISTS;

Dependencies

[top of page]

AP.AP_PREPAY_APP_DISTS does not reference any database object

AP.AP_PREPAY_APP_DISTS is referenced by following:

APPS: AP_PREPAY_APP_DISTS