APPS.BOM_RTG_OI_UTIL dependencies on BOM_DEPARTMENTS

Line 639: FROM BOM_DEPARTMENTS bd

635: /* Update the department code from the department id */
636:
637: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
638: SET department_code = (SELECT department_code
639: FROM BOM_DEPARTMENTS bd
640: WHERE bd.department_id = BOSI.department_id
641: and bd.organization_id = BOSI.organization_id)
642: WHERE process_flag = 1
643: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)