Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IPA Tables and Views

TABLE - IPA.IPA_APIS_INTERFACE
TABLE - IPA.IPA_APIS_INTERFACE_ERRORS
TABLE - IPA.IPA_ASSET_NAMING_CONVENTS_ALL
TABLE - IPA.IPA_BUSINESS_GROUP_INTERESTS
TABLE - IPA.IPA_INTEREST_BATCHES
TABLE - IPA.IPA_INTEREST_BATCH_DETAILS
TABLE - IPA.IPA_INTEREST_ERRORS
TABLE - IPA.IPA_INTEREST_RUN_BATCHES
TABLE - IPA.IPA_INTEREST_SUSPENSION
TABLE - IPA.IPA_ORGANIZATION_INTERESTS
TABLE - IPA.IPA_PROJECT_INTERESTS
TABLE - IPA.IPA_PROJECT_INT_EXCLUSIONS
TABLE - IPA.IPA_RATE_PERIODS
TABLE - IPA.IPA_RATE_STRUCTURES
TABLE - IPA.IPA_TASK_INTERESTS
TABLE - IPA.IPA_TASK_INT_EXCLUSIONS
VIEW - APPS.IPA_BUSINESS_GROUP_INTERESTS_V
VIEW - APPS.IPA_INTEREST_BATCHES_V
VIEW - APPS.IPA_INTEREST_SUSPENSION_V
VIEW - APPS.IPA_ORGANIZATION_INTERESTS_V
VIEW - APPS.IPA_PROJECT_INTERESTS_V
VIEW - APPS.IPA_TASK_INTERESTS_V
VIEW - APPS.PA_CDL_BURDEN_DETAIL_V
VIEW - APPS.PA_CDL_BURDEN_SUMMARY_V

Table: IPA_APIS_INTERFACE

Description: This is an interface table used to populate the Date placed in service in project assets
Comments

Interface table to populate the Date placed in service in project assets from external systems.

Indexes
Index Type Tablespace Column
IPA_APIS_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER (10) Y System generated Id to identify interface records
BATCH_NAME VARCHAR2 (60)
User entered Batch name to group records in interface table
PROJECT_ID NUMBER (10)
Project Ids whose assets are to be placed in service
PROJECT_NUMBER VARCHAR2 (60)
Project Number whose assets are to be placed in service
PROJECT_NAME VARCHAR2 (80)
Project Name whose assets are to be placed in service
PROJECT_ASSET_ID NUMBER (10)
Project Asset which is to be placed in service
ASSET_NUMBER VARCHAR2 (15)
Asset Number which is to be placed in service
ASSET_NAME VARCHAR2 (80)
Asset Name which is to be placed in service
ASSET_STATUS VARCHAR2 (60)
Asset Status to be updated in Asset record
GROUPING_METHOD1 VARCHAR2 (60)
Grouping Method element1 used to identify the assets to place in service
GROUPING_METHOD2 VARCHAR2 (60)
Grouping Method element2 used to identify the assets to place in service
GROUPING_METHOD3 VARCHAR2 (60)
Grouping Method element3 used to identify the assets to place in service
DATE_PLACED_IN_SERVICE DATE
Y Value of date place in service for Assets
RECORD_STATUS VARCHAR2 (10)
Interface record status

[top of page]

IPA.IPA_APIS_INTERFACE does not reference any database object

IPA.IPA_APIS_INTERFACE is referenced by following:

APPS
SYNONYM - IPA_APIS_INTERFACE

[top of page]

Table: IPA_APIS_INTERFACE_ERRORS

Description: This table stores Error Messages generated by the Place in Service Process.
Comments

Table to store Exceptions by the Asset placed in Service interface Process

Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER (10)
Identifier of the record in table IFA_ASSET_INTERFACE for which error messages are generated
BATCH_NAME VARCHAR2 (60)
Identifier of the batch in table IFA_ASSET_INTERFACE for which error message are generated
PROJECT_ID NUMBER (10)
Project Id of the Asset not successfuly processed by the Place in Service Process
PROJECT_ASSET_ID NUMBER (10)
Project Asset Id of the Asset not successfully processed by the Place in Service Process
DATE_PLACED_IN_SERVICE DATE

Date Placed In Service of the Asset not successfully processed by the Place in Service Process
ASSET_STATUS VARCHAR2 (20)
Status of the Asset not successfully processed by the Place in Service Process
ERROR_MESSAGE VARCHAR2 (2000)
Reason why the Asset could not be placed into Service

[top of page]

IPA.IPA_APIS_INTERFACE_ERRORS does not reference any database object

IPA.IPA_APIS_INTERFACE_ERRORS is referenced by following:

APPS
SYNONYM - IPA_APIS_INTERFACE_ERRORS

[top of page]

Table: IPA_ASSET_NAMING_CONVENTS_ALL

Description: This table stores Asset Naming Convention Used by Asset Mechanization to derive Asset Attribute Values. If you have a multi-organization installation, you define one row per operating unit
Comments

Table to store Asset Naming Convention for CRL Asset mechanization process.

