| Code |
Meaning |
Description |
| ADJUSTMENT_TYPE |
Invoice Adjustment Type options |
Displays invoice adjustment type codes for lookup type INVOICE ADJUSTMENT TYPE |
| AGE_UR_FROM |
List of Optional dates to age unbilled receivables from |
Displays optional date codes for lookup type AGE UNBILLED RECEIVABLES FROM that can be used to age unbilled receivables from |
| AGREEMENT_ID |
List of Agreements. Passes agreement_id as report parameter. |
Displays agreement_number, customer_name, and agreement_type. Agreement_id is passed as the report parameter value |
| AGREEMENT_NUMBER |
List Of Agreements with Customers |
Displays agreement number, customer, and agreement type. Agreement number is passed as the report parameter value |
| AGREEMENT_SORT |
Sort By Options for Customer Agreement Status Report |
Displays sort by option codes for lookup type AGREEMENT SORT TYPES |
| AR_COLLECTOR |
List of Collectors from Oracle Receivables |
Displays collectors names from Oracle Receivables. The collector_id is passed as the report parameter value |
| AR_INVOICE_TYPE |
List of Oracle Revenue Accounting Invoice Types |
Displays invoice types from Oracle Revenue Accounting. The invoice type name is passed as the report parameter value |
| AST_SORT_BY |
Report Sort By Options for Ordering Employee Assignments |
Displays report sort by codes for lookup type ASSIGNMENT SORT BY |
| BATCH_NAME |
Expenditure Batch Names |
Displays name and date of released expenditure batches. The batch name is passed as the report parameter value |
| BILLING_TYPE |
Billing Method |
Displays Work or Event Billing Method codes for the lookup type BILLING_TYPE |
| BUCKET_NAME |
Aging Bucket Names From Oracle Receivables |
Displays names of aging buckets in Oracle Receivables. The aging bucket name is passed as the report parameter value |
| BUDGET_TYPE |
Budget Types |
Displays the budget types using the lookup type BUDGET TYPE |
| CLASS_CATEGORY |
Class Categories |
Displays class categories and descriptions. The class category is passed as the report parameter value |
| CLOSING_STATUS |
PA Period Closing Status |
Displays the statuses of PA periods using the lookup type CLOSING STATUS |
| COMPENSATION_RULE_SET |
Compensation Rule |
Displays compensation rules |
| CONTROL_EXP_GROUP_SORT_BY |
List of Expenditure Group Sort Options |
Displays the expenditure group sort by options of the lookup type CONTROL EXP GROUP SORT BY |
| CONTROL_EXP_SORT_BY |
List of Expenditure Item Sort Options |
Displays the expenditure sort by options of the lookup type CONTROL EXP SORT BY |
| CURRENCY_CODE |
Currency Codes and Description |
Display currencies and their descriptions in Oracle General Ledger. The currency code is passed as the report parameter value |
| DISTRIBUTION_RULE |
Distribution Rules |
Displays distribution rules |
| EMPLOYEE_LOV |
List of current employees |
Displays employees (employee name, employee number, current employee (Y/N)). The person_id is passed as the report parameter value |
| EVENT_SORT_BY |
Event sort by options |
Displays sort by options of the lookup type EVENT DETAILS SORT BY |
| EVENT_TYPE |
Event Types |
Displays event types and their descriptions. The event type is passed as the report parameter value |
| EVENT_TYPE_CLASSIFICATION |
Event Type Classification |
Displays the event type classifications of the lookup type EVENT TYPE CLASSIFICATION |
| EXPENDITURE_CATEGORY |
Expenditure Categories |
Displays expenditure categories |
| EXPENDITURE_GROUP |
List of Expenditure Groups |
Displays expenditure groups and their system linkages |
| EXPENDITURE_GROUP_RELEASED |
List of Released Expenditure Groups |
Displays released expenditure groups and their system linkages |
| EXPENDITURE_GROUP_STATUS |
List of Expenditure Group Statuses |
Displays expenditure group statuses of the lookup type EXP GROUP REPORTING STATUS |
| EXPENDITURE_SORT_BY |
Expenditure Item sort by options |
Displays expenditure item sort by options of the lookup type EXPENDITURES SORT BY |
| EXPENDITURE_STATUS |
List of Expenditure Statuses |
Displays expenditure statuses of the lookup type EXPENDITURE STATUS |
| EXPENDITURE_SUMMARY_SORT_BY |
Expenditure sort by options |
Displays expenditure sort by options of the lookup type EXPENDITURES SUMMARY SORT BY |
| EXPENDITURE_TYPE |
Expenditure Types |
Displays expenditure types and their expenditure categories |
| FUNCTION_NAME |
AutoAccounting Function Names |
Displays AutoAccounting functions and their descriptions |
| GL_PERIODS_LOV |
GL Periods |
Displays GL periods, and the corresponding start date, end date, and status. The GL period name is passed as the report parameter value |
| INVOICE_AMOUNT_RANGE |
Invoice Amount Range |
Displays amount range codes of the lookup type INVOICE_AMOUNT_RANGE |
| INVOICE_FORMATS |
Invoice Format Names |
Displays invoice formats. The invoice_format_id is passed as the report parameter value |
| INVOICE_GROUPING |
Invoice Grouping Names |
Displays invoice groups. The invoice_group_id is passed as the report parameter value |
| INVOICE_REVENUE_STATUS |
List of Invoice/Revenue Statuses |
Displays all valid invoice status codes of the lookup type INVOICE_REVENUE_STATUS |
| INVOICE_STATUS |
List of invoice statuses of Released, Unreleased, and All |
Displays the invoice status codes of the lookup type INVOICE STATUS |
| JOB_DISCIPLINE |
Job Discipline |
Displays the job discipline segments (segment2) of the job key flexfield. The segment2 value is passed as the report parameter value |
| JOB_LEVEL |
Job Level |
Displays the job level segments (segment1) of the Job Key Flexfield. The segment1 value is passed as the report parameter value |
| JOB_NAME |
Job Names |
Displays job names. The job_id is passed as the report parameter value |
| JOB_SORT_BY |
Job Sort By Options |
Displays the job sort by options of the lookup type JOB SORT BY |
| LABOR_ORG_SORT_BY |
Sort By Option for Labor Cost By Organization Report |
Displays the sort by options of the lookup type LABOR SORT BY |
| LABOR_SORT_BY |
Sort By Options for Labor Cost Rates Reports |
Displays the sort by options of the lookup type LABOR RATE SORT BY |
| LOOKUP_TYPE |
List of all lookup_types from pa_lookups |
Displays PA lookup types |
| NONE |
No Quickpick |
No quickpick validation is done |
| NON_LABOR_RESOURCE |
Non Labor Resource |
Displays non-labor resources assigned to organizations. If a non-labor resource organization is chosen before this parameter, only resources in that organization are displayed. Report parameter value=non-labor resource. |
| NON_LABOR_RESOURCE_ORG |
Non Labor Resource Organizations |
Displays organizations that own non-labor resources. If a non-labor resource is chosen before this parameter, only organizations that own that non-labor resources are displayed. Report parameter value=Organization_id |
| ORGANIZATION_NAME |
Organization Names |
Displays organizations. The organization_id is passed as the report parameter value |
| ORGANIZATION_STRUCTURE_NAME |
Organization Hierarchies |
Displays the organization hierarchies. The organization_structure_id is passed as the report parameter value |
| ORG_TYPE |
Organization Type |
Displays Organization Types |
| PAST_DUE_SORT_BY |
Sort By Options for Past Due Invoices Report |
Displays the sort by options of the lookup type PAST DUE SORT |
| PA_PERIODS |
List Of Project Accounting Periods |
Displays PA periods and the corresponding start date and end date. The PA period name is passed as the report parameter value |
| PRODUCTION_REPORT_BY |
Report By Options for Production Summary |
Displays report options of the lookup type PRODUCTION SUMMARY REPORT BY |
| PROJECT_CUSTOMERS |
List of Project Customers |
Displays customers who are project customers. The customer_id is passed as the report parameter value |
| PROJECT_MANAGERS |
List of Project Managers |
Displays project manager names. The person_id is passed as the report parameter value |
| PROJECT_MANAGER_NAME |
Project Manager Quickpick which passes in Manager Name |
Displays project manager names. The employee full name is passed as the report parameter value |
| PROJECT_NAME_NUM_ALIAS |
Project Name Number and Alias |
Displays projects (project number, project name, and project status). The project_id is passed as the report parameter value |
| PROJECT_NUMBER |
Project Quickpick which passes in project_number |
Displays projects including project numbers, project names, and project statuses. The project number (segment1) is passed as the report parameter value |
| PROJECT_ORGANIZATION |
Project Organizations |
Displays project organizations based on the project organization type. The organization_id is passed as the report parameter value |
| PROJECT_ORGANIZATION_NAME |
Project Organization Quickpick that passes Organization Name |
Displays project organizations based on the project organization type. The organization name is passed as the report parameter value |
| PROJECT_ROLE_TYPE |
Project Role Types |
Displays project role types |
| PROJECT_STATUS |
Project Status Option for Management Reports |
Displays project statuses |
| PROJECT_TYPE |
Project Types |
Displays project types and their descriptions |
| RECEIVABLES_FORMAT |
Format Option for Receivables Aging Report |
Displays receivables format options of the lookup type of RECEIVABLES FORMAT |
| RECEIVABLES_SORT |
Sort Option for Receivables Aging Report |
Displays the receivables aging sort by options of the lookup type RECEIVABLES SORT SUMMARY |
| REGISTER_SORT |
Sort Option For Invoice Register Report |
Displays invoice register sort by options of the lookup type INVOICE REGISTER SORT |
| RELEASED_EXP_BATCH_NAME |
List of Released Expenditure Batch Names |
Displays released expenditure batches. The expenditure batch name is passed as the report parameter value |
| RESP_TYPE |
Process Responsibility Type |
Displays process responsibility types and their descriptions |
| REVENUE_CATEGORY |
Revenue Categories |
Displays revenue categories |
| REVENUE_FLOW_OPTION |
Status Options for Revenue Flow Detail Report |
Displays revenue flow statuses of the lookup type REVENUE FLOW OPTION |
| REVENUE_TRANSFER_OPTIONS |
Revenue Transfer Options |
Displays the revenue transfer options of the lookup type REVENUE TRANSFER OPTIONS |
| RULE_NAME |
AutoAccounting Rule Name |
Displays AutoAccounting rule names. The rule_id is passed as the report parameter value |
| SEGMENT_VALUE_LOOKUP_SET |
AutoAccounting Segment Value Lookups |
Displays AutoAccounting segment value lookup sets. The segment_value_lookup_set_id is passed as the report parameter value |
| SERVICE_TYPE |
Service Type |
Displays service types |
| STANDARD_BILL_RATE_SCHEDULE |
Standard Bill Rate Schedules |
Displays standard bill rate schedules and their organizations. The std_bill_rate_schedule name is passed as the report parameter value |
| STREAMLINE_OPTION_LOOKUP |
Interface Streamline Option for Submit Streamline Process |
Displays the interface streamline options of the lookup type INTERFACE STREAMLINE OPTION |
| SYSTEM_LINKAGE_FUNCTION |
System Linkage Functions |
Displays system linkages. The system linkage function code is passed as the report parameter value |
| TASK_LOWEST |
Lowest Level Tasks |
Displays lowest level tasks of a project. The project parameter must be chosen before this parameter. The task_id is passed as the report parameter |
| TASK_NAME_NUM |
Task names and numbers with project name, number and alias |
Displays all tasks for a project. The project parameter must be chosen before this parameter. The task_id is passed as the report parameter value |
| TASK_TOP |
Top Level Tasks |
Displays top level tasks of a project. The project parameter must be chosen before this parameter. The task_id is passed as the report parameter |
| TRANSACTION_SOURCE |
List of transaction sources |
Displays each distinct transaction source of the unprocessed transactions in the transction interface table. Transaction Source is passed as the report parameter value |
| TRANSFER_STATUS |
Transfer Status |
Displays the transfer statuses of the lookup type TRANSFER STATUS |
| TRX_BATCH_NAME |
Batch names for transactions in transaction interface table |
Displays batch names for all unprocessed transactions in the transaction interface table for a given transaction source. Batch Name is passed as the report parameter value |
| YES_NO_LOV |
Yes/No Quickpick |
Displays Yes/No options |
[Home] [Help]