DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on BOM_DEPARTMENTS

Line 1208: ,bom_departments bd

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
1212: GROUP BY br.resource_code