Indexes
Index Type Tablespace Column
IPA_ASSET_NAME_CONVENT_ALL_U1 UNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
ASSET_NAME_ID NUMBER (15) Y Id of the AssetNaming Convention record
ASSET_NAME VARCHAR2 (25) Y Stores Entity Name from which the value of Asset Name would be derived Can have values ANT - Asset Name would be derived from Task Name ANP - Asset Name would be derived from Project Name ANGE1 - Asset Name would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ANGE2 - Asset Name would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ANGE3 - Asset Name would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table
ASSET_DESCRIPTION1 VARCHAR2 (25) Y Stores Entity Name from which value of the First Segment of Asset Description would be drived Can have values ADT - Asset Description1 would be derived from Task Name ADP - Asset Description1 would be derived from Project Name ADGE1 - Asset Description1 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description1 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description1 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table
ASSET_DESCRIPTION2 VARCHAR2 (25)
Stores Entity Name from which value of the Second Segment of Asset Description would be drived Can have values ADT - Asset Description2 would be derived from Task Name ADP - Asset Description2 would be derived from Project Name ADGE1 - Asset Description2 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description2 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description2 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description2 would have a null value
ASSET_DESCRIPTION3 VARCHAR2 (25)
Stores Entity Name from which value of the Third Segment of Asset Description would be drived Can have values ADT - Asset Description3 would be derived from Task Name ADP - Asset Description3 would be derived from Project Name ADGE1 - Asset Description3 would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ADGE2 - Asset Description3 would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ADGE3 - Asset Description3 would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description3 would have a null value
ASSET_DESC_SEPARATOR VARCHAR2 (1) Y Separator to delimit the 3 segments of Asset Description
ASSET_LOCATION VARCHAR2 (25) Y Stores Entity Name from which value of the Location would be drived Can have values ALGE1 - Asset Location would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ALGE2 - Asset Location would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ALGE3 - Asset Location would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table
ASSET_CATEGORY VARCHAR2 (25) Y Stores Entity Name from which value of the Category would be drived Can have values ACT - Asset Category would be derived from Task Name ACDF - Asset Category would be derived from Descriptive Flexfield Attribute 10 on Task ACGE1 - Asset Category would be derived from Descriptive Flexfield Attribute 8 on Expenditure Items table ACGE2 - Asset Category would be derived from Descriptive Flexfield Attribute 9 on Expenditure Items table ACGE3 - Asset Category would be derived from Descriptive Flexfield Attribute 10 on Expenditure Items table None - Asset Description3 would have a null value
ORG_ID NUMBER

Operating Unit Id of the Multi Organization Installation
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_ASSET_NAMING_CONVENTS_ALL does not reference any database object

IPA.IPA_ASSET_NAMING_CONVENTS_ALL is referenced by following:

APPS
SYNONYM - IPA_ASSET_NAMING_CONVENTIONS
SYNONYM - IPA_ASSET_NAMING_CONVENTS_ALL

[top of page]

Table: IPA_BUSINESS_GROUP_INTERESTS

Description: This table is used to store the information about the assignment of rate codes to the various Business groups
Comments

Table to store the capitalized interest rate assignment at Business group level.

Indexes
Index Type Tablespace Column
IPA_BUSINESS_GROUP_INTEREST_N1 NONUNIQUE APPS_TS_TX_IDX RATE_CODE
IPA_BUSINESS_GROUP_INTEREST_N2 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_INTEREST_ID NUMBER (15) Y system generated ID
RATE_CODE VARCHAR2 (25) Y Rate structure name
BUSINESS_GROUP_ID NUMBER (15) Y Business group to which this rate code is applied
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE VARCHAR2 (240)
Standard Who Column
LAST_UPDATE_LOGIN VARCHAR2 (240)
Standard Who Column
OVERRIDE_FLAG VARCHAR2 (1) Y Flag indicates override at Org,Project or Task levels allowed
THRESHOLD_AMOUNT NUMBER (15)
Threshold amount above which Interest needs to be applied
CAPITALIZE_INTEREST VARCHAR2 (1) Y Falg to control application interest at the Business group level
COMMENTS VARCHAR2 (100)
Comments
DEFAULT_EXPENDITURE_TYPE VARCHAR2 (30) Y Default expenditure type for Capitalized Interest lines.

[top of page]

IPA.IPA_BUSINESS_GROUP_INTERESTS does not reference any database object

IPA.IPA_BUSINESS_GROUP_INTERESTS is referenced by following:

APPS
SYNONYM - IPA_BUSINESS_GROUP_INTERESTS

[top of page]

Table: IPA_INTEREST_BATCHES

Description: This Table is used to store Interest BAtch Information
Comments

Table to store Capitalized Interest Batch Information.

Indexes
Index Type Tablespace Column
IPA_INTEREST_BATCHES_U1 UNIQUE APPS_TS_TX_IDX INTEREST_BATCH_ID
IPA_INTEREST_BATCHES_N1 NONUNIQUE APPS_TS_TX_IDX GL_PERIOD
PROJECT_ID
EXPENDITURE_ITEM_ID
IPA_INTEREST_BATCHES_N2 NONUNIQUE APPS_TS_TX_IDX EXPENDITURE_ITEM_ID
IPA_INTEREST_BATCHES_N3 NONUNIQUE APPS_TS_TX_IDX BATCH_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_BATCH_ID NUMBER (15) Y System generated ID
INTEREST_APPLIED NUMBER (15)
Actual Interest applied
GL_PERIOD VARCHAR2 (15)
GL Period in which the Interest applied
PERIOD_BEGIN_DATE DATE

