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_RBS_UTILS dependencies on FND_LANGUAGES

Line 585: fnd_languages l

581: FROM
582: pa_rbs_element_names_b a,
583: pa_rbs_elem_in_temp b,
584: per_all_people_f c,
585: fnd_languages l
586: WHERE a.resource_source_id = b.resource_source_id
587: AND a.resource_type_id = p_resource_type_id
588: AND b.resource_type_id = p_resource_type_id
589: AND c.person_Id = a.resource_source_id

Line 625: Fnd_Languages L

621: FROM
622: pa_rbs_element_names_b a,
623: pa_rbs_elem_in_temp b,
624: Per_Jobs c,
625: Fnd_Languages L
626: WHERE a.resource_source_id = b.resource_source_id
627: AND a.resource_type_id = p_resource_type_id
628: AND b.resource_type_id = p_resource_type_id
629: AND c.Job_Id = a.resource_source_id

Line 706: Fnd_Languages L

702: FROM
703: pa_rbs_element_names_b a,
704: pa_rbs_elem_in_temp b,
705: Bom_Resources c,
706: Fnd_Languages L
707: WHERE a.resource_source_id = b.resource_source_id
708: and c.resource_id = a.resource_source_id
709: AND a.resource_type_id = p_resource_type_id
710: AND b.resource_type_id = p_resource_type_id

Line 745: Fnd_Languages L

741: FROM
742: pa_rbs_element_names_b a,
743: pa_rbs_elem_in_temp b,
744: pa_non_labor_resources c,
745: Fnd_Languages L
746: WHERE a.resource_source_id = b.resource_source_id
747: AND a.resource_type_id = p_resource_type_id
748: AND b.resource_type_id = p_resource_type_id
749: and c.non_labor_resource_id = a.resource_source_id

Line 821: Fnd_Languages L

817: FROM
818: pa_rbs_element_names_b a,
819: pa_rbs_elem_in_temp b,
820: Pa_rbs_element_map c,
821: Fnd_Languages L
822: WHERE a.resource_source_id = b.resource_source_id
823: AND a.resource_type_id = p_resource_type_id
824: AND b.resource_type_id = p_resource_type_id
825: and c.resource_id = a.resource_source_id

Line 902: Fnd_Languages L

898: FROM
899: pa_rbs_element_names_b a,
900: pa_rbs_elem_in_temp b,
901: pa_event_types c,
902: Fnd_Languages L
903: WHERE a.resource_source_id = b.resource_source_id
904: and c.event_type_id = a.resource_source_id
905: AND a.resource_type_id = p_resource_type_id
906: AND b.resource_type_id = p_resource_type_id

Line 941: Fnd_Languages L

937: FROM
938: pa_rbs_element_names_b a,
939: pa_rbs_elem_in_temp b,
940: pa_expenditure_types c,
941: Fnd_Languages L
942: WHERE a.resource_source_id = b.resource_source_id
943: and c.expenditure_type_id = a.resource_source_id
944: AND a.resource_type_id = p_resource_type_id
945: AND b.resource_type_id = p_resource_type_id

Line 980: Fnd_Languages L

976: FROM
977: pa_rbs_element_names_b a,
978: pa_rbs_elem_in_temp b,
979: pa_expenditure_categories c,
980: Fnd_Languages L
981: WHERE a.resource_source_id = b.resource_source_id
982: and c.expenditure_category_id = a.resource_source_id
983: AND a.resource_type_id = p_resource_type_id
984: AND b.resource_type_id = p_resource_type_id

Line 1019: Fnd_Languages L

1015: FROM
1016: pa_rbs_element_names_b a,
1017: pa_rbs_elem_in_temp b,
1018: po_vendors c,
1019: Fnd_Languages L
1020: WHERE a.resource_source_id = b.resource_source_id
1021: and c.vendor_id = a.resource_source_id
1022: AND a.resource_type_id = p_resource_type_id
1023: AND b.resource_type_id = p_resource_type_id

Line 1154: Fnd_Languages L,

1150: FND_GLOBAL.LOGIN_ID
1151: FROM
1152: pa_rbs_element_names_b a,
1153: pa_rbs_elem_in_temp b,
1154: Fnd_Languages L,
1155: Mtl_Categories_v c
1156: WHERE a.resource_source_id = b.resource_source_id
1157: and c.category_id = a.resource_source_id
1158: AND a.resource_type_id = p_resource_type_id

Line 1719: Fnd_Languages L

1715: fnd_global.user_id,
1716: fnd_global.login_id
1717: FROM bom_resources b,
1718: pa_rbs_element_names_b a,
1719: Fnd_Languages L
1720: WHERE a.resource_type_id = 1
1721: AND b.resource_id = a.resource_source_id
1722: AND l.Installed_Flag in ('I', 'B'));
1723: END IF;

Line 1760: Fnd_Languages L

