DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPARTMENT_RESOURCES

Line 107: bom_department_resources bdr,

103: CURSOR c_res_cur IS --rhshriva
104: select br.resource_id,br.resource_code,br.resource_type
105: from
106: cst_activities ca,
107: bom_department_resources bdr,
108: bom_resources br
109: where br.organization_id = p_organization_id
110: and bdr.department_id = (select department_id
111: from wip_operations

Line 181: from bom_department_resources bdr, bom_departments bd

177: Resources can be charged w/o an employee.Proper employee are fetched in Employees LOV in JSP */
178:
179: CURSOR c_charge_dept_cur(l_temp_res_id4 NUMBER) IS
180: select distinct bd.department_code, bd.department_id
181: from bom_department_resources bdr, bom_departments bd
182: where bdr.department_id = bd.department_id
183: and bdr.resource_id = l_temp_res_id4 ;
184:
185:

Line 787: bom_department_resources bdr,

783: l_activity_name,
784: l_standard_rate_flag
785: from
786: cst_activities ca,
787: bom_department_resources bdr,
788: bom_resources br
789: where br.organization_id = l_organization_id
790: and bdr.department_id = (select department_id
791: from wip_operations