GL Period begin date
PERIOD_END_DATE DATE

GL Period end date
EXPENDITURE_ITEM_DATE DATE

Date with which the interest lines are created
EXPENDITURE_TASK_ID NUMBER (15)
Task on which interest line is created
STATUS VARCHAR2 (20)
Status- REVALIDATE - Interest lines not created in PA due to error SUCCEDED - Interest line successfully interfaced to PA
EXPENDITURE_ITEM_ID NUMBER (15)
Expenditure Item Id when expenditure item is created.
RATE_TYPE VARCHAR2 (30)
Rate type used - Not used
REVERSAL_DATE DATE

Date of reversal of interest if reversed
PROJECT_ID NUMBER (15)
Project id
BATCH_ID NUMBER (15) Y Capitalized interest run identification number.

[top of page]

IPA.IPA_INTEREST_BATCHES does not reference any database object

IPA.IPA_INTEREST_BATCHES is referenced by following:

APPS
SYNONYM - IPA_INTEREST_BATCHES

[top of page]

Table: IPA_INTEREST_BATCH_DETAILS

Description: Table to store the source expenditure lines on which this interest is calculated
Comments

Table to store the transaction source audit information for the Capitalized interest lines.

Indexes
Index Type Tablespace Column
IPA_INTEREST_BATCH_DETAILS_U1 UNIQUE APPS_TS_TX_IDX INTEREST_BATCH_DETAIL_ID
IPA_INTEREST_BATCH_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX INTEREST_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_BATCH_DETAIL_ID NUMBER (15) Y System Generated ID
SOURCE_TASK_ID NUMBER (15)
Source task
RATE_CODE VARCHAR2 (25)
Rate name
RATE_APPLIED NUMBER (15)
Rate applied
INTEREST_TYPE VARCHAR2 (1)
Interest type indicates Simple or Compound.
PERIOD VARCHAR2 (15)
GL Period of Interest
INTEREST_RATE_TYPE VARCHAR2 (30)
Obsolete.
INTEREST_BATCH_ID NUMBER (15) Y Interest Batch
EXPENDITURE_ITEM_ID NUMBER (15) Y Source exp lines on which interest is applied
EXPENDITURE_AMOUNT NUMBER (15)
Expenditure amount on which interest is applied

[top of page]

IPA.IPA_INTEREST_BATCH_DETAILS does not reference any database object

IPA.IPA_INTEREST_BATCH_DETAILS is referenced by following:

APPS
SYNONYM - IPA_INTEREST_BATCH_DETAILS

[top of page]

Table: IPA_INTEREST_ERRORS

Description: This table is used to store exceptions and errors
Comments

Table to store exceptions by the Generate Capitalized Interest process.

Indexes
Index Type Tablespace Column
IPA_INTEREST_ERRORS_U1 UNIQUE APPS_TS_TX_IDX INTEREST_ERROR_ID
IPA_INTEREST_ERRORS_N1 NONUNIQUE APPS_TS_TX_IDX BATCH_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_ERROR_ID NUMBER
Y System Generated ID
BATCH_ID NUMBER
Y Interest batch ID
ERROR_TEXT VARCHAR2 (200) Y Error Description
PROJECT_NUM VARCHAR2 (25)
Project number of the errored line
TASK_NUM VARCHAR2 (25)
Task Number of the errored line
RATE_CODE VARCHAR2 (25)
Rate name used
RATE_TYPE VARCHAR2 (25)
Obsolete
GL_PERIOD_NAME VARCHAR2 (15)
GL period name
EXPENDITURE_TASK_NUM VARCHAR2 (25)
Obsolete

[top of page]

IPA.IPA_INTEREST_ERRORS does not reference any database object

IPA.IPA_INTEREST_ERRORS is referenced by following:

APPS
SYNONYM - IPA_INTEREST_ERRORS

[top of page]

Table: IPA_INTEREST_RUN_BATCHES

Description: A batch is created for each run and this table stores the run informatio
Comments

Table to store Capitalized Interest run information.

Indexes
Index Type Tablespace Column
IPA_INTEREST_RUN_BATCHES_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Y System Generated ID created for the run
GL_PERIOD_NAME VARCHAR2 (15)
GL period of the run
RUN_STATUS VARCHAR2 (15)
Status of the run
REQUEST_ID NUMBER

Concurrent request ID
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column

[top of page]

IPA.IPA_INTEREST_RUN_BATCHES does not reference any database object

IPA.IPA_INTEREST_RUN_BATCHES is referenced by following:

APPS
SYNONYM - IPA_INTEREST_RUN_BATCHES

[top of page]

Table: IPA_INTEREST_SUSPENSION

Description: This table is used to store the information of interest suspension on projects for the specifed time period
Comments

Table to store Capitalized Interest suspension information on projects.

Indexes
Index Type Tablespace Column
IPA_INTEREST_SUSPENSION_N1 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Y Project on which interest is suspended
LAST_ACTIVITY_DATE DATE

Last date of activity on this project
SUSPEN_START_DATE DATE
Y Begin date of Interest suspension period
SUSPEN_END_DATE DATE

