214: , BOR.ATTRIBUTE15 ATTRIBUTE15
215: , null RETURN_STATUS
216: , 1 TRANSACTION_TYPE
217: FROM BOM_RESOURCES BR
218: , BOM_OPERATION_RESOURCES BOR
219: , BOM_OPERATION_SEQUENCES BOS
220: , BOM_OPERATIONAL_ROUTINGS BORT
221: WHERE BORT.assembly_item_id = p_eam_wo_rec.asset_activity_id
222: AND BORT.organization_id = p_eam_wo_rec.organization_id