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_ALLOCATION_RULE_LINES

Object Details

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

AP_ALLOCATION_RULE_LINES contains the records that establish which percentage and/or amount of a charge line is to be allocated to a specific item line.
Allocation rule lines are created as children of an allocation rule, which is stored in the AP_ALLOCATION_RULES table. Consequently such allocation rule lines will be considered executed whenever the status of the allocation rule becomes executed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_ALLOCATION_RULE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID CHRG_INVOICE_LINE_NUMBER TO_INVOICE_LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier for invoice owning the charge
CHRG_INVOICE_LINE_NUMBER	NUMBER			Invoice line number for charge line being allocated
TO_INVOICE_LINE_NUMBER	NUMBER			Invoice line number for line charge is allocated against
PERCENTAGE	NUMBER			Percentage of the charge allocated to the line. Valid only if RULE_TYPE is PERCENTAGE
AMOUNT	NUMBER			Amount of the charge allocated to the line
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	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
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

Query Text

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


SELECT INVOICE_ID
,      CHRG_INVOICE_LINE_NUMBER
,      TO_INVOICE_LINE_NUMBER
,      PERCENTAGE
,      AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM AP.AP_ALLOCATION_RULE_LINES;

Dependencies

[top of page]

AP.AP_ALLOCATION_RULE_LINES does not reference any database object

AP.AP_ALLOCATION_RULE_LINES is referenced by following:

AP: AP_ALLOCATION_RULE_LINES#