End date of Interest suspension period
COMMENTS VARCHAR2 (100)
Comments
CREATED_BY NUMBER (15) Y Created By
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_INTEREST_SUSPENSION does not reference any database object

IPA.IPA_INTEREST_SUSPENSION is referenced by following:

APPS
SYNONYM - IPA_INTEREST_SUSPENSION

[top of page]

Table: IPA_ORGANIZATION_INTERESTS

Description: Table stores the rates assigned to various organizations
Comments

Table to store the capitalized interest overrides at the organization level

Indexes
Index Type Tablespace Column
IPA_ORGANIZATION_INTEREST_N1 NONUNIQUE APPS_TS_TX_IDX RATE_CODE
IPA_ORGANIZATION_INTEREST_N2 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
IPA_ORGANIZATION_INTEREST_U1 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_INTEREST_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_INTEREST_ID NUMBER (15) Y System Generated ID
RATE_CODE VARCHAR2 (25) Y Rate structure name
BUSINESS_GROUP_ID NUMBER (15) Y Business group ID
ORGANIZATION_ID NUMBER (15) Y Organization ID
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
THRESHOLD_AMOUNT NUMBER (15)
Threshold amount above which Interest needs to be applied
CAPITALIZE_INTEREST VARCHAR2 (1) Y Flag to control application interest at the Organization level
EFFECTIVE_DATE_TO DATE

End Date up to which this rate assignment is valid
EFFECTIVE_DATE_FROM DATE
Y Begin Date from which this rate assignment is valid
COMMENTS VARCHAR2 (100)
Comments

[top of page]

IPA.IPA_ORGANIZATION_INTERESTS does not reference any database object

IPA.IPA_ORGANIZATION_INTERESTS is referenced by following:

APPS
SYNONYM - IPA_ORGANIZATION_INTERESTS

[top of page]

Table: IPA_PROJECT_INTERESTS

Description: Table stores rate assignment at project level
Comments

Table to store the capitalized interest overrides at the project level

Indexes
Index Type Tablespace Column
IPA_PROJECT_INTERESTS_U1 UNIQUE APPS_TS_TX_IDX PROJECT_INTEREST_ID
IPA_PROJECT_INTERESTS_N1 NONUNIQUE APPS_TS_TX_IDX RATE_CODE
Columns
Name Datatype Length Mandatory Comments
PROJECT_INTEREST_ID NUMBER (15) Y System Generated ID
RATE_CODE VARCHAR2 (25) Y Rate structure name
PROJECT_ID NUMBER (15) Y Project to which this rate is assigned
CAPITALIZE_INTEREST VARCHAR2 (1) Y Falg to control application interest at the Project level
EFFECTIVE_DATE_FROM DATE
Y Begin Date from which this assignment is valid
EFFECTIVE_DATE_TO DATE

End Date to which this assignment is valid
THRESHOLD_AMOUNT NUMBER

Threshold amount above which Interest needs to be applied
COMMENTS VARCHAR2 (100)
Comments
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_PROJECT_INTERESTS does not reference any database object

IPA.IPA_PROJECT_INTERESTS is referenced by following:

APPS
SYNONYM - IPA_PROJECT_INTERESTS

[top of page]

Table: IPA_PROJECT_INT_EXCLUSIONS

Description: Table to store projects on which Interest must not be applied
Comments

Table to store the capitalized interest exclusions at the project level

Indexes
Index Type Tablespace Column
IPA_PROJECT_INT_EXCLUSIONS_U1 UNIQUE APPS_TS_TX_IDX PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Y Project on which interest to be excluded
EXCLUDE_INTEREST VARCHAR2 (1) Y Flag indicates interest is excluded for the project Y - Indicates Interest is excluded on the entire project
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_PROJECT_INT_EXCLUSIONS does not reference any database object

IPA.IPA_PROJECT_INT_EXCLUSIONS is referenced by following:

APPS
SYNONYM - IPA_PROJECT_INT_EXCLUSIONS

[top of page]

Table: IPA_RATE_PERIODS

Description: This table is used to store the APR for different time periods for the rate code
Comments

Table to store Capitalized Interest rates by rate name.

Indexes
Index Type Tablespace Column
IPA_RATE_PERIODS_N1 NONUNIQUE APPS_TS_TX_IDX RATE_CODE
Columns
Name Datatype Length Mandatory Comments
RATE_CODE VARCHAR2 (25) Y Rate structure name
RATE NUMBER
Y Annual percent Rate for the structure name
START_DATE_ACTIVE DATE
Y Start date from which this rate is active
END_DATE_ACTIVE DATE

End date up to which this rate is active
COMMENTS VARCHAR2 (100)
Comments for rate change
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_RATE_PERIODS does not reference any database object

IPA.IPA_RATE_PERIODS is referenced by following:

APPS
SYNONYM - IPA_RATE_PERIODS

[top of page]

Table: IPA_RATE_STRUCTURES

Description: This table is used to store the Rate structure information for the capitalized interest module
Comments

Table to store Capitalized Interest Rate Structure details.

