DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPARTMENT_RESOURCES

Line 108: bom_department_resources bdr,

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

Line 177: from bom_department_resources bdr, bom_departments bd

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

Line 854: bom_department_resources bdr,

850: l_activity_name,
851: l_standard_rate_flag
852: from
853: cst_activities ca,
854: bom_department_resources bdr,
855: bom_resources br
856: where br.organization_id = l_organization_id
857: and bdr.department_id = (select department_id
858: from wip_operations