APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_RESOURCES

Line 455: from bom_resources

451: if (l_resource is not null) then
452:
453: select resource_code , unit_of_measure
454: into l_resource_code , l_uom
455: from bom_resources
456: where resource_id = l_resource
457: and organization_id = l_organization_id ;
458:
459: end if;

Line 1959: bom_resources where

1955:
1956:
1957: if l_resource_id <> -9999 and l_org_id <> -9999 and l_resource_id is not null and l_org_id is not null then
1958: select resource_code into l_resource_name from
1959: bom_resources where
1960: resource_id = l_resource_id and
1961: organization_id = l_org_id;
1962: end if;
1963:

Line 2125: bom_resources br

2121: (select meaning from mfg_lookups m1 where m1.lookup_type like 'BOM_RESOURCE_TYPE' and m1.lookup_code = 2) meaning,
2122: to_char(br.resource_id) as res_id
2123: from cst_activities ca,
2124: bom_department_resources bdr,
2125: bom_resources br
2126: where br.resource_id = bdr.resource_id and
2127: br.default_activity_id = ca.activity_id (+) and
2128: nvl(ca.disable_date(+),sysdate+1) > sysdate and
2129: nvl(br.disable_date,sysdate+1) > sysdate and (ca.organization_id is