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 4775: from PA_FP_ELIGIBLE_CI_V pfca

4771: nvl(sum(decode(c_margin_derived_from_code,'B',
4772: nvl(pfca.burdened_cost,0),
4773: nvl(pfca.raw_cost,0))),0) as cost,
4774: nvl(sum(nvl(pfca.revenue,0)),0)
4775: from PA_FP_ELIGIBLE_CI_V pfca
4776: where pfca.project_id = c_project_id
4777: and pfca.PROJECT_SYSTEM_STATUS_CODE = c_system_status_code;
4778: */
4779: -- For ALL change order versions (meaning same plan type is designated as

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

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

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

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

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

6658: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6659:
6660: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6661: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6662: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6663: -- count revenue amount would be returned only if p_pt_ct_version_type is 'REVENUE'
6664:
6665: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case
6666: -- values are returned without bothering about double count.

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

6871: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6872:
6873: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6874: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6875: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6876: -- count cost amount would be returned only if p_pt_ct_version_type is 'COST'
6877:
6878: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case
6879: -- values are returned without bothering about double count.

Line 7125: from PA_FP_ELIGIBLE_CI_V pfca

7121: c_budget_version_id,
7122: pfca.CI_VERSION_ID,
7123: pfca.REVENUE,
7124: pfca.PT_CT_VERSION_TYPE),0)),0) as revenue
7125: from PA_FP_ELIGIBLE_CI_V pfca
7126: where pfca.project_id = c_project_id
7127: and pfca.fin_plan_type_id = c_fin_plan_type_id
7128: and pfca.CI_VERSION_TYPE <>
7129: decode(c_version_type,'COST','REVENUE','REVENUE','COST','ALL','-99')