Indexes
Index Type Tablespace Column
IPA_RATE_STRUCTURES_U1 UNIQUE APPS_TS_TX_IDX RATE_CODE
Columns
Name Datatype Length Mandatory Comments
RATE_CODE VARCHAR2 (25) Y Rate structure name
FORMULA_NAME VARCHAR2 (30)
Formula used by the Rate structure (future use)
DESCRIPTION VARCHAR2 (100)
Description
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield

[top of page]

IPA.IPA_RATE_STRUCTURES does not reference any database object

IPA.IPA_RATE_STRUCTURES is referenced by following:

APPS
SYNONYM - IPA_RATE_STRUCTURES

[top of page]

Table: IPA_TASK_INTERESTS

Description: Table stores rate assignments at task level
Comments

Table to store the capitalized interest overrides at the task level.

Indexes
Index Type Tablespace Column
IPA_TASK_INTERESTS_U1 UNIQUE APPS_TS_TX_IDX TASK_INTEREST_ID
IPA_TASK_INTERESTS_N1 NONUNIQUE APPS_TS_TX_IDX RATE_CODE
IPA_TASK_INTERESTS_N2 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
IPA_TASK_INTERESTS_N3 NONUNIQUE APPS_TS_TX_IDX TASK_ID
Columns
Name Datatype Length Mandatory Comments
TASK_INTEREST_ID NUMBER (15) Y System Generated ID
RATE_CODE VARCHAR2 (25) Y Rate structure name
TASK_ID NUMBER (15) Y Task to which this rate is applied
PROJECT_ID NUMBER (15) Y Project to which the task belongs
CAPITALIZE_INTEREST VARCHAR2 (1) Y Falg to control application interest at the Organization level
EFFECTIVE_DATE_FROM DATE
Y Begin Date from which this rate assignment is valid
EFFECTIVE_DATE_TO DATE

End Date up to which this rate assignment is valid
TASK_THRESHOLD NUMBER

Task Threshold
COMMENTS VARCHAR2 (100)
Comments
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_TASK_INTERESTS does not reference any database object

IPA.IPA_TASK_INTERESTS is referenced by following:

APPS
SYNONYM - IPA_TASK_INTERESTS

[top of page]

Table: IPA_TASK_INT_EXCLUSIONS

Description:
Comments

Table to store the capitalized interest exclusions at the task level.

Indexes
Index Type Tablespace Column
IPA_TASK_INT_EXCLUSIONS_U1 UNIQUE APPS_TS_TX_IDX TASK_ID
IPA_TASK_INT_EXCLUSIONS_N1 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (15) Y Task for which interest is excluded
PROJECT_ID NUMBER (15) Y Project Id
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

IPA.IPA_TASK_INT_EXCLUSIONS does not reference any database object

IPA.IPA_TASK_INT_EXCLUSIONS is referenced by following:

APPS
SYNONYM - IPA_TASK_INT_EXCLUSIONS

[top of page]

View: IPA_BUSINESS_GROUP_INTERESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BUSINESS_GROUP_INTEREST_ID NUMBER (15) Y
RATE_CODE VARCHAR2 (25) Y
BUSINESS_GROUP_ID NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE VARCHAR2 (240)
LAST_UPDATE_LOGIN VARCHAR2 (240)
OVERRIDE_FLAG VARCHAR2 (1) Y
THRESHOLD_AMOUNT NUMBER (15)
CAPITALIZE_INTEREST VARCHAR2 (1) Y
COMMENTS VARCHAR2 (100)
BUSINESS_GROUP_NAME VARCHAR2 (240) Y
DEFAULT_EXPENDITURE_TYPE VARCHAR2 (30) Y

[top of page]

APPS.IPA_BUSINESS_GROUP_INTERESTS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - IPA_BUSINESS_GROUP_INTERESTS

APPS.IPA_BUSINESS_GROUP_INTERESTS_V is not referenced by any database object

[top of page]

View: IPA_INTEREST_BATCHES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
INTEREST_BATCH_ID NUMBER (15) Y
BATCH_ID NUMBER (15) Y
PROJECT_ID NUMBER (15)
PROJECT_NUMBER VARCHAR2 (25) Y
RATE_TYPE VARCHAR2 (30)
INTEREST_APPLIED NUMBER (15)
STATUS VARCHAR2 (20)
GL_PERIOD VARCHAR2 (15)
PERIOD_BEGIN_DATE DATE

PERIOD_END_DATE DATE

EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
REVERSAL_DATE DATE

[top of page]

APPS.IPA_INTEREST_BATCHES_V references the following:

APPS
SYNONYM - IPA_INTEREST_BATCHES
SYNONYM - PA_PROJECTS
SYNONYM - PA_TASKS

APPS.IPA_INTEREST_BATCHES_V is not referenced by any database object

[top of page]

View: IPA_INTEREST_SUSPENSION_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROJECT_ID NUMBER (15) Y
LAST_ACTIVITY_DATE DATE

SUSPEN_START_DATE DATE
Y
SUSPEN_END_DATE DATE

COMMENTS VARCHAR2 (100)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
PROJECT_NUMBER VARCHAR2 (25) Y
NAME VARCHAR2 (30) Y

[top of page]

APPS.IPA_INTEREST_SUSPENSION_V references the following:

APPS
SYNONYM - IPA_INTEREST_SUSPENSION
SYNONYM - PA_PROJECTS_ALL