1756: fnd_global.user_id,
1757: fnd_global.login_id
1758: FROM bom_resources b,
1759: pa_rbs_element_names_b a,
1760: Fnd_Languages L
1761: WHERE a.resource_type_id = 2
1762: AND b.resource_id = a.resource_source_id
1763: and L.Installed_Flag in ('I', 'B'));
1764: END IF;

Line 1801: Fnd_Languages L

1797: fnd_global.user_id,
1798: fnd_global.login_id
1799: FROM per_all_people_f per,
1800: pa_rbs_element_names_b b,
1801: Fnd_Languages L
1802: WHERE TRUNC(sysdate) BETWEEN
1803: effective_start_date AND
1804: NVL(effective_end_date,TRUNC(sysdate))
1805: AND b.resource_type_id=3

Line 1845: Fnd_Languages L

1841: fnd_global.user_id,
1842: fnd_global.login_id
1843: FROM PA_EVENT_TYPES E,
1844: pa_rbs_element_names_b a,
1845: Fnd_Languages L
1846: WHERE a.resource_type_id=4
1847: AND E.event_type_id=a.resource_source_id
1848: AND L.Installed_Flag in ('I', 'B'));
1849: END IF;

Line 1887: Fnd_Languages L

1883: fnd_global.user_id,
1884: fnd_global.login_id
1885: FROM pa_expenditure_categories ec,
1886: pa_rbs_element_names_b a,
1887: Fnd_Languages L
1888: WHERE a.resource_type_id = 5
1889: AND ec.EXPENDITURE_CATEGORY_ID =
1890: a.resource_source_id
1891: AND L.Installed_Flag in ('I', 'B'));

Line 1928: Fnd_Languages L

1924: fnd_global.user_id,
1925: fnd_global.login_id
1926: FROM pa_expenditure_types ec,
1927: pa_rbs_element_names_b a,
1928: Fnd_Languages L
1929: WHERE a.resource_type_id = 6
1930: AND ec.EXPENDITURE_TYPE_ID =
1931: a.resource_source_id
1932: AND L.Installed_Flag in ('I', 'B'));

Line 1969: Fnd_Languages L,

1965: sysdate,
1966: fnd_global.user_id,
1967: fnd_global.login_id
1968: FROM mtl_categories_v c,
1969: Fnd_Languages L,
1970: pa_rbs_element_names_b a
1971: WHERE a.resource_source_id=c.CATEGORY_ID
1972: AND a.resource_type_id=7
1973: AND L.Installed_Flag in ('I', 'B'));

Line 2053: Fnd_Languages L

2049: fnd_global.user_id,
2050: fnd_global.login_id
2051: FROM per_jobs job,
2052: pa_rbs_element_names_b a,
2053: Fnd_Languages L
2054: WHERE a.resource_type_id=9
2055: AND a.resource_source_id=job.job_id
2056: AND L.Installed_Flag in ('I', 'B'));
2057:

Line 2093: Fnd_Languages L

2089: fnd_global.user_id,
2090: fnd_global.login_id
2091: FROM hr_all_organization_units_tl tl,
2092: pa_rbs_element_names_b a,
2093: Fnd_Languages L
2094: WHERE tl.organization_id = a.resource_source_id
2095: AND a.resource_type_id = 10);
2096: END IF;
2097:

Line 2173: Fnd_Languages L

2169: fnd_global.user_id,
2170: fnd_global.login_id
2171: FROM pa_non_labor_resources r,
2172: pa_rbs_element_names_b a,
2173: Fnd_Languages L
2174: WHERE a.resource_source_id =
2175: r.non_labor_resource_id
2176: AND a.resource_type_id = 12
2177: AND L.Installed_Flag in ('I', 'B'));

Line 2328: Fnd_Languages L

2324: fnd_global.user_id,
2325: fnd_global.login_id
2326: FROM po_vendors v,
2327: pa_rbs_element_names_b a,
2328: Fnd_Languages L
2329: WHERE a.resource_type_id = 16
2330: AND a.resource_source_id = v.vendor_id
2331: AND L.Installed_Flag in ('I', 'B'));
2332: END IF;

Line 2369: Fnd_Languages L

2365: fnd_global.user_id,
2366: fnd_global.login_id
2367: FROM pa_rbs_element_map map,
2368: pa_rbs_element_names_b a,
2369: Fnd_Languages L
2370: WHERE a.resource_type_id = 18
2371: AND a.resource_source_id = map.resource_id
2372: AND L.Installed_Flag in ('I', 'B'));
2373: END IF;

Line 3891: from pa_rbs_element_names_tl B, FND_LANGUAGES L

3887: B.RBS_ELEMENT_NAME_ID,
3888: B.RESOURCE_NAME,
3889: L.LANGUAGE_CODE,
3890: B.SOURCE_LANG
3891: from pa_rbs_element_names_tl B, FND_LANGUAGES L
3892: where L.INSTALLED_FLAG in ('I', 'B')
3893: and B.LANGUAGE = userenv('LANG')
3894: and not exists
3895: (select NULL