APPS.EAM_ASSIGN_EMP_PUB dependencies on BOM_RESOURCES

Line 753: --get the resource code for the resource id from bom_resources

749: AND bdri2.resource_id = bdr.resource_id
750: AND ( p_department_id IS NULL OR bdr.department_id = p_department_id )
751: AND ( p_department_id IS NULL OR bdri2.department_id = p_department_id OR bdri2.department_id = bdr.share_from_dept_id ) ;
752:
753: --get the resource code for the resource id from bom_resources
754: CURSOR l_res_code_csr_type(p_resource_id IN NUMBER) IS
755: SELECT br.resource_code,
756: br.unit_of_measure as uom_code
757: FROM bom_resources br

Line 757: FROM bom_resources br

753: --get the resource code for the resource id from bom_resources
754: CURSOR l_res_code_csr_type(p_resource_id IN NUMBER) IS
755: SELECT br.resource_code,
756: br.unit_of_measure as uom_code
757: FROM bom_resources br
758: WHERE br.resource_id = p_resource_id;
759:
760: --get the department code for the department from bom_departments
761: CURSOR l_dept_code_csr_type(p_department_id IN NUMBER) IS

Line 796: bom_resources br

792: ) AS WorkOrderName,
793: (
794: SELECT br.resource_code
795: FROM bom_resource_employees bre,
796: bom_resources br
797: WHERE bre.instance_id = woru.instance_id
798: AND bre.organization_id = woru.organization_id
799: AND bre.effective_start_date <= sysdate
800: AND bre.effective_end_date > sysdate

Line 1299: bom_resources br

1295: ) AS WorkOrderName,
1296: (
1297: SELECT br.resource_code
1298: FROM bom_resource_employees bre,
1299: bom_resources br
1300: WHERE bre.instance_id = woru.instance_id
1301: AND bre.organization_id = woru.organization_id
1302: AND bre.effective_start_date <= sysdate
1303: AND bre.effective_end_date > sysdate

Line 1400: FROM wip_operation_resources wor, bom_resources br

1396: AND wo.repetitive_schedule_id IS NULL;
1397:
1398: CURSOR l_res_csr_type(p_wip_entity_id IN NUMBER,p_organization_id IN NUMBER,p_op_seq_num IN NUMBER) IS
1399: SELECT wor.resource_seq_num , wor.usage_rate_or_amount
1400: FROM wip_operation_resources wor, bom_resources br
1401: WHERE wor.wip_entity_id = p_wip_entity_id
1402: AND wor.operation_seq_num = p_op_seq_num
1403: AND wor.ORGANIZATION_ID = p_organization_id
1404: AND wor.repetitive_schedule_id IS NULL