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 |