APPS.IPA_INTEREST_SUSPENSION_V is not referenced by any database object

[top of page]

View: IPA_ORGANIZATION_INTERESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORGANIZATION_INTEREST_ID NUMBER (15) Y
RATE_CODE VARCHAR2 (25) Y
BUSINESS_GROUP_ID NUMBER (15) Y
ORGANIZATION_ID NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
THRESHOLD_AMOUNT NUMBER (15)
CAPITALIZE_INTEREST VARCHAR2 (1) Y
EFFECTIVE_DATE_TO DATE

EFFECTIVE_DATE_FROM DATE
Y
COMMENTS VARCHAR2 (100)
ORGANIZATION_NAME VARCHAR2 (240) Y

[top of page]

APPS.IPA_ORGANIZATION_INTERESTS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - IPA_ORGANIZATION_INTERESTS

APPS.IPA_ORGANIZATION_INTERESTS_V is not referenced by any database object

[top of page]

View: IPA_PROJECT_INTERESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROJECT_INTEREST_ID NUMBER (15) Y
RATE_CODE VARCHAR2 (25) Y
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
CAPITALIZE_INTEREST VARCHAR2 (1) Y
EFFECTIVE_DATE_FROM DATE
Y
EFFECTIVE_DATE_TO DATE

THRESHOLD_AMOUNT NUMBER

COMMENTS VARCHAR2 (100)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.IPA_PROJECT_INTERESTS_V references the following:

APPS
SYNONYM - IPA_PROJECT_INTERESTS
SYNONYM - PA_PROJECTS_ALL

APPS.IPA_PROJECT_INTERESTS_V is not referenced by any database object

[top of page]

View: IPA_TASK_INTERESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TASK_INTEREST_ID NUMBER (15) Y
RATE_CODE VARCHAR2 (25) Y
TASK_ID NUMBER (15) Y
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
CAPITALIZE_INTEREST VARCHAR2 (1) Y
EFFECTIVE_DATE_FROM DATE
Y
EFFECTIVE_DATE_TO DATE

TASK_THRESHOLD NUMBER

COMMENTS VARCHAR2 (100)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.IPA_TASK_INTERESTS_V references the following:

APPS
SYNONYM - IPA_TASK_INTERESTS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS

APPS.IPA_TASK_INTERESTS_V is not referenced by any database object

[top of page]

View: PA_CDL_BURDEN_DETAIL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view displays all the burden components of the CDLs for a project. The project must be set in pa_cost_plus_extn1.current_project_id

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
Project id of the cost distribution line item whose burden components are being summarized
TASK_ID NUMBER (15)
task id of the cost distribution line item whose burden components are being summarized
ORGANIZATION_ID NUMBER

Organization actually incurred the expenses or the overriding organization of an expenditure item
PA_DATE DATE

Account period end date of an expenditure item
PA_PERIOD_NAME VARCHAR2 (4000)
Account period name of an expenditure item
ATTRIBUTE1 VARCHAR2 (150)
Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE2 VARCHAR2 (150)
Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE3 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE4 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE5 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE6 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE7 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE8 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE9 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE10 VARCHAR2 (150)
Flex field used for customization
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flex field used for customization
PERSON_TYPE VARCHAR2 (30)
Type of person who incurred the expenditure
PO_LINE_ID NUMBER

Purchase order line identifier for imported contingent worker labor transactions
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
System Linkage Function of the Expenditure Item
IND_COST_CODE VARCHAR2 (30)
Indirect cost code associated with the expenditure type of an expenditure item
EI_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type of an expenditure item
ICC_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type of the indirect cost code associated with an expenditure item. Each indirect cost code may be associated with one expenditure type
COST_BASE VARCHAR2 (30)
Cost base code of the expenditure item
COMPILED_MULTIPLIER NUMBER (22)
Indicative code for applying the indirect cost multiplication factors for the CDL for each burden cost code of the CDL
IND_COMPILED_SET_ID NUMBER (15)
Ind Compiled Set Id
EXPENDITURE_ITEM_ID NUMBER (15)
Identifier of the expenditure item being used for burden summarization
LINE_NUM NUMBER (15)
Line item number of the CDL of an expenditure item
EXPENDITURE_ITEM_DATE DATE

Date of creation of the line_item
BURDEN_COST NUMBER

Total burden cost of the CDL (In Project Currency)
DENOM_BURDENED_COST NUMBER

Total burden cost of the CDL (In Denomination Currency)
ACCT_BURDENED_COST NUMBER

Total burden cost of the CDL (In Acct Currency)
PROJECT_BURDENED_COST NUMBER

