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.AHL_LTP_RESRC_LEVL_PVT dependencies on MFG_LOOKUPS

Line 888: FROM bom_resources d, mfg_lookups m

884: SELECT d.resource_code,
885: d.description,
886: d.resource_type,
887: m.meaning resource_type_mean
888: FROM bom_resources d, mfg_lookups m
889: WHERE d.resource_id = l_resource_id
890: AND d.resource_type = m.lookup_code
891: AND m.lookup_type = 'BOM_RESOURCE_TYPE';
892:

Line 2569: mfg_lookups M

2565: SELECT a.RESOURCE_TYPE,a.RESOURCE_CODE,a.DESCRIPTION,
2566: B.CAPACITY_UNITS, M.meaning resource_type_mean
2567: FROM bom_resources A,
2568: bom_department_resources B,
2569: mfg_lookups M
2570: WHERE a.resource_id = B.resource_id
2571: AND B.resource_id = p_bom_resource_id
2572: AND B.department_id = p_bom_department_id
2573: AND A.resource_type = M.lookup_code

Line 2688: FROM bom_resources b, mfg_lookups m

2684: -- yazhou 17Aug2005 starts
2685: -- bug fix #4559462
2686: CURSOR l_get_bom_rsrc_dtls_csr(p_rsrc_id IN NUMBER) IS
2687: SELECT b.RESOURCE_TYPE, b.RESOURCE_CODE, b.DESCRIPTION, m.meaning
2688: FROM bom_resources b, mfg_lookups m
2689: WHERE b.resource_type = m.lookup_code
2690: AND m.lookup_type = 'BOM_RESOURCE_TYPE'
2691: AND resource_id = p_rsrc_id;
2692: -- yazhou 17Aug2005 ends