DBA Data[Home] [Help]

APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_DEPARTMENT_RESOURCES

Line 2124: bom_department_resources bdr,

2120: to_char(bdr.department_id) as department_id,
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

Line 2180: bom_department_resources bdr,

2176: bdri.resource_id as resource_id
2177: from bom_dept_res_instances bdri,
2178: bom_departments bd,
2179: bom_resource_employees bre,
2180: bom_department_resources bdr,
2181: per_people_f ppf
2182: where bdri.instance_id = bre.instance_id
2183: and ppf.person_id = bre.person_id
2184: and sysdate >= ppf.effective_start_date and sysdate <= ppf.effective_end_date