Search Results tp_fixed_date

Overview

APPS.PA_CC_BL_CUR_SEL_V is an internal Oracle E-Business Suite database view owned by the APPS schema. It is registered as a valid object in the ETRM repository with FND Design Data reference PA.PA_CC_BL_CUR_SEL_V and is classified with a View Type of "Internal." The view supports Oracle Project Costing cross-charge and transfer price processing, specifically the selection logic used when Oracle Projects bills cross-charged expenditures between provider and receiver organizations. Its name reflects its function: a current selection view for cross-charge billing (CC_BL) processing.

Because the object carries the Oracle Internal Use Only designation, it is not supported for direct customer access except through standard Oracle Applications programs. It should be treated as a supporting object for Oracle Projects reporting and diagnostic investigation rather than an integration interface. The view exposes expenditure-level detail joined to project, task, organization, person, and transfer price attributes, making it useful for reconciling how cross-charge amounts are derived and what drives the selection of expenditure items for transfer price calculation.

Underlying Base Objects

The view is defined over a set of documented base objects: PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES, PA_PROJECTS_ALL, PA_TASKS, PA_EMPLOYEES, PA_SYSTEM_LINKAGES, PA_FUNCTION_TRANSACTIONS, HR_ALL_ORGANIZATION_UNITS_TL, and FND_LANGUAGES. Supporting logic is supplied by the PL/SQL packages PA_UTILS, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY.

PA_EXPENDITURE_ITEMS_ALL and PA_EXPENDITURES_ALL provide the transaction and distribution detail. PA_PROJECTS_ALL and PA_TASKS supply project and task context, while PA_SYSTEM_LINKAGES and PA_FUNCTION_TRANSACTIONS define the cross-charge linkage between provider and receiver project/task combinations. PA_EXPENDITURE_TYPES classifies the expenditure, and the HR objects resolve organization names and person names for reporting. PA_UTILS and the HR packages supply currency conversion, name resolution, and security enforcement (HR_SECURITY restricts organization access).

Key Columns

• CALC_TP_FLAG (VARCHAR2): the flag indicating whether a transfer price should be calculated for the expenditure item. This is the column most directly related to the user's search term, "calc_tp_flag."
• EXPENDITURE_ITEM_ID / ADJUSTED_EXP_ITEM_ID / EXPENDITURE_ITEM_DATE: primary expenditure item identifier, the adjusted (reversed/prior) item reference, and the item date.
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, REVENUE_CATEGORY: project and classification context.
• PRVDR_ORGANIZATION_ID / RECVR_ORGANIZATION_ID and their name columns: provider and receiver organizations in the cross-charge relationship.
• DENOM_TP_CURRENCY_CODE, DENOM_TRANSFER_PRICE, ACCT_TP_RATE_TYPE, ACCT_TP_RATE_DATE, ACCT_TP_EXCHANGE_RATE, ACCT_TRANSFER_PRICE, PROJ_CURRENCY_CODE: transfer price and currency conversion attributes.
• BILLABLE_FLAG, NET_ZERO_FLAG, REVENUE_DISTRIBUTED_FLAG, CROSS_CHARGE_CODE, SYSTEM_LINKAGE_FUNCTION: billing, net-zero, and cross-charge linkage indicators.
• EXPENDITURE_GROUP, EXPENDITURE_ENDING_DATE, PA_DATE: grouping and period attributes.
• EMPLOYEE_NUMBER, PERSON_ID, QUANTITY, NON_LABOR_RESOURCE, JOB_ID: resource and quantity detail.
• TP_SCHEDULE_ID, TP_FIXED_DATE: transfer price schedule references.

Common Use Cases and Queries

Typical usage is diagnostic: identifying which expenditure items are selected for transfer price calculation and verifying the provider/receiver linkage. A representative query filtered on the flag is:

• SELECT expenditure_item_id, project_id, task_id, calc_tp_flag, prvdr_organization_id, recvr_organization_id, acct_transfer_price FROM apps.pa_cc_bl_cur_sel_v WHERE calc_tp_flag = 'Y';
• Join to PA_PROJECTS_ALL and PA_TASKS by PROJECT_ID/TASK_ID to add project numbers and task numbers for reconciliation.
• Aggregate by PRVDR_ORGANIZATION_NAME and RECVR_ORGANIZATION_NAME to summarize cross-charge activity by organization.
• Filter on EXPENDITURE_ENDING_DATE or PA_DATE to scope a specific project accounting period.

Because HR_SECURITY is referenced, results may be restricted by the organization security profile of the connecting user, which should be considered when reconciling totals.