APPS.BOM_RTG_OI_UTIL dependencies on BOM_DEPARTMENTS

Line 637: FROM BOM_DEPARTMENTS bd

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