Burdened cost in project currency
BURDEN_SUM_SOURCE_RUN_ID NUMBER (15)
Unique number identifying the run of a burden summarization process. All the CDLs processed,summarized burden \ expenditure items created during a run are stamped with one run id fro sequence pa_burden_sum_run_id_s
BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
Code identifies the rejection reason for a CDL during summarization. Rejected CDLs can be corrected for the \ error and they will be summarized in the susequent run
SYSTEM_REFERENCE1 VARCHAR2 (30)
For Supplier Invoices, holds the Vendor Id
DENOM_CURRENCY_CODE VARCHAR2 (15)
Denom Currency Code
ACCT_CURRENCY_CODE VARCHAR2 (15)
Acct Currency Code
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project Currency Code
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project Functional Currency Code
BILLABLE_FLAG VARCHAR2 (1)
For Expenditure Items holds Billable Flag
REQUEST_ID NUMBER (15)
Request Id stamped temporarily during processing on the CDL of an Expenditure Item
ADJUSTMENT_TYPE VARCHAR2 (150)
Adjustment Type Code
JOB_ID NUMBER (15)
Identifier of the job of employee
NON_LABOR_RESOURCE VARCHAR2 (20)
Non Labor Resource
NON_LABOR_RESOURCE_ORGN_ID NUMBER (15)
Identifier of the organization that owns the non labor resource
WIP_RESOURCE_ID NUMBER

Identifier of the resource for work in progress
INCURRED_BY_PERSON_ID NUMBER (15)
Identifier of the employee who incurred the charges
INVENTORY_ITEM_ID NUMBER

Identifier of the inventory item
ORG_ID NUMBER (15)
Organization Id
ACCT_RATE_DATE DATE

Acct Rate Date
ACCT_RATE_TYPE VARCHAR2 (30)
Acct Rate Type
ACCT_EXCHANGE_RATE NUMBER

Acct Exchange Rate
PROJECT_RATE_DATE DATE

Project Rate Date
PROJECT_RATE_TYPE VARCHAR2 (30)
Project Rate Type
PROJECT_EXCHANGE_RATE NUMBER

Project Exchange Rate
PROJFUNC_COST_RATE_DATE DATE

Projfunc Cost Rate Date
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Projfunc Cost Rate Type
PROJFUNC_COST_EXCHANGE_RATE NUMBER

Projfunc Cost Exchange Rate

[top of page]

APPS.PA_CDL_BURDEN_DETAIL_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - PA_BURDEN_COSTING
SYNONYM - PA_COMPILED_MULTIPLIERS
PACKAGE - PA_CURRENCY
SYNONYM - PA_EI_CDL_CM_GTEMP
SYNONYM - PA_IND_COST_CODES
APPS.PA_CDL_BURDEN_DETAIL_V is referenced by following:

APPS
VIEW - PA_CDL_BURDEN_SUMMARY_V

[top of page]

View: PA_CDL_BURDEN_SUMMARY_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary group.

Columns
Name Datatype Length Mandatory Comments
SOURCE_PROJECT_ID NUMBER (15)
Project id to which a CDL which is being summarized belongs to. The column alias must be SOURCE_PROJECT_ID
SOURCE_TASK_ID NUMBER (15)
Task id to which a CDL which is being summarized belongs to. The column alias must be SOURCE_TASK_ID
SOURCE_ORG_ID NUMBER

Expenditure organization or the incurred Organization. The column alias must be source_ORG_ID
SOURCE_PA_DATE DATE

Accounting closing date of expenditure item. The column alias must be source_PA_DATE
SOURCE_PA_PERIOD_NAME VARCHAR2 (4000)
PA Period name of the source transaction
SOURCE_ATTRIBUTE1 VARCHAR2 (150)
Flexfield 1 of expenditure item. This can be used for user defined grouping. this field is used as award_id in Grants Accounting.\ The alias must be source_ATTRIBUTE1
SOURCE_ATTRIBUTE2 VARCHAR2 (150)
Flexfield 2 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE2
SOURCE_ATTRIBUTE3 VARCHAR2 (150)
Flexfield 3 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE3
SOURCE_ATTRIBUTE4 VARCHAR2 (150)
Flexfield 4 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE4
SOURCE_ATTRIBUTE5 VARCHAR2 (150)
Flexfield 5 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE5
SOURCE_ATTRIBUTE6 VARCHAR2 (150)
Flexfield 6 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE6
SOURCE_ATTRIBUTE7 VARCHAR2 (150)
Flexfield 7 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE7
SOURCE_ATTRIBUTE8 VARCHAR2 (150)
Flexfield 8 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE8
SOURCE_ATTRIBUTE9 VARCHAR2 (150)
Flexfield 9 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE9
SOURCE_ATTRIBUTE10 VARCHAR2 (150)
Flexfield 10 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE10
SOURCE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield context field of expenditure item. The alias must be source_ATTRIBUTE_CATEGORY
SOURCE_PERSON_TYPE VARCHAR2 (30)
Type of person who incurred the expenditure
SOURCE_PO_LINE_ID NUMBER

Purchase order line identifier for imported contingent worker labor transactions
SOURCE_SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
System Linkage Function of the Expenditure Item
SOURCE_IND_COST_CODE VARCHAR2 (30)
Indirect Cost code. The column alias must be source_ind_cost_code
SOURCE_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type of the expenditure item. The column alias must be SOURCE_EXPENDITURE_TYPE
SOURCE_IND_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type corresponding to the burden cost code of the burden component of an expenditure item. \ The column alias must be SOURCE_IND_EXPENDITURE_TYPE
SOURCE_COST_BASE VARCHAR2 (30)
Indirect cost base. The column alias must be source_cost_base
SOURCE_COMPILED_MULTIPLIER NUMBER (22)
Indirect cost compiled multiplier of a CDL. The column alias must be SOURCE_compiled_multiplier
SOURCE_EXP_ITEM_ID NUMBER (15)
Expenditure item identifier. The column alias must be source_expenditure_item_id
SOURCE_LINE_NUM NUMBER (15)
Line number of a CDL under an expenditure item id. The column alias must be source_line_num
SOURCE_EXP_ITEM_DATE DATE

