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_CHRG_ALLOCATIONS_ALL

Object Details

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

AP_CHRG_ALLOCATIONS_ALL is used by Oracle Payables to link charges (Miscellaneous, Freight, or Tax) with the appropriate invoice distributions they apply to. Every charge can be allocated to multiple invoice distributions. The allocated amount dictates the amount of the charge applicable to each of those distributions. A tax distribution can be allocated across FREIGHT, ITEM or MISCELLANEOUS type distributions. A freight or miscellaneous distributions can be allocated across ITEM type distributions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_CHRG_ALLOCATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_ALLOCATION_ID
AP_CHRG_ALLOCATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_DIST_ID ITEM_DIST_ID
AP_CHRG_ALLOCATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_DIST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHARGE_ALLOCATION_ID	NUMBER	(15)	Yes	No Longer Used
CHARGE_DIST_ID	NUMBER	(15)	Yes	No Longer Used
ITEM_DIST_ID	NUMBER	(15)	Yes	No Longer Used
ALLOCATED_AMOUNT	NUMBER			No Longer Used
ALLOCATED_BASE_AMOUNT	NUMBER			No Longer Used
LAST_UPDATE_DATE	DATE		Yes	No Longer Used
LAST_UPDATED_BY	NUMBER	(15)	Yes	No Longer Used
LAST_UPDATE_LOGIN	NUMBER	(15)		No Longer Used
CREATION_DATE	DATE		Yes	No Longer Used
CREATED_BY	NUMBER	(15)	Yes	No Longer Used
PROGRAM_ID	NUMBER	(15)		No Longer Used
PROGRAM_APPLICATION_ID	NUMBER	(15)		No Longer Used
REQUEST_ID	NUMBER	(15)		No Longer Used
ORG_ID	NUMBER	(15)		No Longer Used
PROGRAM_UPDATE_DATE	DATE			No Longer Used

Query Text

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


SELECT CHARGE_ALLOCATION_ID
,      CHARGE_DIST_ID
,      ITEM_DIST_ID
,      ALLOCATED_AMOUNT
,      ALLOCATED_BASE_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ORG_ID
,      PROGRAM_UPDATE_DATE
FROM AP.AP_CHRG_ALLOCATIONS_ALL;

Dependencies

[top of page]

AP.AP_CHRG_ALLOCATIONS_ALL does not reference any database object

AP.AP_CHRG_ALLOCATIONS_ALL is referenced by following:

APPS: AP_CHRG_ALLOCATIONS; AP_CHRG_ALLOCATIONS_ALL