eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FP_ELIGIBLE_CI_V

Line 4719: from PA_FP_ELIGIBLE_CI_V pfca

4715: nvl(sum(decode(c_margin_derived_from_code,'B',
4716: nvl(pfca.burdened_cost,0),
4717: nvl(pfca.raw_cost,0))),0) as cost,
4718: nvl(sum(nvl(pfca.revenue,0)),0)
4719: from PA_FP_ELIGIBLE_CI_V pfca
4720: where pfca.project_id = c_project_id
4721: and pfca.PROJECT_SYSTEM_STATUS_CODE = c_system_status_code;
4722: */
4723: -- For ALL change order versions (meaning same plan type is designated as

Line 5988: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.

5984: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
5985:
5986: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
5987: -- change order versions, there would be two records in pa_pt_co_impl_statuses
5988: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.
5989: -- How to avoid double count here? If ci_version is 'ALL' and target version is
5990: -- also 'ALL', then compute quantity only if p_pt_ct_version_type is 'COST' as
5991: -- in this case Quantity gets merged along with cost amounts
5992:

Line 6296: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.

6292: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6293:
6294: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6295: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6296: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.
6297: -- How to avoid double count here? If ci_version is 'ALL' and target version is
6298: -- also 'ALL', then compute quantity only if p_pt_ct_version_type is 'COST' as
6299: -- in this case Quantity gets merged along with cost amounts
6300:

Line 6606: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double

6602: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6603:
6604: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6605: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6606: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6607: -- count revenue amount would be returned only if p_pt_ct_version_type is 'REVENUE'
6608:
6609: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case
6610: -- values are returned without bothering about double count.

Line 6806: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double

6802: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6803:
6804: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6805: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6806: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6807: -- count cost amount would be returned only if p_pt_ct_version_type is 'COST'
6808:
6809: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case
6810: -- values are returned without bothering about double count.

Line 7053: from PA_FP_ELIGIBLE_CI_V pfca

7049: c_budget_version_id,
7050: pfca.CI_VERSION_ID,
7051: pfca.REVENUE,
7052: pfca.PT_CT_VERSION_TYPE),0)),0) as revenue
7053: from PA_FP_ELIGIBLE_CI_V pfca
7054: where pfca.project_id = c_project_id
7055: and pfca.fin_plan_type_id = c_fin_plan_type_id
7056: and pfca.CI_VERSION_TYPE <>
7057: decode(c_version_type,'COST','REVENUE','REVENUE','COST','ALL','-99')