Date of expenditure occurance. The column alias must be source_expenditure_item_date
SOURCE_BURDEN_COST NUMBER

Burden cost(in project currency)due to a burden cost component an expenditure type of an expenditure item. \ The column alias must be source_burden_cost
SOURCE_DENOM_BURDENED_COST NUMBER

Burden cost(in denom currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_burden_cost
SOURCE_ACCT_BURDENED_COST NUMBER

Burden cost(in acct currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_burden_cost
SOURCE_PROJECT_BURDENED_COST NUMBER

Burden cost(in project currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_project_burdened_cost
SOURCE_DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination Currency Code of the Expenditure Item
SOURCE_ACCT_CURRENCY_CODE VARCHAR2 (15)
Acct Currency Code of the Expenditure Item
SOURCE_PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project Currency Code of the Expenditure Item
SOURCE_PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project Functional Currency Code of the Expenditure Item
SOURCE_ID NUMBER (15)
Burden sum_source_run_id from Cost Distribution Lines. The column alias must be source_id
SOURCE_BURDEN_REJECT_CODE VARCHAR2 (30)
Rejection reason code for a CDL not summarized due to validation errors. The column alias must be source_burden_sum_rejection_code
SOURCE_VENDOR_ID VARCHAR2 (30)
For Expense Reports - holds the Vendor Id.
DEST_ORG_ID NUMBER

Expenditure organization or the incurred Organization. The column alias must be DEST_ORG_ID, user can override this value
DEST_PA_DATE DATE

Accounting closing date of expenditure item. The column alias must be DEST_PA_DATE , user can override this value
DEST_ATTRIBUTE1 VARCHAR2 (150)
Flexfield 1 of expenditure item. This can be used for user defined grouping. this field is used as award_id in Grants Accounting.\ The alias must be DEST_ATTRIBUTE1, user can override this value
DEST_IND_EXPENDITURE_TYPE VARCHAR2 (30)
The Expenditure Type of the summary burden transaction
BILLABLE_FLAG VARCHAR2 (1)
Identifier of the billability of the transaction
SOURCE_ADJUSTMENT_TYPE VARCHAR2 (150)
Type of the last adjustment action on the transaction
DEST_SUMMARY_GROUP VARCHAR2 (4000)
User defined fields for summarization criteria. User can include \ source_project_id, source_task_id, organization_id, pa_date, ind_cost_code,currency codes, attribute 1 \ User can exclude the attribute1 from the list if required. This clumn must has the alias DEST_SUMMARY_GROUP, user can override this value
DEST_SUMMARY_GROUP_RESUM VARCHAR2 (4000)
Same as DEST_SUMMARY_GROUP
SOURCE_REQUEST_ID NUMBER (15)
Request id stamped on a CDL which is being summarized . The column alias must be SOURCE_REQUEST_ID
SOURCE_JOB_ID NUMBER (15)
Identifier of the job of employee
SOURCE_NL_RESOURCE VARCHAR2 (20)
Non Labor Resource
SOURCE_NL_RESOURCE_ORGN_ID NUMBER (15)
Identifier of the organization that owns the non labor resource
SOURCE_WIP_RESOURCE_ID NUMBER

Identifier of the resource for work in progress
SOURCE_INCURRED_BY_PERSON_ID NUMBER (15)
Identifier of the employee who incurred the charges
SOURCE_INVENTORY_ITEM_ID NUMBER

Identifier of the inventory item
SRC_ACCT_RATE_DATE DATE

Functional currency exchange rate date.
SRC_ACCT_RATE_TYPE VARCHAR2 (30)
Functional currency exchange rate type.
SRC_ACCT_EXCHANGE_RATE NUMBER

Functional currency exchange rate.
SRC_PROJECT_RATE_DATE DATE

Project currency exchange rate date.
SRC_PROJECT_RATE_TYPE VARCHAR2 (30)
Project currency exchange rate type.
SRC_PROJECT_EXCHANGE_RATE NUMBER

Project currency exchange rate.
SRC_PROJFUNC_COST_RATE_DATE DATE

Project Functional currency exchange rate date.
SRC_PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Project Functional currency exchange rate type.
SRC_PROJFUNC_COST_XCHNG_RATE NUMBER

Project Functional currency exchange rate.

[top of page]

APPS.PA_CDL_BURDEN_SUMMARY_V references the following:

APPS
PACKAGE - PA_BURDEN_COSTING
VIEW - PA_CDL_BURDEN_DETAIL_V
PACKAGE - PA_CLIENT_EXTN_BURDEN_RESOURCE
PACKAGE - PA_CLIENT_EXTN_BURDEN_SUMMARY
PACKAGE - PA_CURRENCY
APPS.PA_CDL_BURDEN_SUMMARY_V is referenced by following:

APPS
PACKAGE BODY - PA_BURDEN_COSTING

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract