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_PPR_OLAP_CONC_PROGRAM dependencies on PA_STAGE1_BATCH_OLAP

Line 1044: PA_STAGE1_BATCH_OLAP map,

1040: bal.BILL_QUANTITY,
1041: bal.cbs_version_id,
1042: bal.cbs_element_id
1043: from
1044: PA_STAGE1_BATCH_OLAP map,
1045: PJI_FP_TXN_ACCUM bal,
1046: pa_projects_all pa,
1047: pa_pjt_proj_batch batch
1048: where

Line 1125: PA_STAGE1_BATCH_OLAP map,

1121: to_number(null) BILL_QUANTITY,
1122: bal.cbs_version_id,
1123: bal.cbs_element_id
1124: from
1125: PA_STAGE1_BATCH_OLAP map,
1126: PJI_FP_TXN_ACCUM1 bal,
1127: pa_projects_all pa,
1128: pa_pjt_proj_batch batch
1129: where

Line 1206: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

1202: tmp7.BILL_QUANTITY,
1203: tmp7.cbs_version_id,
1204: tmp7.cbs_element_id
1205: from
1206: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1207: pa_projects_all pa, pa_pjt_proj_batch batch
1208: where
1209: g_extraction_type = 'INCREMENTAL'
1210: and tmp7.project_id = proj_batch.project_id (+) and

Line 1476: PA_STAGE1_BATCH_OLAP map,

1472: bal.BILL_QUANTITY,
1473: bal.cbs_version_id,
1474: bal.cbs_element_id
1475: from
1476: PA_STAGE1_BATCH_OLAP map,
1477: PJI_FP_TXN_ACCUM bal,
1478: PA_RBS_PRJ_ASSIGNMENTS asg,
1479: pa_projects_all pa,
1480: pa_pjt_proj_batch batch

Line 1560: PA_STAGE1_BATCH_OLAP map,

1556: to_number(null) BILL_QUANTITY,
1557: bal.cbs_version_id,
1558: bal.cbs_element_id
1559: from
1560: PA_STAGE1_BATCH_OLAP map,
1561: PJI_FP_TXN_ACCUM1 bal,
1562: PA_RBS_PRJ_ASSIGNMENTS asg,
1563: pa_projects_all pa,
1564: pa_pjt_proj_batch batch

Line 1644: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

1640: tmp7.BILL_QUANTITY,
1641: tmp7.cbs_version_id,
1642: tmp7.cbs_element_id
1643: from
1644: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1645: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
1646: where
1647: g_extraction_type = 'INCREMENTAL'
1648: and tmp7.project_id = proj_batch.project_id (+) and

Line 1932: PA_STAGE1_BATCH_OLAP map,

1928: bal.BILL_QUANTITY,
1929: bal.cbs_version_id,
1930: bal.cbs_element_id
1931: from
1932: PA_STAGE1_BATCH_OLAP map,
1933: PJI_FP_TXN_ACCUM bal,
1934: pa_projects_all pa,
1935: pa_pjt_proj_batch batch
1936: where

Line 2014: PA_STAGE1_BATCH_OLAP map,

2010: to_number(null) BILL_QUANTITY,
2011: bal.cbs_version_id,
2012: bal.cbs_element_id
2013: from
2014: PA_STAGE1_BATCH_OLAP map,
2015: PJI_FP_TXN_ACCUM1 bal,
2016: pa_projects_all pa,
2017: pa_pjt_proj_batch batch
2018: where

Line 2096: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

2092: tmp7.BILL_QUANTITY,
2093: tmp7.cbs_version_id,
2094: tmp7.cbs_element_id
2095: from
2096: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2097: pa_projects_all pa, pa_pjt_proj_batch batch
2098: where
2099: g_extraction_type = 'INCREMENTAL'
2100: and tmp7.project_id = proj_batch.project_id (+) and

Line 2369: PA_STAGE1_BATCH_OLAP map,

2365: bal.BILL_QUANTITY,
2366: bal.cbs_version_id,
2367: bal.cbs_element_id
2368: from
2369: PA_STAGE1_BATCH_OLAP map,
2370: PJI_FP_TXN_ACCUM bal,
2371: PA_RBS_PRJ_ASSIGNMENTS asg,
2372: pa_projects_all pa,
2373: pa_pjt_proj_batch batch

Line 2454: PA_STAGE1_BATCH_OLAP map,

2450: to_number(null) BILL_QUANTITY,
2451: bal.cbs_version_id,
2452: bal.cbs_element_id
2453: from
2454: PA_STAGE1_BATCH_OLAP map,
2455: PJI_FP_TXN_ACCUM1 bal,
2456: PA_RBS_PRJ_ASSIGNMENTS asg,
2457: pa_projects_all pa,
2458: pa_pjt_proj_batch batch

Line 2539: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

2535: tmp7.BILL_QUANTITY,
2536: tmp7.cbs_version_id,
2537: tmp7.cbs_element_id
2538: from
2539: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2540: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
2541: where
2542: g_extraction_type = 'INCREMENTAL'
2543: and tmp7.project_id = proj_batch.project_id (+) and