APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 2568: bom_department_resources B,

2564: p_bom_department_id IN NUMBER) IS
2565: SELECT a.RESOURCE_TYPE,a.RESOURCE_CODE,a.DESCRIPTION,
2566: B.CAPACITY_UNITS, M.meaning resource_type_mean
2567: FROM bom_resources A,
2568: bom_department_resources B,
2569: mfg_lookups M
2570: WHERE a.resource_id = B.resource_id
2571: AND B.resource_id = p_bom_resource_id
2572: AND B.department_id = p_bom_department_id

Line 2815: bom_department_resources c

2811: a.quantity,
2812: b.bom_resource_id
2813: FROM ahl_rt_oper_resources a,
2814: ahl_resource_mappings b,
2815: bom_department_resources c
2816: WHERE a.aso_resource_id = b. aso_resource_id
2817: AND a.object_id = l_route_id
2818: AND b.bom_resource_id = c.resource_id
2819: AND b.bom_org_id = l_org_id

Line 2834: bom_department_resources c

2830: a.quantity,
2831: b.bom_resource_id
2832: FROM ahl_rt_oper_resources a,
2833: ahl_resource_mappings b,
2834: bom_department_resources c
2835: WHERE a.object_id = l_operation_id
2836: AND a.ASSOCIATION_TYPE_CODE = 'OPERATION'
2837: AND a.aso_resource_id = b. aso_resource_id
2838: AND b.bom_resource_id = c.resource_id

Line 4664: bom_department_resources B

4660: CURSOR l_get_bom_rsrc_dtls_csr(p_bom_resource_id IN NUMBER,
4661: p_bom_department_id IN NUMBER) IS
4662: SELECT B.CAPACITY_UNITS,a.description
4663: FROM bom_resources A,
4664: bom_department_resources B
4665: WHERE a. resource_id = B.resource_id
4666: AND B.resource_id = p_bom_resource_id
4667: AND B.department_id = p_bom_department_id;
4668: