APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_RESOURCES

Line 454: from bom_resources

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

Line 1952: bom_resources where

1948:
1949:
1950: 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
1951: select resource_code into l_resource_name from
1952: bom_resources where
1953: resource_id = l_resource_id and
1954: organization_id = l_org_id;
1955: end if;
1956:

Line 2118: bom_resources br

2114: (select meaning from mfg_lookups m1 where m1.lookup_type like 'BOM_RESOURCE_TYPE' and m1.lookup_code = 2) meaning,
2115: to_char(br.resource_id) as res_id
2116: from cst_activities ca,
2117: bom_department_resources bdr,
2118: bom_resources br
2119: where br.resource_id = bdr.resource_id and
2120: br.default_activity_id = ca.activity_id (+) and
2121: nvl(ca.disable_date(+),sysdate+1) > sysdate and
2122: nvl(br.disable_date,sysdate+1) > sysdate and (ca.organization_id is