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.PJI_FM_EXTR dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1213: From pa_cost_distribution_lines_all cdl

1209: , decode(cdl.Billable_Flag
1210: , 'Y', decode(cdl.line_type,'R',cdl.Quantity,0)
1211: , 0) AS BILL_QUANTITY /* Modified for bug 9777532 */
1212: , cdl.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
1213: From pa_cost_distribution_lines_all cdl
1214: Where 1 = 1
1215: And cdl.line_type in ('R','I')
1216: And nvl(cdl.pji_summarized_flag,'Y') <> 'N'
1217: And cdl.gl_date is not null

Line 1596: PA_COST_DISTRIBUTION_LINES_ALL cdl

1592: , null
1593: , cdl.PJI_SUMMARIZED_FLAG
1594: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold)
1595: FROM
1596: PA_COST_DISTRIBUTION_LINES_ALL cdl
1597: WHERE
1598: cdl.LINE_TYPE in ('R', 'I') and
1599: cdl.PJI_SUMMARIZED_FLAG = 'N';
1600:

Line 1640: , pa_cost_distribution_lines_all cdl

1636: , bat.project_type_class
1637: , cdl.pji_summarized_flag
1638: FROM
1639: pji_fm_proj_batch_map bat
1640: , pa_cost_distribution_lines_all cdl
1641: WHERE
1642: bat.worker_id = p_worker_id
1643: and cdl.project_id = bat.project_id
1644: and cdl.line_type in ('R','I')

Line 1661: , pa_cost_distribution_lines_all cdl

1657: , bat.project_type_class
1658: , cdl.pji_summarized_flag
1659: FROM
1660: pji_fm_proj_batch_map bat
1661: , pa_cost_distribution_lines_all cdl
1662: WHERE
1663: bat.worker_id = p_worker_id
1664: and cdl.project_id = bat.project_id
1665: and cdl.line_type in ('R','I')

Line 2187: , pa_cost_distribution_lines_all cdl

2183: , 0) AS BILL_QUANTITY /* Modified for bug 9777532 */
2184: ,cdl.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
2185: FROM
2186: PJI_FM_REXT_CDL scope
2187: , pa_cost_distribution_lines_all cdl
2188: , pa_expenditure_items_all ei
2189: , pa_expenditures_all exp
2190: , pa_expenditure_types et
2191: WHERE

Line 2456: update PA_COST_DISTRIBUTION_LINES_ALL cdl

2452: if (sql%rowcount <> 0) then
2453:
2454: commit;
2455:
2456: update PA_COST_DISTRIBUTION_LINES_ALL cdl
2457: set cdl.PJI_SUMMARIZED_FLAG = null
2458: where cdl.ROWID in (select /*+ cardinality(cdl, 1) */
2459: cdl.CDL_ROWID
2460: from PJI_FM_REXT_CDL cdl