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.

[Home] [Help]

APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 1478: PA_RBS_PRJ_ASSIGNMENTS asg,

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
1481: where
1482: g_extraction_type in ('FULL', 'PARTIAL') and

Line 1562: PA_RBS_PRJ_ASSIGNMENTS asg,

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
1565: where
1566: g_extraction_type in ('FULL', 'PARTIAL') and

Line 1645: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch

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
1649: asg.PROJECT_ID = tmp7.PROJECT_ID and

Line 1723: PA_RBS_PRJ_ASSIGNMENTS asg,

1719: bal.BILL_QUANTITY,
1720: bal.cbs_version_id,
1721: bal.cbs_element_id
1722: from PJI_FP_TXN_ACCUM bal,
1723: PA_RBS_PRJ_ASSIGNMENTS asg,
1724: PA_FIN7_OLAP fin7,
1725: pa_projects_all pa,
1726: pa_pjt_proj_batch batch
1727: where

Line 2371: PA_RBS_PRJ_ASSIGNMENTS asg,

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
2374: where
2375: g_extraction_type in ('FULL', 'PARTIAL') and

Line 2456: PA_RBS_PRJ_ASSIGNMENTS asg,

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
2459: where
2460: g_extraction_type in ('FULL', 'PARTIAL') and

Line 2540: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch

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
2544: asg.PROJECT_ID = tmp7.PROJECT_ID and

Line 2619: PA_RBS_PRJ_ASSIGNMENTS asg,

2615: bal.BILL_QUANTITY,
2616: bal.cbs_version_id,
2617: bal.cbs_element_id
2618: from PJI_FP_TXN_ACCUM bal,
2619: PA_RBS_PRJ_ASSIGNMENTS asg,
2620: PA_FIN7_OLAP fin7,
2621: pa_projects_all pa,
2622: pa_pjt_proj_batch batch
2623: where