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

TABLE: AP.AP_ALLOCATION_RULES

Object Details
Object Name: AP_ALLOCATION_RULES
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_ALLOCATION_RULES
Subobject Name:
Status: VALID


AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each record in this table indicates the type of allocation rule that will be generated.
The available rule types are Percentage Based, Amount Based, and Fully Prorated. Such rule types simply determine the type of data that will be provided by the user vs. generated by the system.
In a Fully Prorated Rule, the user does not select Item lines to allocate the charge across. Instead, the system will prorate across all Item lines during execution of the allocation rule.
In Percentage Based, the user selects the Item lines and the percentage of the charge to be allocated to each line selected.
The system then calculates the corresponding amount. In Amount Based, the user selects the Item lines and the amount of the charge to be allocated to each line selected.
The Item lines selected during Percentage Based or Amount Based rule type creation, along with the percentage or amount to be allocated, is stored in the AP_ALLOCATION_RULE_LINES table.
Allocation rules contain a status that determines whether the allocation rule has been executed and thus, it will no longer be used by the invoice that created it, or if it is pending execution and thus, still updateable.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_ALLOCATION_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
ColumnCHRG_INVOICE_LINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes Invoice identifier for rule owner
CHRG_INVOICE_LINE_NUMBER NUMBER
Yes Invoice line number for charge being allocated
RULE_TYPE VARCHAR2 (30) Yes Indicates the type of allocation. Possible choices are Percentage based, Amount based or Fully prorated. Validated against AP_LOOKUP_CODES with lookup_type ALLOCATION RULE TYPE
RULE_GENERATION_TYPE VARCHAR2 (30) Yes Indicates whether the rule was generated by the system or by the user. Validated against AP_LOOKUP_CODES with lookup_type ALLOCATION GENERATION TYPE
STATUS VARCHAR2 (30)
Indicates whether the Allocation Rule has been executed. The possible values are PENDING or EXECUTED. Lookup type is ALLOCATION STATUS
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
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
,      RULE_TYPE
,      RULE_GENERATION_TYPE
,      STATUS
,      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_RULES;

Dependencies

[top of page]

AP.AP_ALLOCATION_RULES does not reference any database object

AP.AP_ALLOCATION_RULES is referenced by following:

SchemaAPPS
SynonymAP_ALLOCATION_RULES