DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on BOM_DEPARTMENT_RESOURCES

Line 1207: ,bom_department_resources bdr

1203: CURSOR get_resource_dept_code_cur(p_resource_id NUMBER) IS
1204: SELECT br.resource_code
1205: ,bd.department_code
1206: FROM bom_resources br
1207: ,bom_department_resources bdr
1208: ,bom_departments bd
1209: WHERE br.resource_id = p_resource_id
1210: AND bdr.resource_id = p_resource_id
1211: AND bd.department_id = bdr.department_id